Using stored Procedure in WebI

[Former Member]

Hi,

I am facing problem in converting one Desktop Intelligence report to WebI. One DP in the DeskI report has a Stored procedure. I am new to this kind of migration and have no knowledge on how to use this stored procedure or create any alternative to it for WebI version. RCT is not available to me.

The Stored procedure is called like this-

CALL USERPROCP.rcr_create_facts (@variable('01) Enter Firm Name:'),@variable('02) Enter Firm Number / Rate Rel Code / Assn Nbr:'),@variable('03) 1=Firm, 2=Rt Rel Cd, 3=Assn, 4=Enter Divs, 5=Div Rollup'),@variable('04) Enter State Code (ME,NH,CT):'),@variable('05) Enter Beginning Incurred Date (YYYY-MM-DD):'),@variable('06) Enter Ending Incurred Date (YYYY-MM-DD):'),@variable('07) Enter Beginning Paid Date (YYYY-MM-DD):'),@variable('08) Enter Ending Paid Date (YYYY-MM-DD):'),@variable('09) Run by Incurred Dates (Y / N)?'),

FIRM_NAME,ACCT_STRT_MTH_PY,ACCT_END_MTH_PY,ACCT_STRT_MTH_CY,ACCT_END_MTH_CY,INCUR_STRT_MTH_PY,INCUR_END_MTH_PY,INCUR_STRT_MTH_CY,INCUR_END_MTH_CY)

Regards,

Argha

[former_member497916]

Hi Argha,

You can create a webi report directly on a stored procedure.

However, you can define a universe on a stored procedure and then create a webi report on that universe.

Regards,

Sandeep Mishra