WEBI: Fetch relative dimension corresponding to lowest measure.

[Former Member]

Hi All,

I want to fetch the dimension value with respect to the minimum amount in a block.

That block has no dimension value as a field.

EG: Data

Plant Product Price Other columns....

P1 A 10

P1 B 20

P2 C 30

P2 D 40

Expected Result

Plant Product Price Other columns....

P1 A 10

P2 C 30

Using context I can get the Plant wise lowest Price column but not able to get the Product, It is getting me #MULTIVALUE.

Thanks in Advance.

[former_member492038]

Any chance your database supports database ranking? If so using that at the query level would be preferable to any report level calculations