Answer Posted / balaji bathala

If you have a characteristic that can have a large no,of distinct values it is the likely the dimension which you include these char contains same no.of records. The path from Fact table to Dim Table and then to SID Table will become critical for performance. If you make this dimension as LineItem then the SAP BW will not create DIM Ids and it creates the Dimension Table and this table will act as a just view.

Directly the SID is connected to the Fact Table. Here the SID will act as the key in the Fact Table.

Limitations:-
We can include only one Characteristic in the Line Item Dimension because the Key in the Fact Table is SID. We can Create SID for each characteristic separately.

What is 1 ROWCOUNT key figure?

10112

---

Which of the tables are inside and outside cube in an extended star schema?

1023

---

How does delta update mechanism work in ods?

949

---

What all data sources you have used to acquire data in sap bw system?

987

---

HOW CAN I APPLY PATCHES FOR BI 7.0 WITHOUT USER ID AND PASSWORD OF SAP?

2034

---

What are the versions in objects?

2027

---

What are extractors? Name a few which are used commonly in the sap bw?

940

---

What is Infoset Query?

976

---

What is the difference between ods and info-cubes?

964

---

List the tools to monitor overall query performance.

857

---

Give an example of it?

1891

---

How do I separate development from the production environment?

845

---

what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?

4469

---

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

2151

---

What is the procedure to implement structural authorization in BW?

2276

---