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 Sai_Maganti I tried using this. I am running the following to get data from DU, but unable to get results limited to filter i have applied, is there any thing wrong how i am passing the fllter?:
dtResults = BRApi.Import.Data.FdxExecuteDataUnit(si, cubeName, entityMemFilter, consName, scenarioTypeID.Actual, scenarioMemFilter, timeMemFilter, viewName, True, filter, parallelQueryCount, logStatistics)
I am passing filter like following:
Dim lstAcct As New List(Of String)
Dim acctArray As String() = {"GrossRevTime", "BillExps"}
lstAcct.AddRange(acctArray)
Dim filter As String = "UD2='LE00037' AND Flow='Top' AND UD3='200020' AND UD5='Top' AND UD6='Top' AND UD7='None' AND UD8='None' AND Origin='Top' AND " & SqlStringHelper.CreateInClause("Account",lstAcct, True, True)
I checked in ErrorLog filter is applied like following:
UD2='LE00037' AND Flow='Top' AND UD3='200020' AND UD5='Top' AND UD6='Top' AND UD7='None' AND UD8='None' AND Origin='Top' AND (Account In ('GrossRevTime', 'BillExps'))
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')"