on 06-19-2012 6:44 PM
I have two derived tables that have a SQL that uses DB Links. I wanted to know if anyone has implemented Table Mapping or if this is even possible for Derived Tables in the Universe. I have worked with Applying Table Mapping Restriction on regular tables.
Any Insight or help is appreciated.
Hello,
Are you sure you are looging in as the user on which the table mapping restriction has been applied.
Regards,
Laxminarayana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Just checked this SAP #169659. Table mapping is not supported for derived tables. IN BI 4.0 it gives a clear error message
Symptom
Table mapping is not working with a derived table in Manage Access Restrictions.
Environment
Business Objects XI3.1
Any Service Pack
Reproducing the Issue
From Universe Designer:
- Import 'Island Resorts Marketing' from a CMS
- Add a derived table 'City_Restricted' with the following definition: SELECT * FROM City WHERE City.city_id<=30
- Add a new restriction from 'Tools/Manage security.../Manage Access Restrictions': table mapping with original table 'City' and replacement table 'City_Restricted'.
- Assign the above restriction to a regular user from the CMS
- Export the universe
From DeskI:
- Using an administrator, create a new report based on the above universe, containing Customer/City and Customer/Region.
- Refresh and save the report: it contains 49 rows.
- Now open the report with the user having restrictions, and refresh it:
--> An error is raised: Exception: DBD, [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'City_Restricted'.
Cause
Table mapping FROM a derived table is currently not allowed
This functionality does not currently exist in the product
Resolution
An Enhancement Request has been logged under ID ADAPT01194258.
The Enhancement Request (ER) will be considered in terms of future product development when considering possible new features in the next major release. Please note that the ER may or may not be included depending on various factors.
Keywords
Table mapping, Derived tables, access restrictions, ADAPT, 01194258
Hi Tauseef,
Table mapping for derived tables would works as they work for normal tables.
Thanks,
Pramod.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.