- 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:
- 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.
The issue has been identified and logged under Problem Report ADAPT01580965. This is the default behavior of the Product.
The issue has been identified and logged under Problem Report ADAPT01580965.
Specified RDMS is invalid, SQL generation failed, WIS 00013 , KBA , BI-RA-XL , Dashboards and Presentation Design , Bug Filed