Skip to Content
author's profile photo Former Member
Former Member

Real time reporting in BPC

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,

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2015 at 11:51 PM

    Hi,

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

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2015 at 03:39 PM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2015 at 04:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.