Forum Discussion

GajendraS's avatar
GajendraS
New Contributor
5 months ago

Performance issue with Cubeview

Hi Team, I need to parameterize my Cubeview where I need to sum two flow member data and show it in my Cubeview , For which i need to write a rule in that rule I have to create a temporary variabl...
Cubeview
System
XFBR
  • T_Kress's avatar
    T_Kress
    5 months ago

    I am not following the use case 100% but if you need to add two flow members together, I would do so in the Flow dim (with agg weight of zero on the new parent).  Flow parents agg on the fly so you can pull into your cube view the new parent and then do whatever is needed with it.

  • TheJonG's avatar
    TheJonG
    5 months ago

    Hi - can you post the getdatacell formula that you tried? The below should work:

    GetDataCell(F#RFX_input + F#UFX_input):Name(Total)

Rich_House's avatar
Rich_House
New Contributor III
5 months ago

Hello, I'm curious why do you not want to create a "Total" adding these two member in the flow dimension?

Kind regards,

  • GajendraS's avatar
    GajendraS
    New Contributor
    5 months ago

    Doesn't allow to create a Total in the flow dimension. we need to add 2 flow members without creating a new 'Total' member in the flow dimension. we already try to do so by getdatacell, but it doesn't work, that's why we need know is there any way to do so with the help of business rules.

    • TheJonG's avatar
      TheJonG
      Contributor III
      5 months ago

      It seems strange that a GetDataCell formula that is that simple would cause the Cube View to timeout. There may be something else going on in the Cube View. Assuming its a large Cube View, are you using sparse row suppression? Maybe the dynamic calc is messing with that.

      Creating the Total member is likely the best solution and I'm not sure why that is not an option?