Answers for "can I use CTE tables in IDT Universe . I am using BO 4.1, service pack 6."https://answers.sap.com/questions/101472/can-i-use-cte-tables-in-idt-universe-i-am-using-bo.html
The latest answers for the question "can I use CTE tables in IDT Universe . I am using BO 4.1, service pack 6."Answer by Chaz Pehttps://answers.sap.com/answers/117480/view.html
<p>Thank you Amit. This helped</p>Tue, 31 Jan 2017 16:59:40 GMTChaz PeAnswer by Chaz Pehttps://answers.sap.com/answers/101538/view.html
<p>Hi Amit,</p><p>Thank you for your response. I created a derived table using the baove SQl expression, but I am getting the error message saying:</p><p>Cause of Error
Incorrect syntax near the keyword 'WITH'.</p><p>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.</p>Wed, 11 Jan 2017 12:01:00 GMTChaz PeAnswer by AMIT KUMARhttps://answers.sap.com/answers/101530/view.html
<p>You can try with creating derived table in the IDT universe.</p><p>http://www.forumtopics.com/busobj/viewtopic.php?p=745726&sid=6d3c8c65b4f81563c3206da38c9d4e9f</p>Wed, 11 Jan 2017 11:50:02 GMTAMIT KUMAR