Skip to main content
A
Akalya_N
December 18, 2023
Solved

Threshold Operation in FDX using SQL Query

  • December 18, 2023
  • 3 replies
  • 0 views

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

Best answer by Sai_Maganti

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);

3 replies

S
Sergey
December 18, 2023

Hello Akalya_N ,

Can you please specify what do you mean by Threshold operation, and if it's for reporting only ?

Regards,

 

A
Akalya_NAuthor
December 18, 2023

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

 

S
Sai_MagantiAnswer
December 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, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, filter, parallelQueryCount, logStatistics);

A
Akalya_NAuthor
December 20, 2023

Hi...! I've did this Threshold Operation like this...You can find it here

Akalya_N_0-1703058066814.png

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

S
Sai_Maganti
June 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 dtFilteredRows() as DataRow = dtFdx.Select("Account='A30000' And UD1 IN ('D1059', 'D1061', 'D1062')")

Best

Sai

Terms & ConditionsAccessibility statement