Skip to Content
0

can I use CTE tables in IDT Universe . I am using BO 4.1, service pack 6.

Jan 11, 2017 at 11:02 AM

89

avatar image

can I use CTE tables in IDT Universe. I am using BO 4.1, service pack 6.

Below is the expression I am using:

WITH CTETableName AS ( SELECT 'AB' as Code, 'AppleBannana' as Description UNION SELECT 'CD' as Code, 'CarsDoddle' as Description UNION and so on) SELECT * FROM TableName

The reason why I am using this CTE table is there is no fct or dimenson table in datawarehouse nor there is a lookup table. This is a temporary solution till the lookup table is created in Datawarehouse.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Jan 11, 2017 at 11:50 AM
0

You can try with creating derived table in the IDT universe.

http://www.forumtopics.com/busobj/viewtopic.php?p=745726&sid=6d3c8c65b4f81563c3206da38c9d4e9f

Share
10 |10000 characters needed characters left characters exceeded
Chaz Pe Jan 11, 2017 at 12:01 PM
0

Hi Amit,

Thank you for your response. I created a derived table using the baove SQl expression, but I am getting the error message saying:

Cause of Error Incorrect syntax near the keyword 'WITH'.

The trouble is when I ran this query in Datawarehouse it is giving me the dataset. Not working in IDT when I right click on the table and click on Table Values.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

don't put WITH in the derived table.

Place your SQL statement only and try

SELECT 'AB' as Code, 'AppleBannana' as Description UNION SELECT 'CD' as Code, 'CarsDoddle' as Description UNION and so on) SELECT * FROM TableName

1
Chaz Pe Jan 31, 2017 at 04:59 PM
0

Thank you Amit. This helped

Share
10 |10000 characters needed characters left characters exceeded