what is a dimension table and types? explain about line
item dimension and high cardinality and uses, in which case
suppose to be use?
Answer Posted / shri
Dimension table which holds character infobjects...
Types of Dimension tables..
Time dimension
Unit dimension
Package dimension
Line item dimension
when the dimension table contains more than 20% size of
fact table then it is a line item dimension..
in line item dimension table we will have only one
character info object..
scenario..
document number in granular infocubes..
customer numbers in coustmer-centric business like
telecommunications,banking and insurance...
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is automatic loading of similar/identical requests option?
what are the drawbacks of ods?
How to create condition and exceptions in bi.7.0?
What is the process chain and when you can use the same in the data warehouse?
What is the procedure to create a data mart?
What are the steps to load non cumulative cube?
What are value sets?
What is a dashboard in sap bw?
describe how you have used excel as a compliment to bex?
Give an example of the content key figure OTOTALSTCK (quantity total stock)?
Can you create a data storage area in the sap bw?
How would you convert an info package group to a process chain?
What is the difference between ods and info-cubes?
What are the options to calculate result as ? summation?
Explain ods?