For Each / Dimensional Calculation Context

[Former Member]

Hi,

I have a requirement that I can achieve at the WebI layer but would like to back this into the IDT layer if posible.

The complexity above is that it must calc at the lowest level Product Config Oid.

=(If([TP Object Count]> 0; "YES"; "NO") ForEach([Product Config Oid]))

I am able to replicate with a dimension with the following.

CASE WHEN @Select(Tech Pack Information\TP Object Count) > 0

THEN 'YES' ELSE 'NO'

END

But the gap in the above is that it's not at the detail level for each Product Config Oid.

Please let me know if there is a better method to achieve this.

[former_member4998]

Hi...

TP Object Count and Product Config Oid are two different objects, so if you create an object in the universe for below Like “TP Object Count_YES_NO”

CASE WHEN @Select(Tech Pack Information\TP Object Count) > 0

THEN 'YES' ELSE 'NO'

END

And Drag and drop the TP Object Count_YES_NO and Product Config Oid are into the report….it will YES or NO detail level for each Product Config Oid. Please check once.

[Former Member]

Can you give some example with some sample data for little better understanding of the scenario..

[Former Member]

The only ways that I can think of doing it is with a database function that you could call within an object or maybe via a derived table