Skip to Content

BPC EPM Variance Report

Hi Experts,

Request for your help in achieving requirement of EPM Variance report which has following sub requirements

Details of system

System : BPC 10.1 Standard

EPM Report

1.My column axis has two dimensions Time and Data source(PB_INPUT, PB_IBIS)

Screen Shot: How it is designed

Requirement:

1. Column1(Time,PB_INPUT) column2(Time,PB_IBIS) column3(Time,variance) combination should be displayed only when there is data in any of one of these columns :

2.On opening of the report , report should be displayed only at Time.Total level and only on expanding it should be expanded to years as below

Requirement Screen shot:

In order to achieve above requirement i tried following solutions but its not working

Solution 1 : Column1(Time,PB_INPUT) column2(Time,PB_IBIS) column3(Time,variance) combination should be displayed only when there is data in any of one of these columns : Tried using remove empty in column axis but it dint worked as it is removing empty columns even though there is data in any of other 2 columns .

eg: in below screen shot you can see column (FY10,PB_IBIS) and Column (FY10,Variance) are missing even though there is data in (FY10,PB_Input)

Please let me know if there is any other way to achieve this requirement

Solution 2: On expanding of Time total i getting follow out put:

Screen shot of what is expected:

Please let me know if there is any way i can achieve these two requirements

Many Thanks

Siva

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 17, 2017 at 06:57 AM

    Requirement:

    1. Column1(Time,PB_INPUT) column2(Time,PB_IBIS) column3(Time,variance) combination should be displayed only when there is data in any of one of these columns

    Problem:

    "Tried using remove empty in column axis but it dint worked as it is removing empty columns even though there is data in any of other 2 columns."

    Ans - For this, you need to have data as "0" (Zero) saved in rest of column.

    if we consider your scenario, if data is there in FY10, PB_Input), you also need to have saved data as "0" (Zero) in column (FY10,PB_IBIS) and Column (FY10,Variance).

    2.On opening of the report , report should be displayed only at Time.Total level and only on expanding it should be expanded to years:

    Ans - Use local member in following way:

    Change audit dimension members respectively applicable in your case.

    Hope this helps.

    Thanks,

    Karan

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 17, 2017 at 12:45 PM

    Hi All,

    Thanks for reply's

    I removed repeat on column headers and i am able to achieve above two requirements.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 15, 2017 at 07:28 AM

    In general it's a bad idea to have Time.TOTAL member in TIME dimension. Not supported!

    Add comment
    10|10000 characters needed characters exceeded