create warehouse

[Database Administrator]

Hello,
I have a question/scenario. I'm creating a cube in Analysis Services
(which works fine) but my 3rd party control is not showing my data correctly
(like how BIDS shows it on the browse tab within my cube), So this leads to
my question.

I have 1 table that I'm pulling all of my data from, is it possible to
create dimension tables and a fact table from my one table? If so how would
I go about do that? I need something like the AdventureWorks DW that has dim
and fact tables.

[Database Administrator]

It's possible to use one table as dimension table and fact table at the same
time.
Otherwise it's effective to define views for dimension table and fact table
from the table.

Ohjoo


"Mike" wrote in message
news:uO33rdCGJHA.4936@TK2MSFTNGP03.phx.gbl...
> Hello,
> I have a question/scenario. I'm creating a cube in Analysis Services
> (which works fine) but my 3rd party control is not showing my data
> correctly (like how BIDS shows it on the browse tab within my cube), So
> this leads to my question.
>
> I have 1 table that I'm pulling all of my data from, is it possible to
> create dimension tables and a fact table from my one table? If so how
> would I go about do that? I need something like the AdventureWorks DW that
> has dim and fact tables.
>
>
>