07-10-2023 04:20 PM
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.
07-11-2023 07:25 AM
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
07-11-2023 09:22 AM
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.