Skip to main content
Newcomer
Jul 10, 2023 8:20 PM UTC

Forecasts Scenario Parameter

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. 

    2 replies

    Veteran
    Jul 11, 2023 11:25 AM UTC

    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 

    FranciscoAuthor
    Newcomer
    Jul 11, 2023 1:22 PM UTC

    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.