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
Explain the architecture of the sap bw system?
What is translation key?
which object based you created extended star schema?
R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?
What is extraction setup?
is their any difference between bex 3.5 and bex 7.0?
I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one
In real world when do you recommend aggregate?
What are the options for conditions for key figures?
How do you use the value set in bex query?
Tell something you know about the dimension in the warehouse and how it can be optimized?
How do you check the alert monitor?
What is data flow in bw/bi?
You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?
is it possible to avoid special characteristic in infocube level permanently?