calling stored procedure

[pooja]

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.....

[MFGF]

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.

[pooja]

Actually we are able make SP QS. but what we need to do further.


@MFGF
Plz sorry id this is vey simple question

[MFGF]

Once the query subject is visible in a package, just use all or part of the items from it in your report.

MF.