dbTalk Databases Forums  

changing dimension

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


Discuss changing dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jefrey Silang
 
Posts: n/a

Default changing dimension - 07-11-2003 , 06:00 AM







I am new to olap. just want to know if it's possible to have a dynamic
dimension?

here's the scenario:

i have a district & territory dimensions.

district territory year month

dist01 terr01 2003 01
dist01 terr02 2003 01
dist01 terr03 2003 01
dist02 terr04 2003 01
dist02 terr05 2003 01

dist01 terr01 2003 02
dist01 terr03 2003 02
dist01 terr05 2003 02
dist02 terr02 2003 02
dist02 terr04 2003 02

what actually happened was:
on year 2003 month 02, terr02 was trasnferred to dist02
on year 2003 month 02, terr05 was transferred to dist01

create such dimension and what are the complications, if there's any?
thank you very much.

Jefrey



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.