Passing plain values to Data Actions, not queries

Franz Keller

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.

Marcelo Finkielsztein

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

Franz Keller

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

Bret Grinslade - Oracle Analytics-Oracle

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?