Re: table structure for olap
- From: "Michael Vardinghus" <michaelvardinghus@xxxxxxxxxxx>
- Date: Mon, 23 May 2005 22:51:33 +0200
What do you mean by flat ?
You can either use star schema (every dimension links to the fact) or
snowflaking (a table for each level and these referes to eachothr in the
dimension builder)
And I think there a lots of arguments for each one - I prefer snowlaking
though.
Which one you would state as flat I' not sure....
>From working with AS I've learned that sometimes you could use "dimension
helper" tables to make a hierachy of parents with the same children - and to
improve performance.
OLAP performs best with hierachies - not so good with large flat dimensions.
"Eleazar" <enl23@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uPmfGw6XFHA.2884@xxxxxxxxxxxxxxxxxxxxxxx
> yes
> "dk" <dk@xxxxxxxxxxxxxxxxxxxxxxxxx> escribió en el mensaje
> news:22C490EE-6912-4CC9-892E-2D1F0A3B9929@xxxxxxxxxxxxxxxx
> > does olap always need or work best with a flat table stucture?
> >
> > tia,
> > dk
>
>
.
- References:
- table structure for olap
- From: dk
- Re: table structure for olap
- From: Eleazar
- table structure for olap
- Prev by Date: Re: Calculated members security
- Next by Date: Urgent! please help - Disabling dimension levels
- Previous by thread: Re: table structure for olap
- Next by thread: Best practices to partition a cube by month
- Index(es):
Relevant Pages
|
