what is line item dimension? when we need them?
how we will come to know we need to create line item
dimensions?
Answer Posted / murali
When dimension table size equals or exceeds the fact table
at that point time we need to use the line item dimension.
If we use Line item dimension our fact table contains SID
instead of dimension ID.
For maintaining L.I.D we have to create only one object in
dimension table.
| Is This Answer Correct ? | 30 Yes | 5 No |
Post New Answer View All Answers
What is the Bex options for characteristics like F4 help for query definition and execution?
Give some examples of usage of BW statistics reports?
What is the advantage of CO-PA?
What is sap bw/bi? What is the purpose of sap bw/bi?
WHAT IS THE DIFFERENCE BETWEEN WORKBENCH REQUEST AND CUSTOMERIZIED REQUEST
What is aggregate hierarchy?
Give the step by step approach to set up LIS?
What is modelling?
How do you debug user exit?
What is extended star schema?
Define the upgrade steps to 3.x?
List the tools to monitor overall query performance.
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?
what is meant by compounding attribute tell me the scenario?
What is the use of db connection in sap bw data acquisition?