What security context is the conneciton being called under? ie, being a web app, it's likely that, unless you're impersonating on the thread, that the context is IUSR_xxx or...

Not sure what he would use David. In many cases, NULL is appropriate, the usual example is how US/AU/MX use States yet other countries don't. WHat would one...

Hi Idris,

Using your example you can achieve what you want using either of David's or my approach.

The primary difference between the approaches David and I outlined are:

Davids:

- You need to...

just to clarify - i made the show/visiblity setting on every level for which i knew there could be 'dupes' - so in our case, it was L1 to L6.

I did something like this recently. What i ended up doing was 'pushing' the leaf node values all the way down. So say it's at level3 currently, I...

*Other* than the built in SSAS backup mechanism?? 😉 You don't need MSSQL to backup an SSAS cube, in 08 (and 05 and to a lesser extent 2k)...

you're using the wrong api.

This error is thrown by ADO --> System.Data.SqlClient.SqlException (ie SqlClient lib that you use to query SQL). You *could* use this library...

I'm with Jack on this one. The only 2 alternatives (ie hacks) i can think that you could try would be:

- to include some level of navigation *within* each...

You're using a named set rather than a tuple. If you use a calc member you created, it should work. Note I've used a SUM assuming that summing...

Not sure there's a rule of thumb, particularly not based on sp_spaceused for the fact. The areas where you'll have storage commitments are the dimensions (these can be affected...

Just out of interest, this solution will work great if you're in SQL, but seeing as you've posted to the AS forum, the assumption is you'll be using MDX and...

you need to create a calculated member that is the sum of all of the 'other' (ie not top 10) records. Prob need to use something like EXCLUDE (or...

you might be able to make use of the LastChild MDX function to find the last member in the parent, so for e.g.[Time].CUrrentMember.Parent.LastChild should get you the last child in...

What version of Excel are you using? This would appear to be caused by the multiple hierarchies in your time dimension. In AS2000 you used to have to...

am pretty sure that the OLAP Add In for Excel 2003 had some what-if capability. not sure if this mad eit across to office 2007, you'd have to check...