Help - Multi values dimensions ?

Hello all
we developped a software with a data warehouse in sql server, without using
analysis services, and following the star design.
we are working with data about transactions, with caracteristics modeled in
dimensions. in general each transaction has one single value for each
caracteristic, but for one, it may have more than one or no value.
some solution we thought about:
-we use comma separated IDs (string) in the dimension in the fact table, but
it would hurt indexing
-or store the IDs in a separate table, but each query will require a join
my question is what is the best way to implement this feature ?
thank you for your help
its a standard "n-n" relationship.
1 caracteristic, can have 0 to N transacions
1 transaction can have 0 to N caracteristic
So, you'll have 3 tables:
Caracteristics 1 - n CaractToTransac n - 1 Transactions
The CaractToTransac table contain only 2 columns:
CaracteristicID and TransactionID
(maybe you can add a column called "sequence" if the order of your
caracteristics is important for you)
Now you have multi caracteristics for each transaction.
"r_samir" <r_samir@.discussions.microsoft.com> a crit dans le message de
news:8E2216BF-50D7-4FF6-89A3-C1995D83E3B5@.microsoft.com...
> Hello all
> we developped a software with a data warehouse in sql server, without
using
> analysis services, and following the star design.
> we are working with data about transactions, with caracteristics modeled
in
> dimensions. in general each transaction has one single value for each
> caracteristic, but for one, it may have more than one or no value.
> some solution we thought about:
> -we use comma separated IDs (string) in the dimension in the fact table,
but
> it would hurt indexing
> -or store the IDs in a separate table, but each query will require a join
> my question is what is the best way to implement this feature ?
> thank you for your help

Help - Cube Processing

All,
I m at a loss to understand whats happened to the data warehouse I manage.
Everything was OK up until about 2 weeks ago then overnight the daily Cube
processing jumped from about 15 minutes to nearly 45 minutes/Partition.
I've Defraged and reindexed all the fact tables, that helped for about 2
days but no has no effect.
The server config is
4 x Xeon 2.8 Processors (multi threading applied, effectivly 8 Pros)
4GB of Memory (AWE Disabled)
2GB Sys Paging File
5 Drives all Raid 0+1I would suggest that you scan through your system using the tips and tricks
suggested in the following two white papers:
http://www.microsoft.com/technet/pr...n/ansvcspg.mspx
http://www.microsoft.com/technet/pr...n/anservog.mspx
Both contain lots of great recommendations on how to deal with increased
processing times.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Lees" <JasonLees@.discussions.microsoft.com> wrote in message
news:6EAFB483-D8D0-4770-B1B3-78766465757F@.microsoft.com...
> All,
> I m at a loss to understand whats happened to the data warehouse I manage.
> Everything was OK up until about 2 weeks ago then overnight the daily Cube
> processing jumped from about 15 minutes to nearly 45 minutes/Partition.
> I've Defraged and reindexed all the fact tables, that helped for about 2
> days but no has no effect.
> The server config is
> 4 x Xeon 2.8 Processors (multi threading applied, effectivly 8 Pros)
> 4GB of Memory (AWE Disabled)
> 2GB Sys Paging File
> 5 Drives all Raid 0+1
>
>

Help - Cube Processing

All,
I m at a loss to understand whats happened to the data warehouse I manage.
Everything was OK up until about 2 weeks ago then overnight the daily Cube
processing jumped from about 15 minutes to nearly 45 minutes/Partition.
I've Defraged and reindexed all the fact tables, that helped for about 2
days but no has no effect.
The server config is
4 x Xeon 2.8 Processors (multi threading applied, effectivly 8 Pros)
4GB of Memory (AWE Disabled)
2GB Sys Paging File
5 Drives all Raid 0+1
I would suggest that you scan through your system using the tips and tricks
suggested in the following two white papers:
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
http://www.microsoft.com/technet/pro.../anservog.mspx
Both contain lots of great recommendations on how to deal with increased
processing times.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Lees" <JasonLees@.discussions.microsoft.com> wrote in message
news:6EAFB483-D8D0-4770-B1B3-78766465757F@.microsoft.com...
> All,
> I m at a loss to understand whats happened to the data warehouse I manage.
> Everything was OK up until about 2 weeks ago then overnight the daily Cube
> processing jumped from about 15 minutes to nearly 45 minutes/Partition.
> I've Defraged and reindexed all the fact tables, that helped for about 2
> days but no has no effect.
> The server config is
> 4 x Xeon 2.8 Processors (multi threading applied, effectivly 8 Pros)
> 4GB of Memory (AWE Disabled)
> 2GB Sys Paging File
> 5 Drives all Raid 0+1
>
>