In general, join relationships are created in
Framework manager. However, you can create join relationship in report studio if
what you are trying to do is not modeled in Framework manager.
A Join is a way to combine fields from two tables by
using values that are common to each.
After creating a join query you need create Join
relationship and Cardinality.
This is one to many relationship.
This is considered to be an inner join that returns
rows when there is at least one matching record found the both tables. So this
will return Product line Rev with associated budges because the joined query
will look for the records where the same Product line appears in the Budget
query and Revenue query.
Create
a Join Relationship
1. Go
to Query Explorer, from toolbox drag query object to work area. Rename the
query to qProductLineRevene. Double click on the query and drag Product Line
Code, Product Line and Revenue from Sales (query) folder to Data Items pan.
2. Go
back to query explorer, from toolbox drag another query to work area and rename
the query to qProductLineObject. Double click on the query and drag Product
Line query items from Sales Target (Query) Folder to Data Items pane.
3. Go
back to query explorer and drag Join query to the work area.
4. Double
click on the join /click on Join and from properties pan click on Join
relationship.
5. Click
New Link.
6. To
create the link, click a data item in the left query, and then click a data
item in the right query. In our example that is Product line code in Left query
and Product Line code in right query.
7. By
default you will have one to many cardinality. According to your requirement
you can change the cardinality. You can easily understand cardinality affect in
the relationship impact description.
8. Go
back to query explorer and double click on the join query and drag the data
items from the source tab to the data items pane.
No comments:
Post a Comment