The data in the report cannot be filtered.

Answered
TWiRote asked on December 22, 2022

Hi
I want to filter down to only "202208" using QueryObject but it doesn't work. By using the way to connect to the data source via Mondrian, do you have a suggestion for me?
Thank you for your help.

Below is my code.
{
"container":"country-export-value-pivot",
"global":{
"localization":"https:\/\/cdn.flexmonster.com\/loc\/th.json"
},
"toolbar":true,
"filters":true,
"beforetoolbarcreated":"customizeToolbar",
"height":600,
"report":{
"dataSource":{
"type":"mondrian",
"dataSourceInfo":"Provider=Mondrian;DataSource=TISTradeExport",
"proxyUrl":"http:\/\/localhost:8080\/jpivot\/xmla",
"catalog":"TRADE",
"cube":"TRADE"
},
"options":{
"readOnly":false,
"filters":true,
"viewType":"charts",
"chart":{
"type":"stacked_column"
}
},
"slice":{
"rows":[
{
"uniqueName":"[MONTH]",
"filter":{
"query":{
"equal":"202208"
}
}
}
],
"columns":[
{
"uniqueName":"[Measures]"
},
{
"uniqueName":"[COUNTRY]"
}
],
"measures":[
{
"uniqueName":"[Measures].[VALUE_THB]",
"format":"thousandsSeparatorComma"
}
]
},
"formats":[
{
"name":"thousandsSeparatorComma",
"thousandsSeparator":","
}
]
}
}

3 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster December 23, 2022

Hello, 

Thank you for your question.
We recommend the following approach to setting this filter:

  1. Set this filter via UI.
  2. Save the report via the "Save" Toolbar tab.
  3. Copy the generated filter configuration from the saved report into the report used in the Flexmonster component on your page.

Please let us know if this solution worked for you.

Best Regards,
Maksym

Public
TWiRote December 25, 2022

Hi,
Set filtering via UI, it will use members filter, but I want to use query filter like this guide https://www.flexmonster.com/api/string-query-object/. Do you have an example of how to use it?
Thank you for your help.

Public
Maksym Diachenko Maksym Diachenko Flexmonster December 28, 2022

Hello, 

Thank you for your response.
Please note that Flexmonster has UI controls for all filters. Hence, if some filter type can not be applied from UI, it isn't supported for the data source. For Mondrian, only the members filter is available.
Our team hopes that you will find this information helpful.

Kind Regards,
Maksym

Please login or Register to Submit Answer