Stored Procedure with existing input paramters

[Former Member]

Dear all

I have the following case:

How i can convert/call the following oracle procedure to universe or DI reports:

(Note: the input parameters a,b,d and e are existed objects in the universe )

==========================================

create or replace procedure p1(a number,

b number,

d date,

e in out number,

tt in out number,

x in out date,

p_late in out number)

is

c number;

begin

c := b / e;

if a<= b then

p_late := a / e;

else

tt := a -b;

p_late := c +1;

loop

x := add_months(d,-1);

if tt> e then

tt := tt - e;

p_late := p_late + 1;

if p_late >= 12 then

exit;

end if;

else

e := e / 2;

if tt >= e then

p_late := p_late + 1;

else

p_late := p_late;

end if;

exit;

end if;

end loop;

end if;

end;

==============================

Can i use the derived table ????

Regards;

Mohammed A. Kafaween

[Former Member]

Hi

I tried to do a stored procedure , but the idea of OLAP and BI was not so effiecient in this case , i mean that i need to use the existing objects , because the stored procedure will repeat calculating the current objects in order to generate a new one .

So , please if there any idea about the loops in Designer , DI or WebI , please notify me.

regards

[PPaolo]

Hello,

you can create a Universe based on stored procedures.

To do so, when you create the connectivity for the Universe select to use Stored Procedures.

You'll be able to fill in the input parameters with other business objects or with prompts.

Notice that a stored procedure universe will allow you to run queries only on stored procedures (you cannot mix in a query objects coming from stored procedures and from tables, objects defined on tables can be used only to fill in the stored procedures input parameters).

Best regards

PPaolo