cancel
Showing results for 
Search instead for 
Did you mean: 

Report actuals till last closed month

0 Kudos

Hello Experts,


We have a requirement to report actuals till last closed month(which is August for now) but reports are not created in such a way that it shows different time data for different versions at the same time.Adding time dimension in column axis makes the report static and thereby we ultimately looses its dynamic nature.

For example, In one of the report,Profit center(expansion is dynamic) and Category dimension(one is actual and another one is always based on user selection) are in column axis and time selection is at the top.It retrieves data for both the versions but for the same time period.But the requirement is show actuals till last closed month and other comparison version based on time selected by the user.Adding time dimension in column axis makes the report static because then profit centers needs to be hardcoded as well.

Our main goal is not to touch the existing reports because then we loose the dynamic nature of it. Is there any way to do it with minimal changes in Admin or Reports without losing its dynamic nature.

Any help will be much appreciated.

Many Thanks

Sim

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi Vadim

Thanks for replying.Last closed month means the month which has been recently actualised. Like for this year, August actuals are already in and so this month is closed. Right now, the definition in our input form is 8+4 which means 8 months are actualised and available for reporting but rest of four months(Sept till dec) are still open for planning.

Now, in my report, I have Profit center and category(2 members, one is always actual and another is always based on user selection) in column axis  and data is being retrieved for both versions but for the same time selected by the user.For example, user has selected time as 2014.12, even the actuals will also show till 2014.12 which is incorrect.

Because this way they are also able to see some of the september actuals(which has not been fully posted in our system as this is month half) and therefore, they are not able to see correct data.

I am using EPMAxisoverride and Profit center and category dimension is dynamic in column axis and adding time dimension will make the report static(because I dont want to see two times(like 2014.08 and 2014.12) for Actual version and two times for comparison version) and thereby losing its dynamic nature.

I have attached two snap shots for your refrence(first one is what exists in the system and another one what we are looking for).

Is there any way to bring data in such a way that we dont even have to touch any report.

Regards

Sim

former_member186338
Active Contributor
0 Kudos

Hi Sim,

Just an idea, how we work with forecasting:

In our case we have to create each month a forecast for all months till year end.

We created 12 forecast categories like EST01-EST12 for each month.

When Actual data is closed (in the Actual category) we start forecasting with a simple copy of closed Actual months to the current forecast category (ESTxx). Then we work only with forecast category, with work status lock of copied actual months. Easy and straightforward process.

Vadim

former_member190501
Active Contributor
0 Kudos

Hi,

If you can effort to maintain one more property in Time to just differentiate closed months then you can follow below method.

--> Every month time dimension has to be updated ( eg : maintain Y for closed months)

--> From the report editor select Category dimension members as follows

--> From the report editor maintain Exclude members as follows:

--> Add one more exclusion combination of

Category

     Actual  OR

Time

    Closed <> Y Property OR

                   

Note : As of EPM Add-in SP16 patch 01, when you use <CONTEXT> then context selection should be only ID.

Hope it solves your problem.

Thanks,

Raju

0 Kudos

Hi

Thanks for your answer.  Excluded member tab screen looks different on my machine as compared to yours. I am currently on SP 12 Patch 6.

And also, will it restrict the master data or transaction data. Because my requirement is to restrict Actual transaction data till closed months irrespective of user time selection.

Thanks

Sim

former_member190501
Active Contributor
0 Kudos

Hi,

Upgrade to latest EPM add-in SP.

Your actual data shows only up to closed months based on property value which maintained in Time.

Its not relevant to user selection.

Thanks,

Raju

0 Kudos

Hi,

In my report, I have Account in the rows and Time and category in columns. Time selection is 2014.Total(YTD) and categories are Actual and RE(or PLan).

Now,I have defined the condition to exclude Jan 2014 and Actual category under excluded member tab but after execution of report, it just shows me the comparison category and removes the actual one.

The expected behaviour is to show the actual consolidated data for full year except Jan month.

Am i missing something here? Please advice.

former_member186338
Active Contributor
0 Kudos

Hi Sim,

After I look on details of the desired report in

I can see it's a typical asymmetric report that can be handled by "Excluded members" (not a perfect solution) or by static column axis (requires fixed profit center list). If you can live with fixed profit center list - the rest (categories and periods) can be set dynamic. Or you can move profit center to row axis.

Vadim

former_member190501
Active Contributor
0 Kudos

Hi,

Your time dimension should be Context(2014.TOTAL) with relationship as Base.

Try again.

Thanks,

Raju

0 Kudos

Hi,

I agree that if I take the base for time dimension, then it excludes Jan 2014 for actuals but my requirement is not to show the base for the time selection. It has to be only one member based on user selection.

So, it should exclude transaction data only for 2014 Jan and actual.

For example, User select Aug2014 (YTD)and Actual category and value is $100 but out of this value ,Jan 2014 is $20 so it should show $80 only.

Is there any way to achieve this?

Thanks

Sim

former_member186338
Active Contributor
0 Kudos

Hi Sim,

Looks like you are going in the wrong direction...Member exclusion simply excludes members from the report, but it will not affect YTD value in the members shown on the report...

Vadim

former_member186338
Active Contributor
0 Kudos

Hi Sim,

What do you mean by "last closed month"? Definition?

Please provide some screenshots of the desired result!

Vadim