企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 155|回复: 2

Record Count in TI process

[复制链接]

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-19 16:02:37 | 显示全部楼层 |阅读模式
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
回复

使用道具 举报

80

主题

402

帖子

587

积分

高级会员

Rank: 4

积分
587
QQ
发表于 2014-3-19 17:32:00 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

82

主题

391

帖子

572

积分

高级会员

Rank: 4

积分
572
QQ
发表于 2014-3-19 18:32:07 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2018-10-22 23:19 , Processed in 0.172038 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表