What should I have in mind when building olap solution from scratch?
- 1 Answers
- 1102 Views
- I also Faced
- E-Mail Answers
Answer / Subhankar Dey
When building an OLAP solution, considerations include data aggregation, query optimization, and designing a hierarchical structure for dimensions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what are components of reportnet?
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is the differences between star and snowflake schemas?
What is vdl (view definition language) explain?
What are the steps to build the datawarehouse?
Code the tables statement to produce a multi-level frequency?
How to eliminate duplicate rows from flat file?
How can you import tables from a database?
What are the fundamental elements of the data warehouse?
What is the difference between star and snowflake schemas?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is Discover and Execute in XMLA?
Teradata 
