I created a Universe using Information Design Tool and published it to the repository. My data source was MS SQL server 2008. At this point I am able to view the result values in query in IDT.
Now when I try to preview the query in SAP Dashboard Design, I am getting the below error while using Query Builder in SAP Bo XI4 Dashboard designer.
Request processing failed. (XLS 000009)
Request processing failed. (XLS 000009) <com.businessobjects.dsl.commons.exception.NestedException: [Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified>
My Specifications are :
MS SQL Server 2008 in 64 bit OS
I tried creating system DSN in odbcad32.exe in the PC but it didn't work. I still get the error.
Any suggestion on how to resolve it.