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
what is virtual kef figures? what are the uses and in which case supposed to be use?
What is the licensing requirement you should be aware of?
Give examples of data sources that support remote cubes?
What are the sap enhancements to enhance fir data?
How would you know if a segment/segment level entry has been summarized?
how to getweekday,weekmonth,month,weekno,week order in the report by using routines?
which object based you created extended star schema?
What is the use of db connection in sap bw data acquisition?
What are the other BW processes?
What is extended star schema?
is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7
What is the procedure to create a data mart?
how the master data is read?
Explain ods?
How much time would it take to upload 1 million data to infocube?