Skip to Content
author's profile photo Former Member
Former Member

Formatting a Changed column/cell via DM in BPC

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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 27, 2016 at 05:55 PM

    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!


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.



  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2016 at 06:52 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.