12-18-2023 03:00 AM
Hi Community...!
I want to perform Threshold operation in FDX report using SQL Query.. Anyone who knows please share the format for reference... Thank You...!
Solved! Go to Solution.
12-18-2023 07:22 AM
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, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, filter, parallelQueryCount, logStatistics);
12-18-2023 03:03 AM
Hello @Akalya_N ,
Can you please specify what do you mean by Threshold operation, and if it's for reporting only ?
Regards,
12-18-2023 03:08 AM
Sure... If the Threshold value is 30000 means..the values below 30000 in the data table should be suppressed and the values above 30000 should only display...
12-18-2023 07:22 AM
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, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, filter, parallelQueryCount, logStatistics);
12-20-2023 02:42 AM
Hi...! I've did this Threshold Operation like this...You can find it here
But...Here i've given random value (30000),If the user wants to give any number means...You can use parameters for this..Thank You...!