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
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.