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:00January 9th, 2012|Computers, Documentation, MicroStrategy|Comments Off on MSTR: DataMart: Execute Query failed: identifier is too long

MSTR: Derived Metrics

========= QUESTION --------- I want to calculate my own Metrics based on metrics already in my report - similar to what you do with a formula in Excel, or a calculated field or Expression in Microsoft Access.   ========= ANSWER --------- This is called a Derived Metric in MSTR terminology. To create this Derived Metric, [...]

By |2017-12-01T23:47:34+00:00December 21st, 2011|Computers, Documentation, MicroStrategy|Comments Off on MSTR: Derived Metrics

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:00October 10th, 2011|Computers, Documentation, MicroStrategy|Comments Off on Write a MicroStrategy Report to a database table
Go to Top