we have been asked to use Stored Procedure to generate report.this is the 1st time ever we are trying.but without having much knowledge
Our backend--db2.
please help us by providing a best approach in details (if possible)
thank you again in advance....a lot.....
Hi,
Assuming your stored procedure returns a consistent result set, you can firstly import it into Framework Manager - it will result in a new Query Subject in your model - then link this to the rest of your metadata model via a relationship if required, then make sure the Query Subject is included in a package and publish the package.
Once you have done this, you can use the query subject in a report as normal.
Regards,
MF.
Actually we are able make SP QS. but what we need to do further.
@MFGF
Plz sorry id this is vey simple question
Once the query subject is visible in a package, just use all or part of the items from it in your report.
MF.