Skip to Content

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

Jan 26, 2017 at 09:54 AM


avatar image


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.



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

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


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

* Please Login or Register to Answer, Follow or Comment.

4 Answers

Best Answer
Vadim Kalinin 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.

10 |10000 characters needed characters left characters exceeded
Vadim Kalinin 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"???

10 |10000 characters needed characters left characters exceeded
Priyanka Jagtap 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!



10 |10000 characters needed characters left characters exceeded
DN Kumar 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.

iuqcg.png (13.3 kB)
ou4uh.png (26.4 kB)
b9nod.png (19.4 kB)
10 |10000 characters needed characters left characters exceeded