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.
You could put the next scenario name in the text1 property of the previous scenario. Then use the XFunctions like below to retrieve it :
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 🙂
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.