Method to Reverse the Derivation from Dimension Property

[bautayakool]

Hello experts,

I have an inquiry about dimension ID derivation by referring to the property. As normally, we can derive a dimension member by looking at the property.

For example, we have 2 dimensions: product dimension and product group dimension. Product dimension contains product group property which can be used to derive member ID in product group dimension, as shown below.

Given the dimension properties, if a value is inputted in product dimension, we can derive product group using data action by using:

"data([d/product_group] = [d/product].[p/product_group]) = resultlookup()"

What if the case is reversed? Is there a way to derive product dimension when value is inputted in product group dimension? For example, product group A got a sales amount of $10. Is there a way to look into product dimension to map product dimension's property to product group ID to get the product dimension id?

Thank you.

Bhumirapee Autayakool.

[N1kh1l · Accepted solution]

@bautayakool 

Try the below

FOREACH [d/costcentre],[d/productline]

IF [d/costcentre]=[d/productline].[p/costcentre] THEN

DATA()=RESULTLOOKUP([d/productline]="#")

ENDIF

[bautayakool · Accepted solution]

It worked! Thank you so much for your guidance!