Filter not working as expected. bringing all data sets

[Former Member]

Hi,

I'm in Design Studio 1.2. My dashboard has multiple categories and each category is represented by a Button in the Dahboard. When I click on a category, it displays the corresponding result set in a graph and a table.

When there is no data for a particular category in a month, I would expect my graph and table to show no values, when I click on that category. But now it shows me all the records in graph and table. The filter for some reason is not working and that brings all the records into the graph and table.

When there is data it works fine. It shows the corresponding data for selected category.

Is anyone has faced this issue?

My dashboard is based on universe.

Regards

Saubhagya

[Former Member · Accepted solution]

Hi,

Yes there was this issue .

Temporary Solution For this is

Check for Data in Category once category is selected

var value_show = DS_1.getData("Measure", { "Category": "ABC Category"}).value ;

if value is 0 then hide the Presentation Components (Like Charts / Crosstab ) else Display it .

if (value_show == 0.0 ) {
    Crosstab1.setVisible(false);
    PanelNoData.setVisible(true);
}
else{
    Crosstab1.setVisible(true);
    PanelNoData.setVisible(false);
}

[Former Member · Accepted solution]

Thanks Nikhil,

Do you know if the issue has been resolved in 1.3/1.4 versions?

Currently we are in 1.2 SP0.

Regards

Saubhagya

[Former Member · Accepted solution]

Hi,

in version 1.3 , I don't remember .

But in 1.4 it is resolved.

It gives Below Message if no data is for selection .

[Former Member · Accepted solution]

Thanks Nikhil

Regards
Saubhagya

[TammyPowlas]

There's a note related to universes for 1.2 - http://service.sap.com/sap/support/notes/1954748 are you on the latest SP for 1.2?

If you are then I recommend posting more details and screen shots (use camera icon) to describe the problem.