Funnily enough I can't get it to fail for me now.  The sorting/ordering of the members isn't right but the top n (5 in my case) seems to be correct.

Tested...

Whilst waiting on the new excel stuff from MSft, you could try using the current accellerator/add-in -> http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

The download button should be at the top right.

We have clients using both on the same machine, some who are reaching the limits and others who are going along nicely.  As an indication of one reaching the limits,...

This is two siblings with either the same name or key.  The uniqueness on your levels and on the dimension itself needs to be modified if you want to allow...

In analysis manager, right click on the server and select properties, you should see the data and temp directory settings there.  Defaults are usually under the program files\microsoft analysis services\data...

if you're considering doing that then why not create the two roles and create a virtual cube from the physical, and apply role1 to cube 1 and role 2 to...

To clarify, is this only one user who needs to be looking at all stores but only two vendors, but when focusing on vendors he/she can see them all but...

For this case you need to create two different roles, one restricted to the two particular stores but no restriction on any other dimensions; the other restricted to the two...

You should try to get the newer version (I think called Aggregation Utility) which comes with SSABI (sql server accelerator for BI), avail on the downloads site (msdn).

Alternatively, have you...

If the machines have the /Net framework on them, you could try the DSO-XML conversion utility instead.  This has both GUI and cmdline apps.

A simple way to do this could be to add a sorting column to your query that populates the combo, and then return the values for the combo in the...

I would create a view but you could just use the same code within the field source definition in the cube editor.

Adding a view with the following should get you...

I would normally crossjoin the second members inside or outside of the time mebrs that you have (say you wanted sales person, you could see each salesperson and the children...

Is your underlying datatype (ie the datatype within the DB) currency for the Sales measure?  What datatype have you selected for the measure itself?  Even though your underlying data type...

re: the conxn string settings for logging db, have you checked both the remote and local connection string settings in the registry?