企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 537|回复: 3

Websheet Portability !!!

[复制链接]

75

主题

398

帖子

573

积分

高级会员

Rank: 4

积分
573
QQ
发表于 2014-3-16 11:31:50 | 显示全部楼层 |阅读模式
Hi Everyone,

We have a small requirement regarding websheet portability. The scenario is : we are forecasting the data based on various sessions, for example "Session A" will forecast 12 QTRs of data, "Session B" will forecast 6 QTRs of data and so on.

Based on user roles and requirements we have designed number of websheets. Suppose a websheet has been designed incorporating "Session A", so for any forecasted measure element, say "Amount" we will be going to have 12 columns corresponding to each forecasted QTR as shown below .

                        untitled.JPG (68.54 KiB) Viewed 144 times               


Now the problem arises when user choose difffernet Session from the dimension filter area in websheet, say he choose "Session B", which will use 6 different QTRs for forecasting.In this case websheet will displays the title header(for QTR) which was used in initial stage for building this websheet, not the new one with new QTRs.

So do we have any way by which we can make websheets portable for such a scenarios? So that when user choose different Sessions, he can only be able to see the QTRs specific to that Session, in other terms column header and number of columns which got populated in websheet could become dynamic.

Thanks for your time and corporation in advance.

Regards,
Priyank.
回复

使用道具 举报

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-16 12:34:27 | 显示全部楼层
Suppose if you already have the 3 different websheets created for each session you could attach a hyperlink to the title element that when selected moves the user to the relevant sheet.
回复 支持 反对

使用道具 举报

82

主题

391

帖子

572

积分

高级会员

Rank: 4

积分
572
QQ
发表于 2014-3-16 14:19:05 | 显示全部楼层
But declanr, what we need is a generic websheet which should not be session specfic ..... !!!!
回复 支持 反对

使用道具 举报

87

主题

397

帖子

595

积分

高级会员

Rank: 4

积分
595
QQ
发表于 2014-3-16 14:33:42 | 显示全部楼层
pmathur wrote:But declanr, what we need is a generic websheet which should not be session specfic ..... !!!!

If hyperlinks are used well you can generally make a user unaware that they are moving between sheets.

But based on your request, possibly the best option would be to create the sheet with the full 12 quarters worth of columns in an active form and then use conditional formatting to make the column invisible (e.g. font and background the same colour) dependent on what is selected in your title element.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2021-11-30 16:32 , Processed in 0.050772 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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