You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.
Why would you set the "Ignore multiple outputs for filters" property in a calculation view?
You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?
You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note:
There are 2 correct answers to this question.