Abstracting your tables using aliases
Aliases are a standard way to abstract a physical table within OBIEE. Therefore a single table can be referenced multiple times by using an alias.
Getting ready
Open the BI Administration tool. Import all the tables which are required.
How to do it...
Abstraction allows you to reference an object using a different name. This is effective if you wish to reference the same object multiple times for different reasons (roles).
- Expand your connection under the physical model.
- Select your table, right-click on it, and select New Object | Alias:
How it works...
In OBIEE, it is best practice to use an alias with all your tables. ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
