Analysis Services

Hi,
why AS isn't able to browse the data of a cube?
-->Error Messages:
"Unable to browse the cube Sales"
"Unable to locate the cube 'sales'"
Although the cube Sales is manually included in the programm!
A have already installes the SP3a. What is wrong here?
Will be greateful for any help and many thanks in advance!
Saw this error before, remove AS and reinstall it, see if it fixes the
problem.
Also, try to rebuild the cube
Eric
Stefan wrote:

> Hi,
> why AS isn't able to browse the data of a cube?
> -->Error Messages:
> "Unable to browse the cube Sales"
> "Unable to locate the cube 'sales'"
> Although the cube Sales is manually included in the programm!
> A have already installes the SP3a. What is wrong here?
> Will be greateful for any help and many thanks in advance!
>
Eric Li
SQL DBA
MCDBA
|||I am having the same problem as Stefan. I reinstalled AS and SP3a and continue to have this problem. Any ideas?
Thanks, Ken
"Eric.Li" wrote:

> Saw this error before, remove AS and reinstall it, see if it fixes the
> problem.
> Also, try to rebuild the cube
> Eric
> Stefan wrote:
>
> --
> Eric Li
> SQL DBA
> MCDBA
>

Analysis Server Memory Upgrade

Dear Anyone,

We recently upgraded our analysis server from a 4GB to 8GB. For a couple of weeks, we noticed that the server memory isnt going up to close to 8GB and only goes to around 4. We use the /3Gb and /PAE on our server.

Can anyone recommend some memory tweaks that we can use on the Analysis Services?

Thanks,

Joseph

Unfortunately in this case having more memory is not going to help.

32 bit version of Analysis Server will not use more than 3Gb of memory.

You should move to 64 bit hardware to be able to take advantage of more memory of your system.
In AS 2005 you should be able to install multiple instances and distribute your databases across instances.

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

|||

Just want to clarify that this 3GB limitation is on Analysis Services 2005? I thought the memory limitation was for Analysis Services 2005 got a lot bigger from that of the 2000 version. I'm I wrong in thinking this?

Furthermore, can anyone please share the maximum memory configuration we can give Analysis Services 2005 to maximize the available memory? I.e. Analysis 2005 is on a box with 8GB of memory.

|||

Memory limitations for AS2K5 are the same as AS2K -- they are based on the OS (see earlier post).

Therefore to use 8GB of memory you must be running on a 64-bit platform, as a native 64-bit application.

That being said however, what might be confusing you, is that memory usage in AS2K5 has gotten a while lot more efficient. We now have a dimension memory cache, replicas used for dimension security are smaller and more efficient, etc. Thus you can do more with what you have.

But our general advise is still the same -- running on 32-bit hardware, there is no reason to have more than 4GB on your server. See the AS Operations Guide for more guidelines like this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Hope that helps.

_-_-_ Dave

sql