Merge Data

Hi,

I have an analysis server which get his data from an AIX. We use reporting server to get some reports. Unfortenately the data on the AIX is incorrect. I created a table called "corrections" . The corrections should be merged with the data

Solution 1 : modify the data source view in SSAS and integrate the corrections

Solution 2: make a stored procedure that gets the data from SSAS and merges it with the correction. Call the SP from the report.

Which one is better ?

And how do you implement solution 1 ?

And where can I find books over creating MDX queries ?

With regards,

Constantijn Enders

Hello.

Solution1 will not be good enough. I recommend you to build a data warehouse and make your corrections in the ETL-process. Thats is when you load data from your source system to a data warehouse. About data warehouse pros and cons I recommend you to have a look here(www.kimballgroup.com)

About MDX books I can recommend to start with "Analysis Services 2005, Step by Step" that is a good start book to learn Analysis Services 2005 and some MDX.

A respected MDX expert and writer of articles in this area you can find here: http://www.databasejournal.com/features/article.php/3593466

Look for William E. Pearson

HTH

Thomas Ivarsson

|||

Thank you for the excellent information. It will surely help me

Constantijn