Infosys Certified Microstrategy Developer

Which of the following is/are dynamic to create the virtual attributes in MSTR?

1. Consolidation
2. Custom Groups

Consider you have 3 attributes by name ProductCategory, ProductSubCategory and Product. Do we need to specify Parent/Child relationships among them before creating a drillable hierarchy?

Which three "Pass-through" functions can be used when you want to perform OLAP operations in MSTR?

Which of the following transformation expression(s) is/are valid?

1. YearID - 2
2. CalenderQuarterID - 1
3. ProductCategoryID - 1
4. WeekId - 1

Note: All ID's are of Numeric type.

What would happen if we sort a report by one attribute and later sort the same report again by another attribute?

What all objects are required when you create a report using a Report Builder? Select from the given list of objects.

1. Template
2. Filter
3. Attributes
4. Prompts

Which of the following statements are TRUE about an Attribute Form?

1. Each attribute form must have at least one expression declared.
2. A form can have two different expressions in the same source table.
3. A form can have multiple expressions in different tables.

Which of the following statement(s) is/are TRUE regarding Page By view?

1. We cannot place a Hierarchy into Page-By view.
2. We cannot place an Object Prompt into Page-By view.
3. We can place a Metric into Page-By view.
4. We can place an Attribute into Page-By view.

Ronald is working on sales summary report and he needs data from already existing "Database Instance" available in another project source. From the below given options, what could be the best solution for Ronald?