what is line item dimension? when we need them?
how we will come to know we need to create line item
dimensions?
Answer Posted / chavid
Hen the chracteristic value (#s) is one & is larger (say
like order no. During query this ill give performance
issue. So it is better to define such chars as line item
Dims. Only SId is generated & used by fact table. R O thumb
is hen the cardinality is > 10 then it is advisable to
define the IO as L I Dim. L I Dim uses b-tree index (
default is Bipmap).
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Describe a opening balance?
what are the benefits of cubes?
Where do we use write optimized dso?
What is the calculated key figure?
what are the different components in dso architecture?
How will you schedule the job in background?
Usually we mention T or O in CONFIRMATION TYPE. What is T and O , stand for ?
Do you have any idea how to improve the performance of the bw?
How do you upload currency exchange from a flat file?
What is the use of navigational attributes?
What all data sources you have used to acquire data in sap bw system?
What is the importance of 'start routine' in update rules?
What is the read mode in generic navigation block web item- read mode specifies
how bw was found
How to create condition and exceptions in bi.7.0?