what is line item dimension tell me brief
Answers were Sorted based on User's Feedback
Answer / david
When dimension table contains only one characteristic, we can call it as a line item dimension. In line item dimension SID table is directly connected with fact table.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sravan
if the size of the cube is more than the fact table then
you can make that cube as a line item dimension and the sid
table will directly link up with the fact table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / siddhardha
if Dimension table size(no of rows)exceeds more than 20% of fact table,then the dimension should be flagged as Line Item Dimension. This means that dimension table.Instead,the SID table characteristic takes the role of the dimension table.
Is This Answer Correct ? | 0 Yes | 0 No |
What is the diference between defining calculated key figure in info provider level vs query level?
What is the namespace of BW?
tell me any 3 reports u have created in sd and also in fi?
Give an example of master data documentation?
I am looking for SAP BI banking reports and business content for banking. Please help
I have 10 cubes I created multiprovider I want only 1 cube data what u do?
What are the important aggregation usage indicators?
How to transport bw object?
What is data ware-housing hierarchy?
can any one explain me...... what are the difference between Extractor queue and delta queue?
What are events and how you use it in BW?
Can you restart the conversion?