It can be done, it's not pretty but here is one way of doing it.....

Steps I took:

1. copy the current Shared [Time] dimension, I named it [Time2]

2. For the sake of...

sp3/3a on both client and server?  Sounds a little like a MDAC problem.

Just further clarification on the last post.  After a little research, it looks like i can't send thru the base for the log function, and instead of it defaulting (as...

Hey Peter,

Using the formula from your first post, I get a result using the following on Foodmart:Sales.

WITH

 MEMBER [Measures].[bob] AS 'EXP(AVERAGE(LOG([Measures].[Unit Sales])))'

SELECT

 {[Measures].[bob]} on 0,

 {[Gender].members} on 1

FROM Sales

Note that it's...

When you say you have SQL rights, are you refering only to login permissions etc in MSSQL?  FOr AnalysisServices you'll need to tbe in the OLAP Admin group.

Are any of the users your trying to connect as (other than the olap admin) in database roles that have cube access?

You'll need a client tool, like Excel, proclarity etc.  This page really only exposes the AS server to the web and allows client tools to make calls via http.

Glad you got it sorted.

The difference in returned results of excel vs sample app is that when the excel pivot control sees only column values, and the measure is in...

Got to love the Excel generated MDX....

The drilldownleveltop isn't the problem, it could be seen as basically the same function as your TopCount (from BOL heres the drilldownleveltop description -> DrilldownLevelTop(«Set»,...

Pete,

When you set the descending order, did you change the 'using Field' value to be that of the measure (calculated member)?  Can you get this top 10 (with ordering) work with...

What client tool (ie olap browser) are you using? If you are refering to a fact table that contains products sold on particular days, then the measure you are viewing...

The first thing I would do is capture the MDX Excel is sending to the server so you can determine why it's going wrong, additionally you could always send it...

hey Jamie,

So what exactly isnt working for you?  Is this the fact query for your cube, because it looks ok to me

If you can also post more detail on what you're trying to achieve that might help also.  If you're trying to make a calculated member, then you might be able...

If the OLAPObjects (in the msmdrep access database) table is empty and your Analysis Manager shows that you have objects (ie catalogs, cubes etc) then I would be guessing that your...