Skip to Content
avatar image
Former Member

Merge a Dimnension Which has One to Many Relationship

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers