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

[Former Member]

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

[Former Member]

Where is Time dimension in your report????? I cannot see it...

[Former Member]

I am not using TIME dimension in the input. LocalMember001 and LocalMember002 are excel formulas.

[former_member186338 · Accepted solution]

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.

[Former Member]

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.

[Former Member]

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

[former_member186338]

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"???