cancel
Showing results for 
Search instead for 
Did you mean: 

Strange Output in WebI report

former_member207342
Contributor
0 Kudos

Hi

I got a strange Situation.

I have a table

Which has data like

UID FeatureID

1 11

2 22

3 33

4 44

1 11

2 22

Now I have dimension of UID and Measure of FeatureID (COUNT). In Universe.

Now when I add these column in BO Webinteligence Report.

It displays

UID CNT

1 1

2 1

3 1

4 1

Where as query is correct and when run in DB client returns

UID CNT

1 2

2 2

3 1

4 1

What would be the issue. Am I missing in Universe or any mistake in Report.

I am using BO 3.0

--Kuldeep

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Kuldeep,

You may get wrong Count of Feature ID because in the Universe if you use Aggregation Function 'Count' in Object Definition as well as in Qualification of how object will be aggregateed in Object Qualification Properties.

Either Use Count(Feature_ID) or Use simple Object Definition Table_Name.FeatureID and set aggregation function as count in Object Properties Qualification.

I think you are using report level variable CNT to count FeatureID that will display Count as 1 for all FeatureID.

if you are using report level variable to count featureID then use simple Object definition with aggregation function as NONE and use Count fucntion in the report as

=Count(FeatureID)

I Hope this Helps..

Pratik

Former Member
0 Kudos

Hi Kuldeep,

Please check for the ditinct option with the count in the WebI Reports. If that is set then you will get count of distinct FetaureID which i can see in your sample data.