Skip to Content
avatar image
Former Member

How to do Dynamic Formatting on Input form build on Analysis for Office

Hi All

I am working on BPC IP PAK and using Analysis for Office as the front end.

I need to format my actual cells as locked and planned cells as Unlocked when there is a change in the version in the rolling forecast scenario. Which is dynamically changing when there is a change in the selection.

I can do formatting using styles for Member or member area and data but that has to be dynamic just like EPM. Please provide your inputs. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 18, 2017 at 02:16 PM

    Instead of permanent lock you can use dynamic data validation based on formula condition!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2017 at 12:03 PM

    Thanks Vadim for your inputs.

    I am trying to apply this using VB for my formatting. For some reason this is not working for measures and dimension members. but it works for only member

    Working code below

    lResult3 = Application.Run("SAPSetFormat", "LockActuals", "DS_1", "LockActuals", "MEMBER","0CALMONTH;201605)

    Not working below code

    lResult3 = Application.Run("SAPSetFormat", "LockActuals", "DS_1", "LockActuals", "TUPLE", "MEMBER;0CALMONTH;201605", "TUPLE", "MEMBER;Measure;Amount")

    Am i missing anything here.

    Add comment
    10|10000 characters needed characters exceeded

    • First - looks like you are taking about AO Analysis reports. Then you are using incorrect tag: NOT Epm Add-in for Excel. Please correct.

      Second - method using data data validation require no VBA at all.

  • avatar image
    Former Member
    Aug 03, 2017 at 12:38 PM

    Thanks Vladim. I am working on it.

    Add comment
    10|10000 characters needed characters exceeded