Hey Donna, glad to know it still works and is helping folks out!

Steve

Hi Ravi,

Last sentence of error mesage tells you the problem - you're out of disk space.

Sounds like you should probably make a call to Microsoft Support...

I'd be trying to use an expression, along the lines of if(total(col) <> 0, <use orig vals, maybe replacing nulls with zeros>, "N/A") the issue will be whether...

That sounds right, yes. If there isn't anything to uniquely identify the rows (different invoice #, transaction id, time of day etc) then for all intents and purposes, they're...

You could google to be sure but I'm reasonably sure that the engine does exactly that - aggregates records that would be dupes. Without another key value to differentiate...

Assuming the tabular is the named instance? Was just wondering if you were hitting issues with the parameter value for the name. Just for kicks, try hard-coding it? ...

Is the SSAS the base instance or a named instance?

Did you look up the syntax for FOR XML - it's right there - option to change the root name. http://msdn.microsoft.com/en-us/library/ms190922(v=sql.90).aspx

Assuming when saying 'seeing' you mean via a tool such as Excel. Excel generates MDX to query the cube. You can also use MDX statements within the cube...

Hi Giles,

I misinterpreted your meaning of 'purchase history for all contacts who have purchased a specific product' - i thought you meant show me who had purchased this product.

Examples of...

So, you have a cube right? Assuming you do, then using Excel (really just to save you the time of writing the MDX yourself), can you get the result...

What do you see happening when you run a trace on the ssas machine?

Could be. What's your estimated row count? Are you using partitions?

Did you install the 32 or 64-bit SSAS server in tab mode on your machine?