Incompatable objects error in UDT

[former_member184582]

Hello,

I have 3 tables Namely

1)Customer

2)Omniture   and

3)Orders

I have made a Inner Join between customer and omniture tables to get common records on field say "Profile ID".

Now this has been left outer joined with the table "orders" to see how many profiles_Ids have raised the orders.

Now,

I have created 2 measure objects each from orders and omniture tables.and one dimension object say "state" from customer table.

whats happening is

If I include all the 3 objects in one query i am getting" Incompatible objects-cannot generate query" error.

SQL Syntax I used:

==============

select c.CUSTATE,COUNT(om.VisitDate)#TimesVisited,COUNT(o.ORRFNBR)#OrdersPlaced

from NUTRISYSTEM.dbo.CUSTOMER c inner join RECONDB..tbl_DFA_OMNITURE_WEB_REPORT om

on c.CURFNBR=convert(int,om.Profile_ID)

left join NUTRISYSTEM.dbo.ORDERS o

on om.Profile_ID=convert(varchar,o.ORCURFNBR)

--where ORDTSTMP between '2000-01-08 17:21:56.000' and '2000-01-08 18:23:08.000'

where CreatedOn='2011-02-09 09:04:50.773'

and CUSTATE<>''

group by CUSTATE

This is giving results in sql server. But in UDT it is throwing error if i include the objects together to run the result.

Request you to advise on this issue.

[Former Member]

Hi Appana,

Query seems to be simple, check the object definition is it successfully parsed, check all for integrity check. Are you using combine query in Webi?

Regards,

Rama

[former_member207342]

An image of joins between tables would help everyone to solve your issue.

Do you have context in Universe. Also check if you have enabled "separate sql for each measure" option.

--Kuldeep

[former_member184582]

This message was moderated.