Default settings for Current View

[Former Member]

Hi there experts,

I am experiencing the a problem with the default current view on different PCs.

I have input schedules that use EVTIM on the months of my time dimension.

Every time a new user opens this input schedule on a new PC the default current view for time shows the highest hierarchy node which in my case is FIscal Year.

This will then result in errors in my input schedule (because the EVTIM cant generate the next members) until the user has changed the time to the correct selection. This behaviour makes sense if you know how what BPC is doing but it causes major confusion for end users.

Is there any way (other than harcoding) to set a default current view for dimensions? Even for locked dimensions I have noticed that once you open the schedule on a differnt PC the dimension is still locked but it defaults to the highest hierarchy node.

Thank you!

Sabine

[Former Member · Accepted solution]

Hi Sabine,

You might try using a dimension lock (ref. Action Pane) on the Time dimension.

Alternatively, in Excel somewhere hidden you can create a list of 'if' statements for each dimension (e.g. EvPRO(app,mbr,CALC)="N") returning 0 or 1. Put a subtotal at the bottom so that when it is not 0 it indicates you have a problem with the settings of the dimensions.

You can now display a message for each invalid dimension setting using conditional highlighting on some visible cells.

You can also put a 'if" statement in front of the EvDRE (e.g. if( D22 =0,EVDRE(...),"ERROR") ), or something similar for non EVDRE schedules.

While this doesn't fix the settings it will stop your schedule going wonky

Hope this helps.

G.

[Former Member]

Thanks Graeme, that's very helpful

In regards to the dimension lock - I have noticed that this setting will only lock the dimension but not a specific member. As soon as the schedule is opened at a different PC the dimension stays locked but the member it was originally locked to might change.