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
Give some examples of queries delivered with BW statistics?
How do you upload currency exchange from a flat file?
What is the purpose of geographical information in the sap bw?
How can you navigate to see the error idocs?
What is the maximum number of key fields that you can have in an ods object?
Can you name a few important tasks which are essential in the data warehousing and management of the same?
How would you do the archiving cubex.
What is ?predefined characteristics??
What is the format of LO data sources?
how would you do the unloading non-cumulative cubes.
What internally happens when bw objects like info object, info cube or ods are created and activated?
what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?
Describe transfer rules?
Give the step by step approach to set up LIS?
Give an example of VBA?