Question:
Hy Guys
We implemented BW in a Bank and we are managing lots of data.
I got an infocube with 3 milion records every month that we use for generating
Profit & Loss report. The characteristics
are Business Partner, Bank Product, Profit center, calmonth and others.
Approximately we have:
1) 3.000.000 Business Partner
2) 3 Bank Product
3) 1000 Profit Center.
As I described my first requirement is to report
Profit & Loss for Business Partner e Bank Product.
Actually we have loaded 13 months in the infocube so we count almost 40 milion records.
When I run report Profit & loss for Bpartner and Bank Product on monthly base, we got good performance. Also
when I run Yearly Profit & Loss for Business Partner and Bank Product.
Now, probably we need to load more records (we say 6 milion record) because we have another 3
Bank Product.
So if I load all data in one infocube the reult will be one infocube with 10 milion records montly and
I need to generate Profit & Loss report for business partner and Bank product.
(in one year more than 100 milion records).
I want to say I can't create aggregates. So i am wondering which architecture to implement.
One infocube or more infocube divided by bank product? We need to keep data for two years.
Can you help me? any idea will be great!!
Thanks in advance
Vincenzo De Marco
Answer:
I want to say I can't create aggregates.
Why
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
there are several ways for performance ....
- build aggregates ...
- partition and compress your cube ...
- maybe split the one cube to maybe 6 cubes (one for each bank product), and then use a multicube to get one report on all 6 cubes ...
- try to kick not needed infoobjects like calday, if you only need to report on calmonth, or kick 0docnumber, if you don'T need the data with this detail ...
i recommend a combination of all above ...
also check the sap marketplace for howto's on the described themes !
greetz,
toadward
Answer:
Thanks to everybody.
I just want to say I cannot create aggregate because I got 3 milion Business Partner. (all different), so How can I create aggreagte If I need to report Profit & Loss for Business Partner and Bank Product.
By the way if you have more suggestions they will be appreciated.
Thanks in advance
Vincent
Answer:
maybe split the one cube to maybe 6 cubes (one for each bank product), and then use a multicube to get one report on all 6 cubes
This would definetly be the thing i would go for