企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1002|回复: 2

Exporting Data in CSV file

[复制链接]

83

主题

392

帖子

567

积分

高级会员

Rank: 4

积分
567
QQ
发表于 2014-6-29 12:36:28 | 显示全部楼层 |阅读模式
Hi ,

I am trying to export data from a cube and putting in a CSV file. To do this i am creating a view , In that view i need to export data for 2 measures.

When i am creating the View in the subset for measure dimension i am wrinting as below.

SubsetCreate('Measure',Subsetname);
SubsetElementInsert('Measure',Subsetname,monthlyvalue,1);

When view is creating it creates with monthlyvalue (measure),

when i am extracting the data into the file it is missing some data because for those elements monthlyvalue is 0 for other measure there is data but it is not exporing into the file.

Here when i am extracting i am skipping the data which is 0 by using viewextractskipzerosets(cube,view,1).

Any one can help on this.
回复

使用道具 举报

81

主题

411

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-6-29 15:48:04 | 显示全部楼层
The Ti is behaving as it should as you have not defined the second measure in your view.

If you need to export data from both measures you need to create a View with both measures i.e. add another line when creating a view like:

SubsetElementInsert('Measure',Subsetname,AnotherMeasure,2);

This will ensure your data source contains all rows of data where there is a value against either or both of the measures.
回复 支持 反对

使用道具 举报

89

主题

395

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-6-29 16:18:08 | 显示全部楼层
Just to point out that you will then get the two values on different rows. A TM1 view delivers data a cell at a time, iterating round the other dimensions. I suspect that the OP wanted to output both values on the same row - and hit problems with zero suppression when one cell was zero and the other was not.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-11-25 12:42 , Processed in 0.146931 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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