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
Give an example of VBA?
what is direct schedule and what is meta chain
What does rollup do?
what is the data model and how it is use ?
What are the types of reports you can use in reporting agent?
What is the structure of infocube?
What is the issued with V3 updates prior to PI 2002?
What are the options for hierarchy node variables?
Tell something you know about the dimension in the warehouse and how it can be optimized?
Can you explain about start routines how you used in your project give me an example?
What is partitioning and what are the benefits of partitioning in an infocube?
Give examples of data sources that support remote cubes?
What are the parameters available in user exit for enhancing master data?
Can you convert an infopackage group into a process chain?
Explain the architecture of the sap bw system?