dbTalk Databases Forums  

Multi year analysis using Analysis Manager

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


Discuss Multi year analysis using Analysis Manager in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve Wilbert
 
Posts: n/a

Default Multi year analysis using Analysis Manager - 07-13-2004 , 08:46 AM






Hey,

I am trying to create dimensions using data that contains multiple
years so we can analyze current period to past periods. Any
suggestions on how I can accomplish this.

Thanks

Reply With Quote
  #2  
Old   
Darren Drysdale
 
Posts: n/a

Default Re: Multi year analysis using Analysis Manager - 07-13-2004 , 10:17 AM






not sure if i'm missing something here.. a fairly standard date dimension
with a level for year included (as well as month, quarter etc) - the wizard
helps you out with this

HTH

DD


"Steve Wilbert" <swilbert (AT) kyderby (DOT) com> wrote

Quote:
Hey,

I am trying to create dimensions using data that contains multiple
years so we can analyze current period to past periods. Any
suggestions on how I can accomplish this.

Thanks



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.