Symptom
- Using @prompt for Table Mapping in Universe Restriction does not work in BI 4.0
- When selecting the original table (DB1.Table1) in a query, a prompt appears to select the schema but the swapping is not handled correctly
- The wrong SQL is generated in BI4:
- SELECT 0.TABLE1."idTable1", 0.TABLE1."stringTable1" FROM TABLE1
- The expected SQL (what is generated in XI 3):
- SELECT DB2.TABLE1."idTable1", DB2.TABLE1."stringTable1" FROM DB2.TABLE1
Read more...
Environment
- SAP Business Intelligence 4
- Web Intelligence
- Universe Designer
Product
SAP BusinessObjects Business Intelligence platform 4.0
Keywords
WebI, WebIntelligence, Web intelligence, sql, generation, generated, table, map, mapping, universe, restriction, row level, security, manage, not, does, work, working, unable, syntax, error, exception, IES WIS 10901, multiple, swap, switch, different, wrong, correct, Incorrect syntax near '.' , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , Product Enhancement
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.