dbTalk Databases Forums  

can i create 2 dimensions both based on the same table?

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


Discuss can i create 2 dimensions both based on the same table? in the microsoft.public.sqlserver.olap forum.



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

Default can i create 2 dimensions both based on the same table? - 09-29-2005 , 11:28 AM






in my fact table, there are 2 columns - disaster_type_A, and disaster_type_B
(The reason why i have 2 columns is because a record might be in one or both
of the types).

i create a dimension table called dim_disaster, and want to link to
disaster_type_A and disaster_type_B, of course as you know, this wouldn't
work. so i keep the link between dim_disaster and disaster_type_A, then
create a nother dimesion(dim_disaster_B) based on the same data in
dim_disaster and link to disaster_type_B. But the problem is when i try to
add the new dimenstion in the fact's editor, since the 2 dimesions using the
same table, it only displays one dimension... anybody can give me some
suggestions or solutions... thanks.

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

Default Re: can i create 2 dimensions both based on the same table? - 09-29-2005 , 06:52 PM






Create a view on the dim table in SQL Server (or what ever relational
source you are using) and use the view as the source for the second
dimension.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

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.