Fact table design question

Measures with aggregate fuction of Count or Distinct Count are possible.

For example, Computer ID and Network ID can be data source of measures.

Here, Distinct Count measure needs numeric data source. For this, surrogate
key according to each ID is useful.

Ohjoo

"Truc H." wrote in message
news:5661A061-356B-40F6-BA70-8F0CC2AED8C2@microsoft.com...
> Hi all,
> I have the following source file with 3 fields
> (ComputerId, ClientDivision, NetworkCard)
> C111 SDD RAS 1
> C111 SDD RAS 2
> C222 ORDD WAN 1
> C222 ORDD WAN 2
> C222 ORDD RAS 1
> C333 SDD WAN 1
> ect...
>
> Cardinality :
> -computer id vs Client division (1:1)
> -computer id vs Netword card (1:n)
>
> Potential queries:
> - number of computers by Client Division ?
> - number of computers by type of Network card ?
> - number of Network card by Client division ?
> - ect¡¦
>
> Questions:
> Assuming that Computer id, Client division, Network card can be
> dimensions,
> What kind of fact table/measures need to be created ?
> Is there a design pattern for this type of source data ?
> Thanks for your advice.

Thanks for the good advice.

"Ohjoo Kwon" wrote:

> Measures with aggregate fuction of Count or Distinct Count are possible.
>
> For example, Computer ID and Network ID can be data source of measures.
>
> Here, Distinct Count measure needs numeric data source. For this, surrogate
> key according to each ID is useful.
>
> Ohjoo
>
> "Truc H." wrote in message
> news:5661A061-356B-40F6-BA70-8F0CC2AED8C2@microsoft.com...
> > Hi all,
> > I have the following source file with 3 fields
> > (ComputerId, ClientDivision, NetworkCard)
> > C111 SDD RAS 1
> > C111 SDD RAS 2
> > C222 ORDD WAN 1
> > C222 ORDD WAN 2
> > C222 ORDD RAS 1
> > C333 SDD WAN 1
> > ect...
> >
> > Cardinality :
> > -computer id vs Client division (1:1)
> > -computer id vs Netword card (1:n)
> >
> > Potential queries:
> > - number of computers by Client Division ?
> > - number of computers by type of Network card ?
> > - number of Network card by Client division ?
> > - ect¡¦
> >
> > Questions:
> > Assuming that Computer id, Client division, Network card can be
> > dimensions,
> > What kind of fact table/measures need to be created ?
> > Is there a design pattern for this type of source data ?
> > Thanks for your advice.
>
>
>