COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: saunmik on 13 Feb 2009 03:21:55 PM

Title: Data Manager & Oracle EBS R-12
Post by: saunmik on 13 Feb 2009 03:21:55 PM
We are in the process of building our own data warehouse with Data Manager against the Oracle EBS R-12 views. We are using Oracle 10g for this implementation. This week I have learned that with R-12 I must execute the following code:

declare
begin mo_global.set_policy_context('S','83');
end;

to set the environment so that I can return data. I can do this within Toad, but at this time I do not know how to execute this code within Data Manager so that my builds will return any data. Has anyone run into this kind of thing? Has anyone run this kind of code within a Procedure Nod?

Title: Re: Data Manager & Oracle EBS R-12
Post by: UseCog on 16 Feb 2009 07:26:51 AM
Can you try it using 'Lookup' function. Add all these inside this function

if it is not working just create a stored procedure with those strings and execute from procedure node