How are Absolute and Standard Filters used in different scenarios? How do they differ from one another?
Latest Answer: Absolute and Standard Filters are used in Level Metrics (metrics which calculate at the specified attribute level rather than the default report level).While defining the level metric, the target attribute at which the metric should calculate is specified ...
Name the different types of testing that can be done on MicroStrategy Reports?
Latest Answer: Along with the above mentioned testings, you can also have a. conditional formatting testing or threshold testing ...
Explain what is the difference between a Fact and an Attribute.
Latest Answer: Facts: You can think of facts as numerical data which can be aggregated. The facts provide insight of how the business is performing.E.g., Sales, profit etc which are numerical and gives information about whether the business is running fine or not, are ...
What is the Significance of 'number of pass' es in a SQL?
What is the primary need for maintaining the Parent-Child relationship for attributes?
Latest Answer: If parent child relationship is not established it results in unwanted joins. As a result of this metric values are not retrieved properly due to improper joins. And alos it results in cross join which is deeply resource intensive and affects the performance. ...
How complex is compount metrics?
What are the different types of complex metrics within MicroStrategy and how do I know if candidates has experience with conditional metrics/filters?
I got an error in Microstrategy Report ...I shared the SQL with my Architect...He says he has trimmed the SQl and report is now working fine... Do any of you know how trimming a SQL is done?Thanks
Latest Answer: HI, Trimming the SQL is nothing but Optimizing the SQL by using Various VLDB Settings in the MSTR. i.e avoiding the cross join, removing multiple passes. Hope this as answered u r query. ...
Latest Answer: view filters it filter the data at microstrtegy level but repot filtr are filter the data at data base level ...
Latest Answer: Microstrategy: It is web based as well as desktop It has only one metadata repository which is centralaised repository.It doesnt support any cube dataset so we can have only current data from datawarehouse. Dont refresh dataCognos: It is web based onlyIt ...
View page [1] 2 Next >>
Go Top
