Forum Discussion

osdevadmin's avatar
osdevadmin
New Contributor III
2 years ago
Solved

CubeView Performance - OneStream Dashboard Vs FDX

Hi Community, We have a cubeview that pulls more than 40k records when run for a period in a dashboard. It runs base level for couple of UDs that have ~30k members and 200 members. It renders fairly ...
cubeview
Extenders
Finance
System
  • Sai_Maganti's avatar
    Sai_Maganti
    2 years ago

    Use the following filter. The Tops don't work. You can only filter for base members. If you need to filter the 'None' for UD7 and UD8 add them.

    Filter = "UD2='LE00037' AND UD3='200020' AND Account In ('GrossRevTime', 'BillExps')"

Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi, as you are mentioning, paging is used on the CV. This means only the displayed data on that page is pulled into memory if I remember correctly. When you use an FDX, this does not "page" the data but pulls the entire data set into memory, which is why those two cannot be compared in this case.

You can test moving your dimensions around in the CV. Changing the order of dimensions has significantly improved performance for a colleague a while ago.