Skip to main content
F
Francisco
Newcomer
July 10, 2023

Forecasts Scenario Parameter

  • July 10, 2023
  • 2 replies
  • 0 views

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

    N
    NicolasArgente
    Veteran
    July 11, 2023

    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 

      F
      FranciscoAuthor
      Newcomer
      July 11, 2023

      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. 

      Terms & ConditionsAccessibility statement