Does anyone know if Acclerator for BI has the capability to model
multivalued dimensions as explained by Ralph Kimball in
http://www.intelligententerprise.com...ouse1_2.shtml? For
Example, We can have up to 4 sales reps that can be assigned per sales order
line item. The fact table grain of our orders cube is the sales order line
item. Instead of creating surrogate keys in the fact table for Sales
Rep1..Sales Rep4 I have extended the application and created views as Ralph
explains in his article. I just thought I would ask to see if there is a
better way of handling this situation.

Thanks for your help.

Best Regards,
Jim Reisz

Hi Jim,
I had the same situation in a project with BI Accelerator. My advice: you
should forget to solve this problem with BI Accelerator.
Beyond of this, you could solve this using Analysis Services: Create
Another Cube (fact table in details)- 'Detail' Cube after this create your
Cube - 'Ordinary' Cube and you should use the Calculated Cells that do a
Lookupcube MDX function using the 'Detail' Cube.
If necessary i may send to you a example.




"Jim Reisz" <jreisz (AT) msn (DOT) com> wrote