Derive version using property using analytics designer

[pranavvyas01]

Hi Team,

We have 2 restricted measures, Current Forecast & Previous Forecast. Current Forecast version is selected using the input control but in case for Previous forecast, it needs to be derived using property created in version dimension. The previous forecast version changes every month based on what is set in the version dimension property. It is not possible in the std stories, can this be achieved using Analytics designer as planning model.getmember API allows to fetch only for generic dimension.

Thanks & Regards,

Pranav Vyas

[pranavvyas01]

Hi chiayuwu

Have you come across this kind of requirement in Analytics designer? I want to read the version based on the property and display it in the restricted measure.

Thanks & Regards,

Pranav Vyas

[N1kh1l]

pranavvyas01

pranavvyas01if Previous Forecast is derived from a property in version dimension you can use FIND() in Input control formula to derive it. see an example below

In the formula you can use something like below.

FIND('X',[d/Version].[p/Forecast_Version],[d/Version].[p/ID])

Version Dimension setup. Forecast Version is the attribute and the value "X" identified what version id will be used in the input control. In this case it will be Forecast.

Input Control value:

Please upvote/accept if this helps.

Nikhil

[pranavvyas01]

Hi nikhil_1486 ,

This is allowed only if i am using forecast layout. In case i want to use this formula input control somewhere else, say in my case restricted measure then it does not allow.

Thanks & Regards,

Pranav Vyas