Formatting a Changed column/cell via DM in BPC

[Former Member]

Hello Gurus,

This is Sachin here back with some more questions and I hope you will be, as always, helpful in my queries.

The last time I was here, I had a few queries on how to overwrite a column, Forecast column with Actual data. And I was given guidance with which I was able to accomplish that task with minimal issues.

Currently going forward with that task, I have been asked to format the sheet based on data load and input.

Example -

Account	2015 April
	Forecast
Acc01	123456789
Acc02	456789123
Acc03	789123456

Output -

Account	2015April
	Actual
Acc01	321654987
Acc02	654987321
Acc03	987321654

Kindly note that this is the format my report is in; Actual and Forecast are members of the Dimension Category that I am using in the report.

Please find the below queries to my task and do let me know you opinions on the same.

-     Is it possible, once the Actual is copied and overwritten on the Forecast column, to change the Column Header Definition from 'Forecast' to 'Actual'

-     Kindly advise as to how to change the color format of the columns once the DM has copied the Actual data onto Forecast column - Green to Orange.

-     Also, the Forecast column is not locked, I would like to lock the cells of that column after the Actual data has been copied onto the Forecast column; Basically after the DM Copy package has copied data from Actual to Forecast, I would like that the Column Header Definition be changed, Color format of the column be changed to distinguish between Forecast and Actual and finally to lock the Actual data from future editing.

Looking forward to your favorable responses.

Regards,

Sachin

[former_member186338 · Accepted solution]

Hi Mario,

I have already explained you how to use conditional formatting based on the property of the forecast version. Is it clear? You can also change the text in the header line using simple Excel formula!

But it's not related to DM copy, it's related to the forecast version!

Vadim

[former_member186338 · Accepted solution]

Sample for headers formula:

Vadim

[Former Member · Accepted solution]

Thank you Vadim, I got my scenario to work and also Formatted the color based on differentiating the Actual data with Forecast data, in addition to locking the Actual Data cells from further editing.

Will keep you posted on further requirements and the doubts on the same.

Need to go through the EPM User Guide in much detail for further learning.

Regards,

Sachin

[Former Member]

Hi Sachin,

Vadim's suggestion is also correct but you can also try to use "Formatting on specific member/property" in Formatting sheet in the Column section. For "Actual" member give Orange color formatting and for "Forecast" give Green color. If you have only Forecast as a single member and not multiple members like Forecsat1, 2 etc.

Regards,

JP

[former_member186338]

My proposal was to use multiple category members to have automatic total aggregation and fixed forecasts. In this case all members will have the same category and Actual header has to be created artificially.

[Former Member]

Vadim...I am sorry I dint get your point...I was only pointing him to format the Headers for Actual and Forecast after he has developed the report as suggested by you...:)

Regards,

JP