I have a case in which a rollup MDX formula for the all level of a
dimension doesn't work if I put a ' inside the comment.
It's very easy to reproduce even with a simple constant in the
formula.
Version that doesn't work:

*********** START ****************

-- this ' is a bug
42

*********** END ***************

Version that work:

*********** START ****************

-- this is not a bug
42

*********** END ***************

I spent almost an hour to find the problem.
Is this a real bug or something else? Hope to be fixed in SP4?
Thanks.

Marco Russo

Hi Marco,

This is a known bug that has been reported and acknowledged in the past
- not sure if it's being fixed in SP4:


http://groups-beta.google.com/group/...rver.olap/msg/
e62a3a6b583b10a0

The following fails:


select
filter (


[Customers].[State Province].members,
measures.[unit sales] > 300 -- filter's context
) on 0
from sales

The following succeeds:


select
filter (


[Customers].[State Province].members,
measures.[unit sales] > 300 -- filter''s context
) on 0
from sales

I wouldn't think string parsing should be in effect inside a comment!
...

http://groups-beta.google.com/group/...rver.olap/msg/
d15e2d54b8333518

Newsgroups: microsoft.public.sqlserver.olap
From: "Sean Boon [MS]" <seanb... (AT) online (DOT) microsoft.com> - Find messages
by this author
Date: Tue, 29 Apr 2003 11:48:20 -0700
Local: Tues, Apr 29 2003 11:48 am
Subject: Re: Comments in MDX / - Sample Application
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

This is a known bug in the product at this time and it will be
re-evaluated.
Embedded quotes will also cause a failure as well.


Sean


--
Sean Boon
SQL BI Product Unit


**This posting is provided AS IS, with no warranties, and confers no
rights.**
"dxd" <member8... (AT) dbforums (DOT) com> wrote





- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Deepak Puri wrote:
Thanks Deepak.
I previously searched across the newsgroup but I supposed it was a
custom rollup related bug and I haven't extended the search to the
general problem of MDX comments.
Marco Russo
http://sqljunkies.com/WebLog/sqlbi

This wasn't addressed in SP4. It is fixed in Yukon.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================