Answer Posted / gangadhar

If the volume of the masterdara of a dimension is growing
along with the transaction data then to improve the data
read performance of master data, we can create the
dimension as line item dimension.

when we create a dimension as line item dimension, the SID
of the characteristic will be joined directly with the fact
table without using dimID's.

Disadvantages : F4 help is not possible in data selection
screens for line item dimension.

Conditions : 1. The dimension should have only one
characteristic. 2. Master data of dimension >= 20% of
transaction data of infocube(interms of records).

What is the transaction to maintain services?

1983

---

What is the difference between sending a mail to a recipient list compared to sending individual mails via a dynamic loop?

1113

---

Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)

2005

---

What is a dashboard in sap bw?

1140

---

What are the do?s and don?ts?

2109

---

Tell something you know about the dimension in the warehouse and how it can be optimized?

982

---

what do you mean by transfer routines

992

---

How do you access to source system data in bi without extraction?

1078

---

How does a navigational attribute differ from other attributes in terms of linking it with the infocube?

970

---

What is start routines.

996

---

What is ?predefined characteristics??

2675

---

I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?

3495

---

What is 1 ROWCOUNT key figure?

10199

---

In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.

1632

---

what are the benefits of ods?

1082

---