BPC Report with multiple columns

[Former Member]

Hi Experts

We are trying to create a report similar to the one below

WBSE is in the Row

Approved Budget / LRE / Contingency% are from CATEGORY dim and Time

The issue we have is when we combine CATEGORY and TIME in the Column, Approved Budget / LRE / Contingency% get split into each period which is not what we want.

Is it possible to achieve the below?

Also next question - is it possible that if Fiscal year / Period 2014.001 is selected (as an example) is it possible that the time (column) can be dynamically expanded to 3 or 4 years?

Thx

[Shrikant_Jadhav · Accepted solution]

Hi,

You need to build static template using some excel functions.

Please go through this link - documented by

Regards,

Shrikant

[former_member186338]

Hi Shane,

Yes, the report with static columns is a good option. You will have 2 dimensions in column axis - CATEGORY and TIME.

You can also use excel formulas to generate TIME members.

B.R. Vadim

[Former Member]

Thx guys - appreciate the quick response

[Former Member]

Vadim,

Can you pls provide an example of excel formulas to generate time members pls?

[former_member186338]

Look here

Vadim

[Former Member]

Hi Vadim,

I have tried this approach is still get zero records, in the rows I have WBSE, in the column I have CATEGORY and TIME

Active Member Recognition is unticked and I keep getting the below error - any ideas pls?

Below is the correct formula for "LRE" as an example:

= EPMOlapMemberO("[F_CATEGORY].[

].[LRE]","","LRE - Latest Revised Estim","","000")

[former_member186338]

Hi Shane,

Looks like you are doing something wrong, start with simple 2 column report...

1. Column axis: CATEGORY - 2 members, TIME - 1 member. The column axis will consist of 2 rows! On your screenshot I see CATEGORY and TIME in one row - incorrect.

2. Row axis - some accounts.

3. Then activate member recognition and replace fixed members with formulas...

Vadim

[Former Member]

Hi Vadim,

Thanks I will try your suggestions - is it not possible to CATEGORY and TIME in one row in the column axis?

[former_member186338]

It's NOT possible! Different dimensions have to be in different rows (or columns for row axis).

If you want to have one row with combined descriptions you can use local members with some formula. But please, start with simple things!

Vadim