Skip to Content
avatar image
-1
Former Member

LocalMember Locked/ Enable based on TIME (DIMENSION) - Current (Property values)

Hello,

In my time dimension , I have current as a property and having values 1,2 and 3 .

Based on the current property value I need to Enable or Grayout with Lock the columns in Inputform.

I need to columns with LocalMembers need to Grayout based on above "Current" Property . if 1 gray with lock , if 2 or 3 need to be in enable mode

In EPMFormattingsheet maintained ->> In column "addMemberProperty" --> added time.current =1 and added multiple selection as with LocalMember001.

In my input form its not working, used conditions always showing grayed . How can I make them based on condition ?

Please need help on this.

Regards,

DN

ttdsh.png (18.6 kB)
szcxq.png (10.7 kB)
a63aw.png (33.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 31, 2017 at 07:13 AM

    Absolutely incorrect idea in general: "to enter only periodic values." in YTD model!

    Don't spend time on input form.

    Create PERIODIC model and copy data from YTD to PERIODIC model. Use PERIODIC model for input. Then copy results to YTD model.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2017 at 10:05 AM

    Sorry, but the scenario is not clear!

    What is the reason to use local members?

    What do you mean by local member in "in enable mode"???

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2017 at 05:25 AM

    If you dont have Time dimension in the input form.....then why are you giving the conditions in the formatting sheet with Current property????? It will not apply only! The above given condition will only work if the local member has time member with it! If your condition is to lock the local members based on time dimension then either include the dimension in the report or change your logic!

    Regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2017 at 06:11 AM

    Hi Vadim and Priyanka,

    thanks for your reply.. here is the background of the input schedule. the user requirement is to enter only periodic values.------->

    On YTD cons model, I have created input template for user to key in periodic values.

    For that I have taken 1 input schedule and one report .

    1. from the report - the existing YTD values will appear in the Report.(fig1

    2. user to key in Periodic , I have used the normal excel formulas to derive from existing from YTD.

    3. Input schedule YTD, changing the periodic values to YTD by using excel formulas and saving to BPC

    fig 1:- Report YTD

    Fig2 :- User wants to input as periodic as shown below ( localmember001 = YTD Oct - YTD Sep) , this is derived from above fig values and user wants to modify those value and send back YTD Model.

    Fig3:- calculate the YTD from periodic and save the modified values ( because the model is YTD ) (Eg: OCT + Nov is Nov YTD from above figure)

    when I hit the save data button YTD values goes into the system, Local values(fig2) need not to go in.

    Add comment
    10|10000 characters needed characters exceeded