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')"

Sai_Maganti's avatar
Sai_Maganti
Contributor II
2 years ago

Have you tried using FdxExecuteDataUnitTimePivot rather than FdxExecuteCubeViewTimePivot? I was able to extract circa 220K records with all the base Dims and 12 time columns using the data unit pivot output to a grid view in < 90 secs from a Dashboard Data Set BR. If you need to write to a table then you could use SQL bulk copy with more or less the same speed.