what is line item dimension? when we need them?
how we will come to know we need to create line item
dimensions?
Answer Posted / murali
When dimension table size equals or exceeds the fact table
at that point time we need to use the line item dimension.
If we use Line item dimension our fact table contains SID
instead of dimension ID.
For maintaining L.I.D we have to create only one object in
dimension table.
| Is This Answer Correct ? | 30 Yes | 5 No |
Post New Answer View All Answers
What is rowlevel security ? can u please explain with real time example?
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
What is SUMRT?
What is the licensing requirement you should be aware of?
What is data flow in bw/bi?
What is business content?
Why is one request falls, all the subsequent requests are turned to ?red? in an info provider?
Explain the usage of geo-coordinates ?
What is the dimension in bw?
What is a repair request?
What is the number of decimal places in scaling factor?
Explain multiprovider?
What are the settings for data transfer?
Explain the display properties?
You want to see if the execution of a query has been slow or fast. How would you do that?