Sorry I guess my question wasn't clear.

I do know that SSIS can do merge statement via Execute SQL task, however, the format of my data is different mid ETL compare...

Thanks for the reply!!! somehow I never got an alert, so I didn't see the reply until now!

I am still working through the problem. So do you mean I...

probably 300GB SAS disk, so 600G for each RAID 10 array?

ODS and DW are only about 150GB each now.. so tons of room for growth...

Won't it be advisable if I...

bump?

Any idea?

Thanks a lot so far!!! it's getting closer!!!!

you gave some example on creating new dimension member like [jan+march] ...

I apologize, but I am very new to SSAS, and...

hmm.. sorry. but i am a little new to the SSAS / SSRS stack .... creating a custom member calculation sound good .. but i am not sure...

Sorry.. not sure I understand exactly what you said... but did you mean it's much easier to do the SSAS population with 400 facts as columns??

or did you...

hmm.. i thought about having a measurement dimensions.. but how would it impact creating measures in SSAS??

Wouldn't SSAS automatically create the measures based on my fact table's columns?

would...

That's my first reaction too.. i haven't seen any requirements where there are 400+ metrics at the same grain..

but I looked at their current reports in excel.. it's indeed the...

anyone has any idea for sql server 2005 then?

please help.. thanks