Forum Discussion

Akshay's avatar
Akshay
New Contributor
3 years ago
Solved

Dynamic scenario for weekly forecast

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 postin...
  • AK's avatar
    AK
    3 years ago

    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.

     

chul's avatar
chul
Icon for OneStream Employee rankOneStream Employee
3 years ago

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.