Skip to Content
0

BPC EPM Variance Report

Jul 14, 2017 at 11:06 PM

88

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

karan kothari Jul 17, 2017 at 06:57 AM
0

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


remove-empty.jpg (17.1 kB)
local-member.jpg (122.5 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for reply Karan!

0
sivakiran uppala Jul 17, 2017 at 12:45 PM
0

Hi All,

Thanks for reply's

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jul 15, 2017 at 07:28 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks for Reply Vadim!

0

With the Total member in TIME hierarchy you will have a lot of issues!

0