Answer / hari

partitioning enables the query to fetch the data
parallelly. if the query requires 12months of data and the
partition is based of 0calmonth, the query fetches the data
in 12 parallel processes, thery by reducing the time for
query output by 12 times in theory.

Answer / vsu_vnaya

Table partioning is required for the better query
performance, as the Infocube contains huge data and want to
query on a particular period then it is performed, Table
partitioning is done based on 0FISCPER or 0CALMONTH. And it
is a virtual or logical partioning of data.

What is COUNT function?

1 Answers  

---

I have Two cubes one is SD cube and one is customized cube.There are 2 Data sources called SD Data Source and Billing Data Source.I want to Load SD Data to SD Cube and Billing Data to Billing Cube.I want to Look up some Data from SD Cube to Billing Cube.How do i Look up the data?

1 Answers   Bosch,

---

Where do you store your custom images (like logos)?

0 Answers  

---

Explain business blueprint stage.

0 Answers  

---

What is data ware-housing hierarchy?

0 Answers  

---

What is the dimension in bw? How would you optimize the dimensions?

0 Answers  

---

Describe the new BW 3.x authorizations?

0 Answers  

---

What is sap bw/bi?

0 Answers  

---

what are the other variables?

0 Answers  

---

how can u know the cube size? in detail show me u have screen shots

1 Answers   Rockwell, TCS,

---

how do u deceided to go create Aggregates for cube. what purpose u want to create aggregates?

2 Answers   Cap Gemini,

---

What is a free characteristic?

3 Answers  

---