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

Memory Questions

I am running SSAS 2005 SP1 on a machine with Windows 2003 Server R2 and 2 GB of memory.I have approximately 30 analysis databases defined on this machine.

When I process one of my analysis databases, MSMDSRV.EXE gradually takes over 1 GB of virtual memory and does not release it once processing is completed.Once processing completes, MSMDSRV.EXE continues to take up 5-15% of CPU to process something.This goes on for hours.

Let’s say I go into BIDS on this machine and try to open an analysis database by entering the server name then attempting to select a database from the database drop down.It takes about 10 minutes for the list of databases to appear on the screen, and you can watch MSMDSRV.EXE take up more and more virtual memory until it takes over 1 GB of virtual memory.

- Why is SSAS taking up so much virtual memory to perform these operations? Is it metadata overload?

- Is there any way to get MSMDSRV.EXE to release the virtual memory it has taken?

- Once database processing has been completed, what is MSMDSRV.EXE doing that would take 5-15% of CPU?

- Is there a recommended solution to improve memory handling and performance in this situation?

Thanks in advance for your help.

Wendell G.

Is this a recent event or a continual event?

Is the server recognizing the 2gig's of RAM and the full capacity of the processor(s)?

How old is the server?

Adamus

|||

This has been a continual event and has appeared to get worse as more analysis services databases are added to the server.

The server is recognizing the 2 GB ram and is less than one year old.

Wendell G.

|||

Not knowing your situation, the immiteate suggestion is to increase memory of your machine.

2 Gb looks litte on the lower side.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Memory Questions

I am running SSAS 2005 SP1 on a machine with Windows 2003 Server R2 and 2 GB of memory.I have approximately 30 analysis databases defined on this machine.

When I process one of my analysis databases, MSMDSRV.EXE gradually takes over 1 GB of virtual memory and does not release it once processing is completed.Once processing completes, MSMDSRV.EXE continues to take up 5-15% of CPU to process something.This goes on for hours.

Let’s say I go into BIDS on this machine and try to open an analysis database by entering the server name then attempting to select a database from the database drop down.It takes about 10 minutes for the list of databases to appear on the screen, and you can watch MSMDSRV.EXE take up more and more virtual memory until it takes over 1 GB of virtual memory.

- Why is SSAS taking up so much virtual memory to perform these operations? Is it metadata overload?

- Is there any way to get MSMDSRV.EXE to release the virtual memory it has taken?

- Once database processing has been completed, what is MSMDSRV.EXE doing that would take 5-15% of CPU?

- Is there a recommended solution to improve memory handling and performance in this situation?

Thanks in advance for your help.

Wendell G.

Is this a recent event or a continual event?

Is the server recognizing the 2gig's of RAM and the full capacity of the processor(s)?

How old is the server?

Adamus

|||

This has been a continual event and has appeared to get worse as more analysis services databases are added to the server.

The server is recognizing the 2 GB ram and is less than one year old.

Wendell G.

|||

Not knowing your situation, the immiteate suggestion is to increase memory of your machine.

2 Gb looks litte on the lower side.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I have exactly the same situation but I have 12G RAM
each process of the cube increases the memory of the msmdsrv.exe by 2G
eventualy after 4 / 5 processings it fails with a page file % nearly full and the users cannot access. CPU useage by is 13% constant build of sql is 3054 on test server and 3152 on live server both servers have same issue.

Was there an answer to the above appart from more RAM i.e. should the memory be released?

Firts process of cube useage = 951M ,
Second process of cube usage starts at 951M and completes at 2,951M
Third process starts at 2,951 and increases etc and so on till memory all used
Thanks