You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.What is the correct approach?
Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.When you preview calculation view A, what data do you see?
Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.
A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node.How many rows are in the output of your query?
Which tool generates and executes the SQL for a specific node of your calculation view?
Jessenia
4 months agoDeandrea
4 months agoBasilia
4 months agoCecily
6 months agoLai
6 months ago