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???