Skip to Content
avatar image
Former Member

Filter not working as expected. bringing all data sets

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 08, 2015 at 07:11 AM

    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);
    }
    
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 06:21 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded