Skip to Content

Merge a Dimnension Which has One to Many Relationship

Feb 06 at 01:08 PM


avatar image

Hi All,

I have a question around merged dimensions to see if the following is possible:

PGR to Region Lookup:

BEx query:

Desired Output:

What we are trying to do is to use the document date along with the PGR value to see which region the value should belong to. It works for values where there is only a one to one relationship with the merged value. However, when we try to perform the lookup through variables, etc., (in the above example, see PGR B03) it doesn't seem to perform the lookup correctly as it only checks the first date it finds in the merged dimension.

Any thoughts on how to proceed here would be most appreciated.

Thanks in advance for any assistance provided.

ietna.png (5.0 kB)
rwpox.png (2.7 kB)
tjueu.png (3.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers