企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 419|回复: 3

PeriodsToDate on TM1 cube with Report Studio

[复制链接]

91

主题

407

帖子

615

积分

高级会员

Rank: 4

积分
615
QQ
发表于 2014-3-20 19:26:38 | 显示全部楼层 |阅读模式
Hi,

I am using Cognos Report Studio with TM1 cube

I have a requirement to show the numbers for all the previous years in the cube based on a year selection. I thoght this is easy (coming from a transformer cube background) and used periodsToDate function. But the following function just displays the selected year instead of the set of previous years till the selected year.

periodsToDate ( [Cube].[Dimension].[Hierarchy].[Year], [Selected Year])

Can anybody tell me if there is any issues for using periodsToDate function on TM1 cube, or may be I am missing something

Thanks in advance,
Siyad
回复

使用道具 举报

70

主题

357

帖子

523

积分

高级会员

Rank: 4

积分
523
QQ
发表于 2014-3-20 20:44:23 | 显示全部楼层
Unlike Powerplay & Transformer TM1 cubes have no concept of a special time dimension and therefore no "built in time intelligence".  Time dimension(s) are just like any other dimension.  Reporting of YTD, rolling MAT, etc are typically handled via rollups within the time dimensions and vs LY type measures typically via rules or a combination of rules and rollups.

This is a significant disadvantage of TM1 vs Transformer as adding this kind of functionality is more or less roll your own (TM1 does have it's advantages though.)  This can be a bit of a learning curve.
回复 支持 反对

使用道具 举报

81

主题

389

帖子

575

积分

高级会员

Rank: 4

积分
575
QQ
发表于 2014-3-20 21:34:51 | 显示全部楼层
Thanks for your reply and I will try to get the rollup done in the TM1 cube,

So this means that I cannot use the typical date functions like periodsToDate() on a TM1 cube to get a set of all the previous years in the system or YTD etc...
回复 支持 反对

使用道具 举报

64

主题

373

帖子

515

积分

高级会员

Rank: 4

积分
515
QQ
发表于 2014-3-20 22:01:00 | 显示全部楼层
You can still use any valid MDX commands in Report Studio as MDX is unaware of time as well.

The trick to remember with OLAP is that you are always dealing dimensions and therefore are using logic based on sets of members or levels to get what you want.  Functions like descendants and head, tail, except, etc. can all be combined to dynamically derive the correct member set for reporting.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-11-14 19:13 , Processed in 0.165684 second(s), 17 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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