using obiee 11g,
I am trying to use count(distinct(lower un))) in the business layer but its giving me obsolete error.
By searching in the net i think its coming because i am using lower with count of distinct.
Now i tried creating a logical column with lower(un) as uncol1 and then again creating a logical col with count(distinct(uncol1) but this time also i get the error.
I want to know how should i solve this problem?
It can be done by just one logical column but while creating it don't use "Existing Logical Column as Source".
Goto Data Type tab and select the table and then apply formula as LOWER(UN). After that exclusively apply Count Distinct aggr rule by selecting from list.
It will come out as count(distinct lower (un))
I am trying to use count(distinct(lower un))) in the business layer but its giving me obsolete error.
By searching in the net i think its coming because i am using lower with count of distinct.
Now i tried creating a logical column with lower(un) as uncol1 and then again creating a logical col with count(distinct(uncol1) but this time also i get the error.
I want to know how should i solve this problem?
It can be done by just one logical column but while creating it don't use "Existing Logical Column as Source".
Goto Data Type tab and select the table and then apply formula as LOWER(UN). After that exclusively apply Count Distinct aggr rule by selecting from list.
It will come out as count(distinct lower (un))
No comments:
Post a Comment