Hello jayharper -

It's true that Private and Virtual dimensions cannot be optimized. Note also that Virtual dimensions are always Shared.

However, if your dimensions are shared and not virtual then...

I'm with Michael on this one. It might be possible to work around XP Home limitations (and it should work as a client) but, if you want to administer...

Anbu -

A couple of potential solutions come to mind:

First, are these dimensions really alternate hierarchies? IE: are they essentially the same with some lower levels of detail not contained...

Have you looked at the 'Optimize Schema' function (Tools menu, Cube Editor)?

Though this function assumes some design considerations in the supporting schema, it can have a huge impact on processing...

Hi -

The OLAP Administrators group is created automatically during installation of Analyis Services and the current user (installing user) is added to this group.

In order to launch Analysis Manager your...

Hi Sid -

The power of DTS is its flexibility. So, there are several ways to solve this problem. In it's simpliest form, you could create parallel data transformations....

Excel and the Office Web Components intentionally ignore the Hide Member If property, because they don’t behave properly if placeholder members are hidden.

You can see what would happen by using...

Good morning -

The value of the measure is the count of Table2 because, when processing a cube, the underlying (dynamically created) SQL query is an inner join query. Therefore,...

A couple of quick troublshoting questions: are you able to see the AS server but not the cubes? (If you can see the server but not the cubes I would...

Hi Henmi -

I don't want to turn this into an ad for my company by check out http://www.aspirity.com for education and implementation resources for Analysis Services. Reed...

Just a quick follow-up note: right-click on the server object in Analysis Manager to access server Properties. Among other things, you will be able to define the data and...

It shouldn't matter from which machine the security is defined. Presuming that the everyone group is a domain group within the same domain as the Analysis Services server you...

DTS has an Analysis Services object which allows you to process dimension and cube objects. Create a package (or series of packages depending upon how sophisticated you need the...

Hello Paul -

You should be able to use the .LastChild and LastChild.PrevMember operators to select the current year and previous year member. This would allow the query to produce...

Hello Fabs -

I think you have created the best solution possible given your source data structure. It seems your only other option would be to pre-calculate Unita in the...