Scribd
Upload
114 views2 pages

MicroStrategy Key Concepts Guide

Joint child is Microstrategy's way of handling composite keys by making a set of columns containing the composite keys a joint child. Drilling options for an attribute can be decided based on similarities between attributes, hierarchies and their drilling design. The two types of hierarchies are user defined and system hierarchies. The types of facts in Microstrategy are simple facts, derived facts, and implicit facts. The different types of matrices in Microstrategy are derived, nested, compound, and simple.

Uploaded by

kashif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
114 views2 pages

MicroStrategy Key Concepts Guide

Joint child is Microstrategy's way of handling composite keys by making a set of columns containing the composite keys a joint child. Drilling options for an attribute can be decided based on similarities between attributes, hierarchies and their drilling design. The two types of hierarchies are user defined and system hierarchies. The types of facts in Microstrategy are simple facts, derived facts, and implicit facts. The different types of matrices in Microstrategy are derived, nested, compound, and simple.

Uploaded by

kashif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

. Describe joint child?

It is Microstrategy way of conducting Composite Keys. To grip this case in Microstrategy


we make this set of columns, containing composite keys, as joint child.

11. How we can decided drilling options for an attribute?

Based on similarities between attributes, hierarchies and their drilling design we can
decide the drilling option.

12. Name the two types of Hierarchies?

 User defined Hierarchy


 System hierarchy

13. Name the type of Facts in Microstrategy?

 Simple facts
 Derived facts
 Implicit facts

14. Write the different types of matrices in microstrategy?

 Derived
 Nested
 Compound
 Simple

15. Define Base Formula?

Base formula is used to provide the formation of more complex metrics.

16. Define Smart Metrices?


Smart metrics is used for calculating the compound matrices with the help of subtotal
calculations for every constituent inside the compound metric.

17. Define Level Metrices?

Level metrics are modern metrics which are set to be evaluated at a particular attribute
level.

18. What is the main purpose of having conditionality in metrics?


Conditionality connects a filter

You might also like