Dim table being recoginized as Fact Tables
This is a discussion on Dim table being recoginized as Fact Tables within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> I'm using AS 2005, I'm trying to create a cube using the wizard and AS 2005 is detecting my ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-28-2008, 04:40 AM
| ||||
| ||||
 Dim 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.      |
|
03-28-2008, 04:40 AM
| |||
| |||
| Re: Dim table being recoginized as Fact Tables 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 "BillGatesFan" <klj_mcsd@hotmail.com> skrev i en meddelelse news:c376b4b1-0a30-4569-aee3-d75407203b32@a1g2000hsb.googlegroups.com... > 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. |
|
04-08-2008, 02:38 PM
| ||||
| ||||
| Re: Dim table being recoginized as Fact Tables You need to set up realtionships correctly for this to work properly. Many on the fact side, one on the dim side... MC "BillGatesFan" <klj_mcsd@hotmail.com> wrote in message news:c376b4b1-0a30-4569-aee3-d75407203b32@a1g2000hsb.googlegroups.com... > 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. |
Linear Mode
