Record Count in TI process

[manoj928]

Hello All,

In a TI process , we have a DB SQL which pulls data from database and stores it in a cube. Now using same TI process, we want to know, how many records are pushed to cube from DB table based on all logic included in SQL and want to send a mail with number of records pulled to specific users.

Also is it possible to get number of records getting pushed from one cube to another if using TI, we push data from one cube to another. Here as well we need to send no of records pushed through email to users.

Any help would be highly appreciated.

Thanks,
Manoj

[jim wood]

On the 2 points:

1) Counter all you need is a incremental variable that you set to 0 in the prolog and add one in the data tab: prolog: variable=0 data: variable=variable+1

You can then send this to a counter cube so you have it for reference.

2) Mailing the result isn't as easy as it sounds. If you search Google I think the guys at TM1 Tutorials created some email code. Create a process for this code and in the epilog call this process passing the variable counter result as a variable to that process. Please keep in mind that to run the email code you will need access to a mail server. You should be able to pick this up by looking through instructions that TM1 Tutorials put up with the code.

I hope this helps,

jim.

[rkaif]

You can also create some "Status" cubes which stores the information related to the number of Records Read, Skipped, Completion time etc.

Sending results through emails would be one option but if you are using Cognos in your environment then in that case you can use Event Studio to send alerts to the users.