Surpressing forecasted months based on sub-variable

User_CO3C0

Hi All,

We have requirement as follows,

Based on the Curr_Forecast_month entered by the user  the form should be visible for the rest of the forecast months starting from Curr fccst month entered.

Eg: if my Curr_Fcst_month is Apr then my form should be open( which means the previous months should not be displayed in the from rather than showing as ready only) for the user from Apr to Dec ( since my calendar is from Jan to Dec).

I tried t achieve by using exclusion option but it dint work , since my Curr _Fcst _month is Apr and left siblings will result in NULL it doesnt work( since period has Quarters) and I have seen other functions but nothing fits better .

I have also tried creating an alternate hierarchy in period without quarters but exclusion has some issue for shared hierarchy.

any suggestions would really help.

Thanks in advance.

Madhusudhan. M

What if we use only variable instead of Lsiblings("&Curr_Fcst_Month") ??

Thanks,

Mady

User_CO3C0

in the exclusion if we use only curr_fcst_month it will exclude only Apr , but I want previous months ( jan,feb,mar ) to be excluded in the form.

it may not be Lsibling( i have just shown an example in the screenshot which i have tried) at the end I wanted to exclude all previous months showing in the form

Thanks..

User_CO3C0

Any thoughts on this would help..

Thanks.

Madhusudhan. M

check out for option to hide or suppress read only columns or rows ??

Thanks,

Mady

User_CO3C0

That will not work as the open months need to be shown in the form( since open months will not have data and user have to enter it).if we use that option all the open months would be suppressed.

Thanks

JohnGoodwin

You could have a variable that has the start/end months and just update the variable

For example:

Variable               Value

ForecastMonths   Apr:Dec

Cheers

John

User_CO3C0

Yes, this can be done and we proposed this but users wanted to enter only start month that why I am looking for an alternate. Any other Thoughts to achieve this John?

user111989

Not sure if this can help, you can have a dynamic calc member and set the values only for forecast month, then you may have to play with suppress missing block / data to have only the forecast month.

Pete N

You could use invalid time period suppression with the start year \ period on the scenarios rather than sub variables?

Honestly I'd just tell your users they'll have to update more than 1 variable (or just automate the entire thing).