Forum Discussion
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 ...
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')"
Thank you JackLacava Henning , i suspected paging is what might be making the CV to run very well in dashboard as it might be pulling first ~1000 or so records and displaying and as we move along pages it might be pulling the next batch of records. I used FDX to pull all 12 base periods of the year and for a parallelization of 4, it ran 4 CVs at once each taking 10% of system resources, so was little apprehensive deploying FDX with parallelization in production. I am using a datatable for storing the data as FDX returns a datatable before i run code to copy rows from datatable to a sql server table. Is there a way to use any different object for storing the data? as i didnt explored that yet. I'll try moving around dimensions in CV as well.