MSTR: DataMart: Execute Query failed: identifier is too long

========= QUESTION --------- When attempting to execute a DataMart in MicroStrategy, it fails with the following error: --- The following History List delivery was not successful. Delivery/update and destination information: Run at: <DATE> <TIME> Error message: (QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:972: on HSTMT] [MicroStrategy][ODBC Oracle [...]

By | 2012-01-09T08:35:22+00:00 January 9th, 2012|Computers, Documentation, MicroStrategy|0 Comments

Write a MicroStrategy Report to a database table

========= QUESTION --------- How do I make a MicroStrategy report populate a database table, rather than outputting to a static report?   ========= ANSWER --------- This feature is called a DataMart. Edit the report in MSTR DesktopSelect Configure DataMart... from the Data menu  Enter a new table name* in the Table Name field*Note: the table name [...]

By | 2017-12-01T23:47:36+00:00 October 10th, 2011|Computers, Documentation, MicroStrategy|0 Comments