if we want to design an info cube,what are the
pre-requisites u have to take in real time?
Answer Posted / vik
1. Smaller Dimensions.
2. Few Dimensions.
3. Put-up only necessary details.
4. Hierarchies only if necessary.
5. Time-dependent structures only if necessary.
6. Avoid using MIN, MAX, Aggr for key figures in huge Info Cubes.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
Where do we use infoset in bi system?
I am looking for SAP BI banking reports and business content for banking. Please help
what is offset? Without offset we create queries?
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
What is the use of db connection in sap bw data acquisition?
What is an open hub service?
R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?
What is business content?
Can you create a data storage area in the sap bw?
What is the importance of 'start routine' in update rules?
What are the options for hierarchy node variables?
What is the process chain?
What is the maximum number of key fields that you can have in an ods object?
List the steps to do the creating classes in sap-bw