How to count number of occurance of a dimension

building reports webintelligence
1

Hi,

Here is the case.

In my table,there are two dimension objects.
If Dimension_2 has got multiple values for a particular value of Dimension_1,then this dimension_2 needs to be displayed from another data provider else it has to be displayed from same data provider.

How can we implement this in webi ?

Thanks & Regards,

Binnu

binnu23 :india: (BOB member since 2010-05-21)

2

Not sure how you have your dimensions merged (if merged at all), but shouldn’t Count(dimension) give you the count, and then you can compare?
if count(DP1.dimension_2)>1 then DP2.dimension_2

Depending on where you are using this you will need to add contexts or not (foreach, in, etc…)

jmsalash (BOB member since 2013-07-16)