企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 2548|回复: 11

How to see the no.of dimensions in cube

[复制链接]

66

主题

395

帖子

544

积分

高级会员

Rank: 4

积分
544
QQ
发表于 2014-3-17 08:05:12 | 显示全部楼层 |阅读模式
Hello,
thanks in advance.

actually i have 4000 thounds of cubes i just want to see the maximum number of dimensions in cube.anyone of them please helpme on this?


thnaks
advance.
回复

使用道具 举报

75

主题

409

帖子

574

积分

高级会员

Rank: 4

积分
574
QQ
发表于 2014-3-17 09:18:11 | 显示全部楼层
This may help.


have you heard of doing a search for similar topics before posting a new question?

By the way if you really have 4000 cubes then I think there is something seriously wrong with your model ...

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

57

主题

378

帖子

507

积分

高级会员

Rank: 4

积分
507
发表于 2014-3-17 09:21:34 | 显示全部楼层
4000 wow. That's by far the largest number I've heard of. I wonder if this is a conversion from an old Congos Planning model?
回复 支持 反对

使用道具 举报

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-17 10:08:06 | 显示全部楼层
still i am not able to full the no.of dimensions in cube? kidly someone help me out on this
?
回复 支持 反对

使用道具 举报

86

主题

415

帖子

604

积分

高级会员

Rank: 4

积分
604
QQ
发表于 2014-3-17 10:58:45 | 显示全部楼层
Hi. Are you trying to achieve something like what's shown in the attached - but instead of listing the dimensions and the associated cubes you want to list the cubes only wanting to see how many dimensions each cube contains. There are a few ways to do this. One through the API (as shown in the attachment). The other ways through Excel or a TI process, as covered in the forum.
回复 支持 反对

使用道具 举报

77

主题

392

帖子

558

积分

高级会员

Rank: 4

积分
558
QQ
发表于 2014-3-17 11:09:52 | 显示全部楼层
mincharug.shulft wrote:still i am not able to full the no.of dimensions in cube? kidly someone help me out on this
?

Check the TABDIM TM1 Excel function.
回复 支持 反对

使用道具 举报

77

主题

412

帖子

590

积分

高级会员

Rank: 4

积分
590
QQ
发表于 2014-3-17 11:41:38 | 显示全部楼层
Could be wrong but sounds like the number of dimensions each cube contains is what's trying to be retrieved. Tabdim would work if you keep going with the index number until you hit a blank for the dimension name.
回复 支持 反对

使用道具 举报

71

主题

393

帖子

560

积分

高级会员

Rank: 4

积分
560
QQ
发表于 2014-3-17 11:46:42 | 显示全部楼层
mincharug.shulft wrote:still i am not able to full the no.of dimensions in cube? kidly someone help me out on this?

So what you're saying is that you were either:
(a) Unable to navigate to the thread that Lotsaram pointed you to; and/or
(b) Unwilling to download the workbook that he included in that thread; and/or
(c) Downright determined not to enter your server name in cell B1; and/or
(d) Absolutely committed to not then press the [F9] key?

While people are more than willing to help, in this case you had the solution served up to you on a platter. What, exactly, was the problem that you had with following it?
回复 支持 反对

使用道具 举报

87

主题

397

帖子

595

积分

高级会员

Rank: 4

积分
595
QQ
发表于 2014-3-17 12:05:00 | 显示全部楼层
jrizk wrote:Could be wrong but sounds like the number of dimensions each cube contains is what's trying to be retrieved. Tabdim would work if you keep going with the index number until you hit a blank for the dimension name.

Yup, but when you're not using the API, that is the usual approach for determining the number since neither Excel worksheet functions nor TI give you a function which returns the number of dimensions.

However whack a simple CountA/CountIf function off to the side of Lotsaram's worksheet formulas and bingo, you get the number of dimensions in the cube all neatly lined up. The OP doesn't even give any indication of whether they've tried that, or anything else in that thread.
回复 支持 反对

使用道具 举报

83

主题

418

帖子

603

积分

高级会员

Rank: 4

积分
603
QQ
发表于 2014-3-17 12:11:23 | 显示全部楼层
hello,
thnaks for quick reply.
actually i am using 9.0 applix i cann't able to see? could you please let me know in which version i could see it Tm1 dimension mapping??
thanking u.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-10-20 20:11 , Processed in 0.156483 second(s), 14 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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