8 Replies Latest reply on Jan 3, 2017 9:54 PM by Sahithya Reddy

    Hiding a dimension in the hierarchy conditionally

    Sahithya Reddy

      Hi,

       

      I have a hierarchy created in my dashboard as Country->State->City using oracle data source. I have a spreadsheet having column as 'Limit' which has value 'yes' and 'No.

      I used Data blending to relate these 2 data sources.

       

      My requirement is

      1. if Limit value is 'Yes' then hierarchy should be as 'Country->State->City'

      2. if Limit value is 'No' then hierarchy should be as 'Country->State'. City should not be seen in the hierarchy.

       

      Is it possible to hide a dimension in hierarchy conditionally.

       

       

      Thanks,

      Sahithya