dbTalk Databases Forums  

Project reporting

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


Discuss Project reporting in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Vardinghus
 
Posts: n/a

Default Project reporting - 05-16-2005 , 02:49 AM






I have a project with an odd structure related to time dimensions.

I'm aware that you can have different time dimensions - but in this case I
have lots of projects which can have their own fiscal years....I can have up
till
several thousand projects with different fiscal years.

How would I go about putting this into AS ?

I would like this:

Realized till date (accross years)
Realized till date (current fiscal year on the project)

Project level A
Project level B

And this:

Period 1, Period 2, Period 3, Period 4

Project level A
Project level B

Perhaps I could just make a new dimension with integer numbers for each
calculation period - as stated above . 1, 2, 3 - so it wont' display years.
As member prop I could place the start and stop of the current period.

Any ideas ?

/Michael V.




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.