Skip to Content
0
Former Member
Apr 17, 2018 at 02:08 PM

Filters on Offline DataSource in Designer from Discovery

231 Views

Hello Experts,

I am importing two BEx queries into Discovery by Linking them based on 0Calday. Both the Queries has Profit Center and Market. I have got a problem with the Filters both in Discovery and Designer.

In Discovery - I have created a cross tab / chart based on the Linked dataset and when I am trying to apply Filters on Crosstab / Chart, it is asking to select the Dimension from particular DataSet and when I apply filter on Crosstab / Chart, it is getting effect only the data coming from the first dataset, it is not affecting on the second data set. Is there any way where I can apply the filters on the complete data which is set built on the different queries.

In Designer - I an getting the same problem. I have called same Linked Dataset (based on two BEx Queries) from Discovery as a offline Data Source in Designer. In the Edit Initial View I can see two Profit Centre and two Markets and i felt that i can use them in my scripting to filtering data. But in my scripting when I am using setFilter to filter data, it is displaying me only one Profit Centre and one Market which is affecting only few columns.

Can someone help me on how to get the filters effected on complete data set both in Discovery and Designer.

Regards

Venkat