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

Fact Table without Metrics

  
   Database Help (Home) -> OLAP RSS
Next:  Sql Express 2008 ODBC Connection  
Author Message
balajikkrishnan via SQLMo

External


Since: Mar 18, 2008
Posts: 22



(Msg. 1) Posted: Thu Dec 18, 2008 6:25 am
Post subject: Fact Table without Metrics
Archived from groups: microsoft>public>sqlserver>olap (more info?)
Hi All,

I have a dimension table "Company" and another dimesion "Contact". Each
company in the dimension table can have multiple Contacts.

DimCompany:
CompanyID
sName

DimContact:
ContactID
sContactName

FactX:
CompanyID
ContactID

Now when I browse the data by drag the CompanyID from the DimCompany table
and just drag the sContactName from the DimContact table. Each CompanyID all
the sContactName is getting repeated.

How to solve this issue.

Thanks

--
Message posted via http://www.sqlmonster.com

 >> Stay informed about: Fact Table without Metrics 
Back to top
Login to vote
balajikkrishnan via SQLMo

External


Since: Mar 18, 2008
Posts: 22



(Msg. 2) Posted: Mon Dec 22, 2008 1:28 pm
Post subject: Re: Fact Table without Metrics [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Can anyone reply to this post?

balajikkrishnan wrote:
>Hi All,
>
>I have a dimension table "Company" and another dimesion "Contact". Each
>company in the dimension table can have multiple Contacts.
>
>DimCompany:
>CompanyID
>sName
>
>DimContact:
>ContactID
>sContactName
>
>FactX:
>CompanyID
>ContactID
>
>Now when I browse the data by drag the CompanyID from the DimCompany table
>and just drag the sContactName from the DimContact table. Each CompanyID all
>the sContactName is getting repeated.
>
>How to solve this issue.
>
>Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-olap/200812/1

 >> Stay informed about: Fact Table without Metrics 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
fact table question - Hi All I have a complex situation here. My fact table is like this Answers _______ Record_ID EncounterID PersonID QuestionID Parent_ID 1 1500 50 10 NULL 2 1500 50 20 NULL 3 1500 ....

Fact table in one DB Dimension in another - This may sound like a strange question, but I have a server where fact tables are in one database and the dimension tables are in another database. All databases are on the same server. The question I have is, will Analysis Services build a cube from...

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

how to add a new MG on a fact table that is already used - A recommendation from MSFT is Do put each distinct count measure into a separate measure group (http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ olapdbpssas2005.mspx) However if in BIDS I want to make a seperate MG on the fact table ...

Fact table design question - I had a huge fact table with the following structure. fact1 (Fact1ID, D1, D2,... M1, M2, M3....) where PK is Fact1ID, D1, D2,... are dimension key and M1, M2, M3 are measures. Now I need add a new fact table fact2, which has many to one relationship..
   Database Help (Home) -> OLAP 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 ]