Just FYI, this also supports depth of > 1 too, so you can enter

\Othermeasures\Japanese\J1

\Othermeasures\Japanese\J2

\Othermeasures\Mine

for three different measures, assuming your end user tool supports it, this will give you a tree...

Srihari, generally, you don't want to post your email address out in the forums, great way to be found by a spambot 🙂 use the 'Send Private Message' option found...

Sorry, missed that bit 🙂 (actually, i missed all comments o the second page!, my comments below basically echo those from others)

Is there any option to offer a...

You can't use Express with Advanced Services?? (e.g. here).

Somewhat of a nebulous question.... Are you using a tool *other* than SSRS now? If so, what tool and what issues are you seeing?

Hey Brandie, when you say that BIDS won't let you, does it return any sort of error message or warning with this?

Why not use the MeasureGroupMeasures() function? Official doc here

Using your example....

select [m3].[attribute1].members on rows,

MeasureGroupMeasures('m1') on columns

from [cube]

You can definitely delete data out of an ssas db, or more accurately, a cube in that db. This is what the processing option of clear data is for....

From the error (look bottom left hand side), looks like the Analysis Services Service either isn't installed or not started. Go to Start, Admin Tools, Services and look at...

Glad that it's sorted. It is strange that the sizes wouldn't be an exact match. Maybe SSAS defaults large fields to 1024 :unsure:

BI Documenter is one of the better ones. There's a free edition but it won't come close to what you want/need.

http://pragmaticworks.com/products/business-intelligence/bidocumenter/default.aspx

OLAPScribe is free but doesn't look to have been...

Could be too simple an approach (ie your problem could be more than I read into it) but why not simply aggregate? A group by of the key fields...

damn those bosses huh 😉

Just FYI on the Dim Usage tab, this is where you can implement role playing dims too, so if you have this date dimension already in...

Seems very strange that it would work for 11 out of 12 months..... There's nothing else at play here? bad labels? keys? specified ranges? seems strange...

Hey Brandie - sounds like you've got it now, but just in case - SSAS can create that unknown (catchall member) for you auto-magically, so you *won't* need to know...