dbTalk Databases Forums  

How to provide for users to enter values for future periods (blank cells)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to provide for users to enter values for future periods (blank cells) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simon Lenn
 
Posts: n/a

Default How to provide for users to enter values for future periods (blank cells) - 08-27-2004 , 08:21 AM






I have a problem I want a write enabled cube for future periods say
period 012.2004, 001.2005,etc I want the users should be able to enter
values for amount measure for period 001.2005.

Since, I do not have any values for 001.2005 for Amount measure
obviously analysis services is not displaying it since this cell is
not populated.

How do I make Analysis Services to display the cells in future time
period for which no data exists to display as 0 so users can populate
values into them.

Without analysis Services displaying these values as zero in the
report I cannot have the writeback Excel Addin to let me write into
these cells.

Thanks
SImon

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.