PowerPivot on TDV composite software
Article ID: KB0083033
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
We are having issues when connecting to PowerPivot on CIS composite software. Please look into it with priority.
PFA for additional details on the issue.
My Details are as follows:
User id: db2660000
Contract: 94591334
PFA for additional details on the issue.
My Details are as follows:
User id: db2660000
Contract: 94591334
Issue/Introduction
PowerPivot on TDV composite software
Resolution
I have done some research on this and found that the SQL like below is generated by PowerPivot. This is not a valid ANSI SQL and is Microsoft specific. By Default the MS tools assume a MS SQL Server source which uses this Syntax.
select [DimcountryView].* FROM [DimcountryView]
This is a known restriction of CIS . There is an existing improvement request to allow our parser and/or odbc driver allow the square brackets I.E ."[" in the query from PowerPivot.
In the meantime, You will have to manually compose & submit the SQL from PowerPivot so that the query is without the square brackets. If you don't use the query builder for Power Pivot and write the queries manually instead, you should be able to work around the issue.
select [DimcountryView].* FROM [DimcountryView]
This is a known restriction of CIS . There is an existing improvement request to allow our parser and/or odbc driver allow the square brackets I.E ."[" in the query from PowerPivot.
In the meantime, You will have to manually compose & submit the SQL from PowerPivot so that the query is without the square brackets. If you don't use the query builder for Power Pivot and write the queries manually instead, you should be able to work around the issue.
Feedback
Yes
No
Powered by
