Stored Procedure in TM1 10.2.0

[Chittemreddy]

Hello Team,

We are able to call the stored procedure using TI process and it will return the value.

It's possible to load the return value into TM1 cube using TI process.

If 'Yes' can you please let me know process for loading.

Regards
Sreenivas.

[tomok]

Hello Team,

We are able to call the stored procedure using TI process and it will return the value.

It's possible to load the return value into TM1 cube using TI process.

If 'Yes' can you please let me know process for loading.

Regards
Sreenivas.

If you are using the TI wizard and your stored procedure call is the "Data Source" then the wizard will guide you through it. If you are writing custom code then use the CellPutS or CellPutN functions in TI. If you don't know how to do that I suggest you take some training or, at a minimum, read the TM1 documentation about TI's.

[macsir]

Is it oracle stored procedure you are talking about?

[Chittemreddy]

Hello.

Thanks for reply.

We are using the teradata stored procedure.

Regards,
Sreenivas

[Chittemreddy]

Hello Tomok,

If I use the data source as Flat File or ODBC or TM1 Cube View and we will load the data using CellPutS or CellPutN functions.

We are using the below code in Prolog to call the stored procedure and get the return value based on stored procedure.

ODBCOpen('Accounting', 'Jdoe', 'Bstone');
ODBCOutput('Accounting', '{call StoredProcedureName}');
ODBCClose('Accounting');

We need to load the return value in TM1 cube. How to use the CellPutS or CellPutN functions here.

If have some sample code for same it will be very helpful.

Regards
Sreenivas.

[David Usherwood]

That won't work.
Put the call to the SP into the query box. You will then get the output in columnar format into TI variables.