Questions about the performance of BPC10 NW

[Former Member]

Hi All,

I have joined BPC project which the partner has implemented.

BPC version is BPC10.0 NW.

Their design is that 3 billion records will be contained to one BPC model.
We have critical performance concern for the design because we had some BPC project in Japan but
did not have such case of big data..

We investigate the method of improving performance without dividing the BPC model.
Please let me ask 3 questions.

1. Is SPO(Semantic Partition Object)  effective and useful for this case?

(Can SPO(Semantic Partition Object) be used for the BPC model?)
2. Are there any other methods to improve performance.(Logical partition?)
3. Is there any example in the past project which had 3 billion data record in one model?
   Generally, should we divide the cube(model) in such cases?

Regards,
Tomomichi Haebara

[Former Member · Accepted solution]

Hi Tomomichi,

1) Need to find out.

2)As of now In NW ,logical partition is not possible due to TIME dimension in BPC and 0CALMONTH in BW.To have logical partition in BW we need to do it by 0CALMONTH or 0FISPER.

3)My recommendation is to divide the cubes based on TIME or any other logical unit.

what u can do is lets say u have 10 years of data.

• copy the historical 7 years of data to a normal CUBE in BW
• Delete this 7 years of data from ur BPC Real time cube(it will have only 3 years of data now).
• Now include the Normal cube where u have copied the data in the Multiprovider of BPC.
• Now u will be able to provide a report on top pf the BPC multiprovider with all the 10 years of data.
• And from BPC side you are performance should improve

Hope this helps.

Thanks

Aamer

[Former Member · Accepted solution]

Thank you for your reply.

Please let me ask 2 questions about your reply.

1.

>As of now In NW ,logical partition is not possible due to TIME dimension in BPC and 0CALMONTH in >BW.To have logical partition in BW we need to do it by 0CALMONTH or 0FISPER.

What do you mean? Is it impossible that Logical partition (Infocube/model partition) per TIME dimension? Do you have any more detailed information?

2.

>Now u will be able to provide a report on top pf the BPC multiprovider with all the 10 years of data.

This report do you mean a BW query?

BPC report can't use multiprovider and normal CUBE.

Regards,

Tomomichi

[Former Member · Accepted solution]

Hi,

1)It means that BPC NW does not support logical partition bcoz they do not use standard SAP Time dimension.

I am also copying the text from SAP BPC 10--420 below

"Partitioning is not available because we do not use the standard SAP time dimension, and that is all that NetWeaver supports for partitioning."

Note : By SAP Time dimension they mean to say the use of 0CALMONTH or 0FISPER

2)Yes,its a BW query.The report is in BW over a Multiprovider.U can also publish the same in portal or web,for the end users.

Thanks

Aamer

[Former Member · Accepted solution]

Continuation...

For the partioning in BPC NW:-

In BW you can partiton the Cube only if you are using Standard SAP Time dim's i.e 0CALMONTH or 0FISCPER,otherwise its not possible.

Now when you create a BPC model a real time cube is created in BW backend with the TIME dimension selected in the BPC side and not with the 0CALMONTH or 0FISCPER.

Hence ,as of today BPC NW does not support partioniong.

Partioning is being considered for future enhancements. 

For the partioning in BPC MS:-

BPC MS version do support partioning.

Partition Wizard User's Guide http://service.sap.com/~sapidb/011000358700000707982012E

Thanks

Aamer

[Former Member]

Hi Tomomichi,

What Aamer has suggested is about archiving methodology. You should definitely have a strategy to archive the historical data, in order to keep the data volume under control.

If this also doesnt solve your problem, then I would suggest to break the models.

Hope this helps.

[Former Member]

Thank you for your reply.

If you have solution, please give an answer to a additional question.

Regards,

Tomomichi