Categories
Passing plain values to Data Actions, not queries

In our design, we have multi level hierarchies (BOMs). Every level is based on values from the same dimension (Item). However, it is possible to tie back only one level. quite often it is required to get item attributes for one of the level values, which are not linked to item. In classic mode I can do this by using appropriate filters. In DV this is not possible, because the relationship is maintained between canvases. This leads to the effect, that I get no results.
Example:
BOM consists of Root Item, Parent Item, Component Item. Only component is linked to Item dimension. However, I want to know about item attributes for Parent, or Root. This is not possible up to now.
Comments
-
Hello.
It seems to be a case where you would use the Hierarchy functionality, built-in in OAC.
Can these help?
- "Create and Manage Dimensions with Parent-Child Hierarchies"
- "Create and Manage Dimensions with Level-Based Hierarchies"
HTH,
Marcelo
0 -
Hi Marcelo,
actually we have a level based hierarchy.
However, this ties back to my idea Configuring filter sessions between visuals — oracle-products
Let's assume, I filter all level 1 root items by certain item attributes. Now, if I want to check the entire BOM, I do not get it immediately, because all values in the visual I select are passed as parameters. So I get only root item and not the entire BOM in the second visual, or canvas.
I need to adjust filters every time I want to check a new BOM.
This is not really handy.
Thanks for the hint, though,
Franz
0 -
To understand a bit better, you want to pass the hierarchy as an object and then set the value/level in the destination. Is that right?
0