Hello,
Is it possible to have a dimension variable defined to only give the top 10 based on one measure?
I am doing this because I need a dimension to set as an Input Control on a chart which has a top 10 ranking (based on the same measure). But the actual dimension is over 3000 and I only want the user to select from the top 10 dimensions.
Does anyone know how to do this?
I recently started BOXI.
Regards
rainmaker_ 
(BOB member since 2010-10-28)
yes you can do by creating the derived table which will give only top 10 values. This is the universe level.
Second option is(in the Report level) apply the rank in the table, and filter only >10, by this way you can do this.
Pls refer this link it may help you.
lovebo 
(BOB member since 2010-10-06)
Hi,
This has to be on report level.
And i am aware of applying the ranking to a table. That is not what i was asking for.
I have applied the ranking to a chart to show just the top 10. Now on this chart I want an Input control (checkboxes) for the dimension but the input control sidebar should only contain the top 10 checkboxes rather than 3000.
rainmaker_ (BOB member since 2010-10-28)