 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Data Warehousing / April 2008Dim table being recoginized as Fact Tables
I'm using AS 2005, I'm trying to create a cube using the wizard and AS 2005 is detecting my Dimension tables as being fact tables and when I try to switch them to Dim table, it will not let me go further. Does anyone know how to get through this? These are reference tables and they do not link directly to a fact table. think this is a key problem. u need to have keys in deimsin tables in datasource view for AS to underestand them as diension tables > I'm using AS 2005, I'm trying to create a cube using the wizard and AS > 2005 is detecting my Dimension tables as being fact tables and when I > try to switch them to Dim table, it will not let me go further. Does > anyone know how to get through this? These are reference tables and > they do not link directly to a fact table. You need to set up realtionships correctly for this to work properly. Many on the fact side, one on the dim side... MC > I'm using AS 2005, I'm trying to create a cube using the wizard and AS > 2005 is detecting my Dimension tables as being fact tables and when I > try to switch them to Dim table, it will not let me go further. Does > anyone know how to get through this? These are reference tables and > they do not link directly to a fact table. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.