Alias table in obiee with example

2020-02-27 06:55

Jul 17, 2013 Advantages of using Alias Table in OBIEE. Example: Consider, there is an sales table, it has two columns in that, namely, OrderDate and ShippingDate, both columns have to be joined to the Time dimension. In such a situation we can create alias for the Time dimension, like OrderDateDim and ShippingDateDim. Now join the sales table to these tables on different keys.Oct 23, 2013 Why do we need Alias tables in OBIEE. ? Alias tables are an important part of designing a Physical layer because they enable you to reuse an existing table more than once. An alias table is a physical table that references a different physical table as its source (called the original table). alias table in obiee with example

Apr 04, 2011  OBIEE Interview Question Alias Table Labels: obiee alias table, obiee circular joins, obiee interview questions. 2 comments: As an example for your your situation, lets say you have an Employee table which you want to act as both Employee and Supervisor table. You will create an alias of Employee table EMP (empid, emp

can I set a filter in an alias physical table in the repository. Ask Question ID, translation. this table is used for different translations of different categories. For example I want the translation of the postalcode, then I have to take. select from translationus where category'postalcode' OBIEE 12c RPD how to put sql code in Feb 06, 2014  Alias table in OBIEE11G. Text Example: Consider, there is an sales table, it has two columns in that, namely, OrderDate and ShippingDate, both columns have to be joined to the Time dimension. In such a situation we can create alias for the Time dimension, like OrderDateDim and ShippingDateDim.alias table in obiee with example Jul 11, 2013 Creating an alias creates a copy of the metadata table object that will be referenced in SQL with a new alias name. The alias name in SQL, as it is for all tables, will be derived its metadata ID. So an alias table can be a reference to any of the LTS types.

Alias table in obiee with example free

Feb 08, 2014 OBIEE Training Tutorial: This video shows how to alias physical tables and create table joins. alias table in obiee with example STEP 1: Creating the Alias. 2) You will be given a prompt to create a new table. You will need to fill out the name in the General tab, and assign its primary key in the Keys Tab. For this example, select EMPLOYEEID as the primary key: 3) Hit OK and you should instantly see your new table. Aug 12, 2011 For example, you can prefix the alias table name with the table type (such as fact, dimension, or bridge), and leave the original physical table names asis. Some organizations alias all physical tables to enforce best practice naming conventions. Another use for alias tables is to resolve circular joins. Creating an alias creates a copy of the table in metadata that will be referenced in SQL with that alias name. It will have its own ID, distinct from the parent table. For example: Parent Table Invoice id 1000 Alias Table CancelledInvoice id 2021 when the OBIEE engine writes the Click on a table (COUNTRIES table in my case), right click on the table and choose New Object Alias . You will see the following screen: Enter the name of the alias. On Columns tab, you will see the column definition in your OBIEE repository. Click on OK . Here is the D1 Countries Alias for COUNTRIES table.

Rating: 4.58 / Views: 895