SAP Knowledge Base Article - Public

1642973 - Not able to generate an Webi Report in BI 4.0

Symptom

 

  • When creating  Webi (Web Intelligence) based on e-fashion universes in BI 4.0 throws
  • Error "A database error occurred. The database error text is[Microsoft][ODBC Driver manager]Data Source name not found and no default driver specified.(WIS 10901)"
  • Works fine in BI launch Pad

Environment

  • BI 4.0 Support Pack 02 Patch 4

Cause

  •  By default when we install 4.0 client tools we wont get the default e-fashion universe

Resolution

  1.  We need to copy the webi folder from the installation directory of Business Objects and the path is
    "Installation Directory-Program Files(X86)-SAP Business Objects-SAP Business Objects XI 4.0-Samples-Webi
  2. Paste the webi folder in the client machine
  3. Create DSN connection-Control Panel- Administrative tools-System DSN-Click on Add and select Micro Soft Access Driver(*.mdb)
  4. In universe designer tool open the eFashion universe and click on File-Parameter #Click on edit and change the data source name to the newly created DSN and test the connection server is responding and able to see the table
  5. Save the universe and able to create new webi report through e-fashion in webi rich client

Keywords

Unable to create Webi Report, E-fashion universe , KBA , BI-BIP-SL , Semantic Layer , How To

Product

SAP BusinessObjects Dashboards 4.0