Forum Discussion

chandu_shekar's avatar
chandu_shekar
New Contributor
6 days ago

performance issue.

Hello OneStream Community,

I am working with a Cube View where I need to display the Income Statement data for the end of every year (December). The data should show up as the beginning balance for the January month in the subsequent year. To achieve this, I used a Row Override1 member filter with the formula T#povprioryearm12.

The Cube View includes four dimensions: Entity, Division, Cost Center, and Accounts. However, I am experiencing slow loading times when the view is being accessed. it is not exporting to Excel to validate.

I would like to know if there are any best practices or strategies for improving the performance of the Cube View in this scenario. Are there specific optimizations I should consider for the member filter, the dimensions, or the Cube View configuration to reduce loading times?

Any advice or recommendations would be greatly appreciated!

Thank you in advance!

Admin
Cubeview
Dashboards
Extenders
Finance
Spreadsheet
System
XFBR
  • chul's avatar
    chul
    Contributor III
    2 days ago

    Hello, I'm unsure of your objective with the cube view. The two main suggestions I can provide are to exclude data unit dimensions in the rows and nest fewer dimensions in the rows.