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.