Skip to main content
G
GajendraS
Newcomer
July 26, 2024
Solved

Performance issue with Cubeview

  • July 26, 2024
  • 4 replies
  • 0 views

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 variable member (Total) which doesn't exist in our flow hierarchy which will contain sum of our flow member (RFX_Input + UFX_Input) data, and this Total variable member we have to parameterize and so that when Cubeview runs it'll show me the total value of (RFX_input + UFX_input) into my Cubeview. Please help me to guide how to write this rule logic. We have tried creating it as a parameter with getcelldata but the cubeview does not render and timesout.

 

Best answer by TheJonG

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

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

4 replies

R
OneStream Employee
Rich_HouseOneStream Employee
OneStream Employee
July 26, 2024

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

Kind regards,

G
GajendraSAuthor
Newcomer
July 29, 2024

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.

T
OneStream Employee
TheJonGOneStream Employee
OneStream Employee
July 30, 2024

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? 

T_Kress
OneStream Employee
T_KressOneStream Employee
OneStream Employee
July 26, 2024

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.

G
GajendraSAuthor
Newcomer
October 8, 2024

Hi T_kress,

Unable to add flow member data, tried to create a new parent with agg weight of zero add relationship of that of both the members in the new parent, but still data are not match...is any other way or method i can use to add flow member data...??

R
OneStream Employee
Rich_HouseOneStream Employee
OneStream Employee
July 26, 2024

I agree with Teresa.

G
GajendraSAuthor
Newcomer
October 8, 2024

Hi Rich,

Unable to add flow member data, tried to create a new parent with (agg weight of zero) add relationship of both the members in the new parent, but still data are not match

T
OneStream Employee
TheJonGOneStream EmployeeAnswer
OneStream Employee
July 29, 2024

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

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

G
GajendraSAuthor
Newcomer
July 30, 2024

Hi,

yes, I have already tried this, but it didn't work, because no. of rows and column are many in my cubeview. so when I run with this formula cubeview does not render and timesout. That Why I looking for any business rules logic to solve this thing.

 

Terms & ConditionsAccessibility statement