Interested to Buy Any Domain ? << Click Here >> for more details...
what is a dimension table and types? explain about line
item dimension and high cardinality and uses, in which case
suppose to be use?
- 1 Answers
- 5228 Views
- I also Faced
- E-Mail Answers
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 the importance of 'start routine' in update rules?
What is the Bex options for characteristics like F4 help for query definition and execution?
What are the options for conditions for key figures?
what is ods (operational data store)?
What is ud connect in sap bw system? How does it allow reporting in bi system?
What is a time reference characteristic?
How do you transform open hub data?
Explain business blueprint stage.
Do you have any idea how to improve the performance of the bw?
What all data sources you have used to acquire data in sap bw system?
What is the use of the info area in the sap bw system?
What is compression in the data warehouse?
What is a validity determining characteristic?
Explain the structure of direct update dso?
In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?
