select on higher level in hierarchy
Hello all,
I have this dataview where the products are on the rows.
There are a couple of columns that are higher level entities:
Now there's always the possibility to select by the rows' axis in the context menu of the dataview.
I would like to expand that feature, by means of procedures, and build a context menu like the following:
Now the first one is done easily. It's just a two step procedure with "Apply selection to screen" and "Refresh screen".
Is there a way to make a selection broader? In my example instead of filtering on the product, filtering instead on the product group. Product and product group are part of the same tree.
BR, Ray
Answers
-
Maybe i didn't understand your question but cant you use a pager for the high level of the dimension / entity tree (product group)? That would filter all products within that group. If not, why?
Also i am not sure if you know but you can do multiple tree selections within the selector object in a screen.
0 -
Hi Ray Martens,
A 4 step procedure should do it :
1. Select entity "Product Group" based on cube in "Keep Mode"
- For the cube use the one in your dataview
2. Remove selection on "Product"
3. Apply selection to screen
4. Refresh screen
Tested it quickly and it seems to work fine.
Regards,
Nicolas
3 -
Hi Miguel Angel Sisternas Seaton,
The idea was that using the procedures I directly have the context of the row. The user sees what is going to be filtered without having to use another element on the page.
BR, Ray
0 -
Hi Nicolas CHIGROS,
now that's a clever trick! Thanks!
Can it be said, that your solution is kind of like the The Focus function ?
BR, Ray
1 -
Yes, kind of
0