Forecasts Scenario Parameter

[Francisco]

I'm looking for a solution to create a parameter that would allow users to select from a drop-down list current and next period's scenario. I'm trying to avoid having users select the incorrect scenario for data submission via the excel add in. 

[NicolasArgente]

Hi @Francisco 
You could put the next scenario name in the text1 property of the previous scenario. Then use the XFunctions like below to retrieve it :
OneStreamExcelAddIn.XFFunctions.XFGetMemberProperty(Scenario,MemberName,Text1,"","","")
Obviously you need to adjust this excel formula. Try by updating your scenario MemberName as I think the rest is fine. Not sure. This should display the name of your next scenario... 
Feedback appreciated. Please give a kuddo if it helps 🙂
Cheers 

[Francisco]

Thanks Nicolas. I need it to be dynamic, if the user is on the 5+7 scenario (based on their WF) they would only have access to 6+6, 7+5, etc. The data is populated on a cubeview so I'm trying to create the parameter to add to the member filter. Sorry for not sharing specific details.