Skip to main content
A
Akshay
Newcomer
May 26, 2023
Solved

Dynamic scenario for weekly forecast

  • May 26, 2023
  • 2 replies
  • 0 views

Hello All,

We have created a weekly forecast dashboard for our users (weeks are mapped as scenario, e.g. Week1, Week2 etc.) and intend to restrict them to current week scenarios only to avoid posting to a wrong one.
Currently we use parameter, where users select the current week from a drop down and input data, Is it possible to provide them access only to the relevant scenario (week) instead of giving them a drop down, without admins having to make changes every week?

    Best answer by AK1

    Assuming that you will have the relevant Scenario selected in POV Pane (Workflow POV/Cube POV):

    Use the Substitution variable in the Member Filter section of the Parameter. This will restrict the users with only that selection when the Parameter is executed.

    AK_0-1685111014879.png

     

    2 replies

    A
    AK1Answer
    Newcomer
    May 26, 2023

    Assuming that you will have the relevant Scenario selected in POV Pane (Workflow POV/Cube POV):

    Use the Substitution variable in the Member Filter section of the Parameter. This will restrict the users with only that selection when the Parameter is executed.

    AK_0-1685111014879.png

     

      C
      OneStream Employee
      chulOneStream Employee
      OneStream Employee
      May 30, 2023

      Unfortunately this won't work because each user's POV in the pane could be different.

        C
        OneStream Employee
        chulOneStream Employee
        OneStream Employee
        May 30, 2023

        The system needs to know which week the users should be in - the easiest way to accomplish this is to have the admin set the Global POV each week. You could then write an XFBR to use the Global POV for the logic for the scenario name you want to return.

          Terms & ConditionsAccessibility statement