Articles in this section

How to configure "SUBSET FILTER FORMULA" properly in Imply data cube

Ming Fang
  • Updated
Follow

With Imply UI's latest "SUBSET FILTER FORMULA" feature, users can filter out the unrelated data by default right at start of opening a data cube. 

However, sometimes when a filter is added for a column, the output shows 0 result. For example, user wants to filter only rows with only `Country Iso Code` = `US` in the Wikipedia data source:

Screen_Shot_2018-09-10_at_6.50.31_PM.png

But the result shows 0 results 

Screen_Shot_2018-09-10_at_6.40.26_PM.png

 

ROOT CAUSE: The problem is admin configured SUBSET FILTER FORMULA using the NAME in the configuration, instead of the actual COLUMN:

Screen_Shot_2018-09-10_at_6.39.25_PM.png

After the configuration change, the output shows up correctly.

Screen_Shot_2018-09-10_at_6.41.00_PM.png

Screen_Shot_2018-09-10_at_6.41.14_PM.png

 

 

 

 

Related articles

Comments

1 comment

Sort by Date Votes
  • Senthil
    • Edited

    This doc is outdated. In the SUBSET FILTER FORMULA, use 

    t."countryIsoCode"='US'

    And for more than 1 dimension, using an AND operator, 

    ($countryIsoCode==null).and($channel!='#en.wikipedia')

    0
    Comment actions Permalink

Please sign in to leave a comment.