RS - Problem doing an explicit join in Report Studio

[CArnold40]

In Report Studio I do the following:

1) I create a query (named Loan_Fact_Query): "Select loan_fact.loan_key lf_loan_key, loan_fact.loan_amount from loan_fact"
2) I create a query (named Loan_Dim_Query): "Select loan_dim.loan_key ld_loan_key, loan_dim.loan_date from loan_dim"
3) I create a 'JOIN' query (Named Loan_Join) from the Insertable Objects
4) In Loan_Join I put Loan_Fact_Query and Loan_Dim_Query, and join them on loan_key
5) I go into the report layout and try dragging anything from the Loan_Join query (in the Data Items tab) into my layout

When I do that I get the following error:
"Unable to insert this data item here because the query context "Loan Fact" is not the same as the data item's query "Loan_Join"

Does anyone have any idea what I'm doing wrong here?

Any help would be greatly appreciated.

Chris

[Cognerd]

Sounds like you've done the basics. Have you verified that you've created the link in the relationship. You have to click the link button and choose the fields as well as set the cardnality.

Also, Simplify your two base queries down to only the join fields as a general troubleshooting attempt.

[CArnold40]

Yes, I did go into the join object & create the join (1-to-many).

Also, I did try to simplify my base queries by removing all fields except for loan_key (which the 2 tables join on). And I still get the same message.

Chris

[keviv]

Hi Chris...

This problem has an easy solution! :)

When we create a new report, the Layout associates itself with a query 'Query1' by default which we start using in the report normally. This 'Query1' would have become your 'Loan_Fact_Query' to which the layout is associated.

After creating the new query Loan_Join, we have to associate the list/crosstab in the layout to the new 'joined' query using the ancestor button on top of the properties tab.

This would enable you to drag anything from the Loan_Join query (in the Data Items tab) into the layout.

Vivek