Skip to main content
S
Shub
Newcomer
January 8, 2025

Dynamic POV in cubeview (Condition in POV)

  • January 8, 2025
  • 3 replies
  • 0 views

Hi ,

I was wondering if i can have dynamic POV in a cubeview without BR.

Is there possibility of condition in POV for example I can put a param scenario and say whenever Budget UD1= Model and if Actual it should be 1000.

 

    3 replies

    F
    OneStream Employee
    FredLucasOneStream Employee
    OneStream Employee
    January 10, 2025

    Hi Shub,

    If your scenario is based on a parameter then you could set up the " UD1 mapping" as part of a Scenario Text attribute (ex.: Text1) and then have the UD1 member on the CV being defined like this:
    XFMemberProperty(DimType=Scenario, Member=|!ScenarioSelection!|, Property=Text1).

    GetDataCell or Dynamic calc could be another way if it's a read only CV but in case the idea above does not work for your case, I'd probably go for an XFBR instead.

    Hope this helps.

     

     

    S
    ShubAuthor
    Newcomer
    February 4, 2025

    FredLucas Can you help me how to execute it... i am not sure how to use XFMemberProperty

    F
    OneStream Employee
    FredLucasOneStream Employee
    OneStream Employee
    February 4, 2025

    Hi Shub,

    I meant something like this:

    Cube View POV: Scenario based on parameter selection and UD1 member based on Text1 property of the Scenario member.Scenario Actual defining the UD1 member as Finance (using the Text1 property)

     

      S
      ShubAuthor
      Newcomer
      February 4, 2025

      FredLucas It works for actuals only, if i select scenario budget it don't give me any result... for Budget and forecast should be U1# Model

      Terms & ConditionsAccessibility statement