Hi,

I'm new to OLAP and SQL Server Analysis Services 2005, and I'm not
sure how to do this: I have a fact table that holds one row per
security per day including measures like profit/loss, etc. Back in
the relational world, each security is associated with anywhere from 1
to 153 factors (one to many relationship), and these factors each have
a value for each day which I must somehow add to my cube. Here are
some of the ideas we've come up with, but they all seem bad:

1. Create 153 columns in the fact table, one for each factor's value.

2. For each day, instead of one row per security, create a row for
each factor of each security, with all the other columns being
redundant, and take the average of the other values.

3. Keep the factor values in another fact table. I have no idea how
to query the security and factors together, but the end result would
need to be the security's measures and all the factors as columns,
filtering on date for both the security data and associated factor
values.

Is there a better way to do this?

thanks for any help,
Jim