Skip to Content
0
Former Member
Apr 09, 2013 at 09:38 PM

count function doesnt work on webi

157 Views

Hi,

I am having a weird behavior in web intelligence.

I have a measure where I count the quantity of clients,

when I use this measure in the queries section on the IDT work fine, but when I use it into web intelligence doesnt work and for every item the count is 1

this is my sql expression

count(@catalog('PE_CONN')."ADMIN"."CACREDIT"."CLDOC") also in the projection function I choose "Count"

In another universe I use the same database field and sql expression and works fine in IDT, Webi etc

What is wrong???