Further to last post, it's really quite strange... I can add smilies etc (ie buttons on the toolbars are working), I can change the check status on the "email me...

Hi Andy,

That works perfectly now. 

My only concern now is that it's taken me ~ 5 minutes to get to writing this reply, as when the 'posting' page loads, it's...

Ahhh, *magic*, my favourite type of coding...

I really like the new site tho!

Further to my last post, the page open in abroswer *must be* a SSC page, a blank page or page from another site won't do (ie the URL gets corrupted/cut...

Thanks Andy.  Here's a good one for you...

I received the html notification that you had posted a msg on this thread.  I clicked on the link as posted in the...

re: Scripting tools, if you have the SQL Server Resource Kit there is a MetaDataScripter that is an (VB6 dll) add-in to the AS (MMC) console and generates VBScript file/s...

You're using a set of only one member for the first parameter of the Median function, so the median is the value you have passed in.

HTH,

Steve.

Are you trying to view the data through Analysis manager or a separate client? If a separate client, you may need to add a role/s to the database/cubes to...

Surya,

I'm now thinking maybe your specification of the set was incorrect, as the three transactions should all have been present int eh cube (based on using the standard foodmart cube).

Maybe...

Hey Surya,

Regarding your first question, Median(<set>[,<numeric>]) definitely works. I must have killed off some of my transactions, because I don't have the CA customer that you are using, but...

Hey Nico,

I was going to say 'it just flows thru' but a quick test (and your qn) proves it doesn't. Sorry, I don't know how to make it come...

Crucker1 is right. If you got your SP on CD, look for the msolap folder, it will contain the Analysis Services service pack (for the server, and the sub-folder...

You may want to review and try the things suggested here... http://www.dbforums.com/t880646.html

Also, make sure you have loaded (maybe even reload) SP3 (this was a known issue pre-SP1 http://support.microsoft.com/?id=307365

HTH,

Steve.

Hi Nico,

Using the Foodmart::Sales cube, inserting the following MDX as the forecolour expression for Profit (calculated member in Measures) will result in red or green text colour.

IIF([Measures].[Profit] < 5000, 255,...

In the Cube Drillthrough Options screen, on the Columns tab, you should see all of the columns contained in all of the tables used in your model. Assuming you...