Skip to Content
0
Former Member
Jan 11, 2017 at 11:02 AM

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

812 Views

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.