Microsoft ODBC data manager not found

240 Views

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&gt

My Specifications are :

MS SQL Server 2008 in 64 bit OS

BO 4.0

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.