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":","
}
]
}
}
Hello,
Thank you for your question.
We recommend the following approach to setting this filter:
Please let us know if this solution worked for you.
Best Regards,
Maksym
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.
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