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

EVDRE - color cell based on security


I'm trying to sort out exactly how to color cells in my BPC report based on the security that is set up in BPC.

For instance if I have 12 periods and user A accesses the report who has access to all periods then period 1-12 should all be white indicating that this user can post into the periods, if however user B access the report who has access to periods 4-12 then only period 4-12 will be available.

I'm trying to do this as it is based on input schedules so that users all know first what they can enter so they don't do all the work to have the security layer deny the change.

I can't seem to work out how to do this. The only option that I seem to have is set up categories as a version control on time then I can just shade based on the name of the category and after data has been populate copy the data back to essentially a master cube. But this then requires my users to always know what version of category to use which I can't see as being a good idea.

What have other peoples experiences been?

Thanks in advance


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2011 at 04:06 PM

    Hi .

    I am not clear whether you want to color based on the different periods or only certain cells.

    I think you can use conditional formatting in excel based on formula to achieve the coloring.

    The main issue would be to comeup with table in excel to map up which color points to which periods.



    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.