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
You want to convert bex query global structure to local structure. How would you do that?
What is the purpose of sap bw/bi?
I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
How do you debug user exit?
What is business content?
what is virtual kef figures? what are the uses and in which case supposed to be use?
What is modelling?
Where do we use write optimized dso’s?
If you are asked to change the way tables are displayed in web reporting how would you do this?
How do you use print settings?
Can you name a few important tasks which are essential in the data warehousing and management of the same?
Why if one request fails, all the subsequent requests are turned to "red"?
How to get the recordmode D or A in changelog table when we delete or add records in DSO?
Explain 0record mode?
What are the versions in objects?