Creating a Compound Live Access RDBMS Source
You can create a compound Live Access source that combines more than
one table from the source relational database into a single data source
in Birst.
Important: If you use the Data Flow page to
map Live Access sources you should not use the Manage Local Sources page
to modify them. Conversely, if you have used the Manage Local Sources
page to map your Live Access sources, you should continue to use the Manage
Local Sources page and should not use the Data Flow page to modify them.
To create a Live Access compound source
using the Data Flow
|
3.
|
In the Import
Table/Cube Definition dialog box, select the connection to use then select
Import a Compound Table.
|
|
4.
|
On the next
screen, select the tables to import and type the name you want to use
for the compound table. For example, import the Order Details and Orders
tables and naming the compound table "Orders".
|
|
5.
|
After clicking
Import, the new source appears on the Data Flow page diagram.
|
|
6.
|
Right-click
the source and select Manage Sources. The Modify Data Source dialog shows
the imported columns.
|
|
7.
|
Click the
Properties tab. Specify a join condition between the two tables.
|
|
8.
|
Click
Save and Close in the Modify Data Source dialog box.
|
|
10.
|
Create
joins between Live Access sources as necessary. To create a join between
tables that have the same column but use different column names, you can
do a complex join to a related
source.
The columns from the Live Access sources you create become available in
the Subject Area of Designer or Visualizer.
Tips: |
You can only create
joins between Live Access sources. Joins cannot be created between warehouse
dimensions or measures and Live Access sources. Joins also cannot be created
between Live Access sources and raw data sources.
Column names in PostgreSQL
databases are case-sensitive. You need to use quoted column names when
defining joins. For example: "Categories-New Level"."CategoryID"="Products-New
Level"."CategoryID"
You can add custom
columns and expressions to your Live Access sources. See Adding Custom Columns and Custom
Expressions to a Live Access Source.
See Also
Creating a Live Access
Connection
Creating a Live Access
Opaque View (Query) Source
Modeling
a Live Access Relational Database Source