Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Dim table being recoginized as Fact Tables

  
   Database Help (Home) -> Data Warehouse RSS
Next:  Historical Balance ??  
Author Message
BillGatesFan

External


Since: Mar 25, 2008
Posts: 3



(Msg. 1) Posted: Tue Mar 25, 2008 1:03 pm
Post subject: Dim table being recoginized as Fact Tables
Archived from groups: microsoft>public>sqlserver>datawarehouse, others (more info?)
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.

 >> Stay informed about: Dim table being recoginized as Fact Tables 
Back to top
Login to vote
michael vardinghus

External


Since: Mar 26, 2008
Posts: 11



(Msg. 2) Posted: Wed Mar 26, 2008 12:36 am
Post subject: Re: Dim table being recoginized as Fact Tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" skrev i en meddelelse

> 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.

 >> Stay informed about: Dim table being recoginized as Fact Tables 
Back to top
Login to vote
MC

External


Since: Jan 24, 2007
Posts: 38



(Msg. 3) Posted: Tue Apr 08, 2008 7:10 am
Post subject: Re: Dim table being recoginized as Fact Tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You need to set up realtionships correctly for this to work properly. Many
on the fact side, one on the dim side...


MC


"BillGatesFan" wrote in message

> 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.
 >> Stay informed about: Dim table being recoginized as Fact Tables 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How many fact tables allowed per cube? - Can an OLAP cube contain more than one fact table?

Fact Table(s) Design Question - Please forgive the cross-posting, I wasn't sure the best place to put this question. I'm modeling a procurement process as part of a data warehouse project - and in this case what we're procuring is people (filling jobs). The basic process is that the..

Near Real time updating of fact table - -what is the best method that to implement the near real time updating of a fact table without affecting all those users who are reading from it? -fact table in question is only 1.8gb in size, 3.1 million rows, expect near real time updating of approx....

Slow Changing Fact Table / Snapshot - We have a small Contract tracking system that tracks 1 to many funding sources per 1 to many contractors per a given Contract. As the contract is making its way to completion - the funding sources can have many amendments. For example; a contract...

restore file/filegroup for partitioned tables - Hi. Our DB has Primary file group (data and log files are there) where all lookup are. has 2 big tables each on own partition (by date) with their indexes. so Primary has file xxx_data.mdf and xxx_log.ldf the 1 big table1 and its indexes are on..
   Database Help (Home) -> Data Warehouse All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]