Microstrategy Analytics

“The key specified is the true key for the warehouse table” The screen shot below illustrates the setting " The key specified is the true key for the warehouse table " in the logical view of a warehouse table: This setting is only applicable when the attributes on the template are comprised of all the attributes listed as table keys in the logical view of the fact table. Therefore, when checked, this setting forces the Structured Query Language (SQL) to not aggregate the data and to pull only from the fact tables directly. The following SQL demonstrates the difference between two identical reports when this setting is checked and when it is not. The report SQL is provided below the grid view. The first report was run against the fact table City_Subcateg_Sls without the "The key specified is the true key for the warehouse table" checked. It demonstrates aggregation by the metric: select a11.CUST_CITY_ID CUST_CITY_ID, max(a12.CUST_CITY_NAME) C...