OneStream Community

Sai_Maganti · 05-13-2022

What is the purpose of timeMemFilter, entityMemFilter and scenarioMemFilter parameters for the below function as these will be defined in the cube view? Is there a way to extract aggregated members as a table for the Account and all the UD1 to UD8 di...

Sai_Maganti · 02-18-2022

Account dimension member "In Use" property (Vary by Scenario Type and Time) set to Scenario Type = "Control" and Time to "2022M2", Stored value "False" However when I try to grab the InUse value via a BR it always returns "True" Dim varyByScenarioTyp...

Sai_Maganti · 06-20-2024

Hmm not sure why it is not honouring the filter..However, you can ignore the filter here and fetch all the data and then do a select on the datatable returned. See above post by OP. The filtering was done outside the fdx using a select. dim dtFiltere...

Sai_Maganti · 06-19-2024

Assuming that there is data for that Account and UD1 combination, I don't see any reason why it shouldn't work. I had done similar filters and they are working fine in all versions upto 8.2. Not that it would (in theory both are same) make any differ...

Sai_Maganti · 02-24-2024

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 · 02-22-2024

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

Sai_Maganti · 12-18-2023

If you meant that you're running an FDX query and want to see values > 30000 in the returned datatable then you can use the Filter parameter filter = "Amount > 30000" BRApi.Import.Data.FdxExecuteDataUnit(si, cubeName, entityMemFilter, consName, scena...

OneStream Community

User Statistics

User Activity

FdxExecuteCubeView Function

Account dimension member "In Use" property

Re: Threshold Operation in FDX using SQL Query

Re: Threshold Operation in FDX using SQL Query

Re: CubeView Performance - OneStream Dashboard Vs FDX

Re: CubeView Performance - OneStream Dashboard Vs FDX

Re: Threshold Operation in FDX using SQL Query