Skip to Content
0
Former Member
Sep 27, 2010 at 03:24 PM

Problem defining mesures with exclusive conditions

16 Views

Hi Folks,

I am facing the following requirement: I need to create 2 measures in the universe

measure A: number of users with condition --> IP.PersonProfile.IsCurrent = 1 AND IP.PersonProfile.Registered = 0

mesaure B: number of users with condition --> IP.PersonProfile.IsCurrent = 1 AND IP.PersonProfile.Registered = 1

Once created I have tried to create a report with these 2 measure, and this is the SQL generated:

SELECT DISTINCT

count(IP.PersonProfile.PersonProfileId),

count(IP.PersonProfile.PersonProfileId)

FROM

IP.PersonProfile

WHERE

( IP.PersonProfile.IsCurrent = 1 AND IP.PersonProfile.Registered = 0 )

AND ( IP.PersonProfile.IsCurrent = 1 AND IP.PersonProfile.Registered = 1 )

Query does not return any answer beacuse generated SQL contains exclusive conditions instead of doing separate queries and uniong them. How can I force BO to give me the expected query?

Thanks