Symptom
- Getting the error message "Universe xxx Not found (XLS 000006). The data source cannot be generated for the specified data Source name xxx." when adding a query in Dashboard Design tool 4.0 based on a MS Access UNX universe as shown below:
Environment
- SAP BI4.0 SP01 or SP02 and above
- Dashboard Design 4.0
Reproducing the Issue
- Launch Dashboard Design 4.0
- Create a new query using Query browser
- Select the unx based on MS Access data source
- Add Dimesions and Measures in the Query Panel
- Run the Query and the error message is raised.
Note: IDT(Information Design Tool) and WebI Report work fine.
Cause
The issue has been identified and logged under Problem Report ADAPT01580965. This is the default behavior of the Product.
Resolution
The issue has been identified and logged under Problem Report ADAPT01580965.
Keywords
Specified RDMS is invalid, SQL generation failed, WIS 00013 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Bug Filed
Product
SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.0, feature pack 3
Attachments
XLS00006.jpg |
xcproc_BOBJDEV.DashboardDesignProcessingServer_child_DSL2_trace.000001_SQL error.rtf |