Hi,
I know that dimensions are loaded in memory all the time when analysis
services start .
Now are the private dimensions also loaded in memory?

2. We can use shared dimensions in multiple cubes . In that case are copies
of shared dimensions created for each cube ?

3. We can disable levels of shared dimensions selectively , in that cases
are dimensions replicated in memory ?
Regards,
Akshay

address space -- private and shared -- it makes no difference.

However, if you are using dimension security, then additional copies can be
loaded into what is called "replica dimensions". See the discussion of
replica dimensions in:
http://www.microsoft.com/technet/pro...e/AnSvcsPG.asp

Disabling a level has no impact. All dimension members in all databases are
loaded when the msmdsrv service starts up; and are updated when any
dimension is processed.

Hope this helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Akshay Kumar" <akshay349 (AT) hotmail (DOT) com> wrote