Symptom
Create a new web intelligence report, on queries with more than 3 joins, it leaves out the "AND" and it causes a syntax error.
We get the following error on running this web intelligence report: "Database error: [Microsoft OLEDB Provider for SQL Server]: The number name 'EP.dbo.WNL_VN001.VINMRCURRENT' contains more than the maximum number of prefixes. The maximum is 3. Contact your BusinessObjects administrator or the database supplier for more information. (Error WIS 10901)"
Read more...
Environment
BusinessObjects Enterprise XI Release 2 Service Pack 5
Product
SAP BusinessObjects Business Intelligence platform R2
Keywords
The number name contains more than the maximum number of prefixes The maximum is 3 WIS 10901
, KBA , BI-RA-WBI , Web Intelligence , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click
more to access the full version on SAP for Me (Login
required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.