Real time reporting in BPC

[Former Member]

Hi,

I have a question around BPC/BW reporting

Currently planning data is loaded from BPC cube into BW infocube just once daily. What would be the best possible method to report planning data realtime using Bex Query via Multiprovider?

We are on BW 7.4 and BPC 10.0

Thanks,

[Former Member · Accepted solution]

Hi,

fixed cube technical name then read BPC multi provider in your BEX.

Andy

[Former Member · Accepted solution]

Andy, thanks. There is a need for transformation for the data in BPC cube such as Calendar month format, fiscal period and # funds etc in order to do reporting.

[former_member193143]

Hello SAP01,

I am agree with Gersh, But you need to be aware of the following points.

But be aware of the following points

     1. If you have lots of data it will effect the performance.

     2. you need to have a authorization roles to create the Bex query on /CPMB name space multi providers

     3. if you use that Bex Query as source for Design studio or Webi you can you the offset function for Time dimension, it consider as a text field.

What is your requirement exactly..?

if its only a query for viewing the planned data just follow as Gersh told

Thank you very much

Saida Reddy Gogireddy

[Former Member]

Thanks Saida.

As soon as the users punch the numbers in BPC and then execute the BW report they like to see the budget instantly.

Our requirement is to report Actuals/Budget data using the Bex report. (No BO tools)

However need to transform the BPC data in order to report. Eg: Converting Calendar month format, fiscal period and '#' funds etc

In terms of performance, is there any way we could get just today's data (BPC) using Virtual Provider and the history from BW cube (data loaded via daily Process chain into BW cube). Can we have a date restriction?

How do we go about achieving this?

[Former Member]

There is no such thing as "today's data" in real-time cubes. As soon as you compress the cube, data you entered today is mixed with historical data in one record.

If you don't compress the cube then you can create a Customer Exit variable that will lookup BW tables to find out what was the first request loaded today and restrict to requests bigger than that value. Or you can maintain that value in some table when you load from BPC to BW.

This is a slippery slope because it will be a ton of exceptions, like you were unable to load data to BW last night for some reason or that load failed etc.

I'd suggest better restricting it on some data, like current months from BPC, all previous from BW.

Theoretically query on Virtual provider is slower than on base cube, but in reality you don't see that difference if query is built correctly.

[Former Member]

Standard way is to enable "external reporting" of the Model. This will  create a /CPMB/..._B Virtual Provider that you can use for BW reporting. It supports your BPC DAP authorizations as well as member formulas.

Cheers,

[Former Member]

Thanks Gersh.

I added my questions on the below thread.