Bpc report Query

[Former Member]

Hi,

I have a query

Is there any way to achieve the below.

Please let me know if you want any further details.

Please suggest me on this. Thanks.

Srikanth

[former_member186338 · Accepted solution]

Sorry, but it's hard to understand the report logic from you screenshot. If you want some help, please describe the algorithm in words...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks for your reply.

I want to display the numbers by monthly as shown in the above figure.

here the fiscal year is Apr15- Mar16

If user select Apr 15 time member, i want to display like below.

user selection           Apr-2015

Apr15      Apr15              Total        Total

actual     Budget             actual      Budget

50           100                   50           100

However if user select's next month which is May 15.

I want to display current month +previous month  and the commulative total for these 2 months.

            Apr15      Apr15       May15     May15             Total        Total

            actual     Budget        actual      Budget          actual      Budget

Sales-     50           100              150         200               250           300

For June 15,

I want to display current month+previous two months   and the 3 months total.... same as above.

I hope you understand my point.

Thanks for your help.

[former_member186338 · Accepted solution]

Ups,

Apr15

actual

50

And

May15

actual

150

Not equal to 250...

Anyway,

You want to select months starting from the beginning of the year till user selected month and totals.

To select months you can use EPMDimensionOverride

Vadim

P.S. Please show your TIME dimension Administration screenshot!

[former_member186338 · Accepted solution]

Sample:

2 reports created, first for months, second for total:

TIME dimension in this sample is named PERIODS

Page and row axis are shared between 2 reports.

Column axis contain dimensions: MEASURES,PERIODS,CATEGORY

Vadim

[Former Member · Accepted solution]

Hi Vadim,

It works perfect. thanks for your answer.

I have a one more query regarding this. I have another category called forecast. and i need to show this category as well. and this forecast numbers start from July means after completion of Q1.

So for July month Ytd figures for forecast should be

Jul ytd is Q1 Actuals+JUL forecast. Is this possible ? please see below for calc

   

Many thanks for your support. Thanks

[former_member186338 · Accepted solution]

"Jul ytd is Q1 Actuals+JUL forecast. Is this possible ?" - no, but you can copy actual figures (Q1) into forecast category! We are working this way with forecast!

Vadim

[Former Member · Accepted solution]

Hi vadim,

Okay. Thanks for your help.

[Former Member · Accepted solution]

Hi Vadim,

One more query regarding this question.

If i want to insert a new row for account in row axis and need to add a formula , for ex i want to show sales positive, so if i write a formula like sales account *-1. this is not working if i change the time member after refresh.

                                     selection  2015.01

                                             apr2015  

                                               actual

sales                                           50

Sales(new inserted row)              -50( 50*-1)

I tried the above ,however if i change the time member 2015.02  the formula got disappeared for the next months .

Is there any work around for this?

Thanks in advance.

[former_member186338 · Accepted solution]

Try to play with local member!

Vadim

[former_member186338 · Accepted solution]

Like:

Vadim