Issue in Join Cardinality in Report Studio

[ankit.agg.2008]

Hi Everyone,

I have one requirement where there is one table ( sample data attached ) which is to be used in report.

In this, First I need to pick records of a particular status (say Notified) between a particular time period (say 01-Mar till 31-Mar)
and for all the account no which are coming as a result of this query we need to show all the records in available in the same table.

So from the sample data provided :

1st Query will give output as :

Account_no|Status|Status_date
10             |Notified|01-Mar-2014
30             |Notified|10-Mar-2014


Final output of the reports should be like : ( all the records in that table from these two accounts no. )

Account_no|Status|Status_date
10             |Notified|01-Mar-2014
10             |Closed|05-Mar-2014
30             |Notified|10-Mar-2014
30             |Recall|15-Mar-2014
30             |Closed|10-Apr-2014

Thanks.

[Lynn]

It would be better to model it in Framework Manager since the join within Report Studio will probably be less efficient.

What is your question exactly? Have you created two queries in your report and joined them? I would say 1...n cardinality might make sense. Have you tried different cardinalities and seen the generated SQL and result sets as you expect?

[ankit.agg.2008]

Thanks, Lynn. For your time and revert. I fixed the issue. Cardinality was working, there was some browser issue which was displaying the same result every time.