Bug in parsing MDX rollup formula

[Marco Russo]

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

[Deepak Puri]

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/microsoft.public.sqlserver.olap/msg/
e62a3a6b583b10a0
>>
George Spofford Feb 22 2002, 5:41 am show options

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/microsoft.public.sqlserver.olap/msg/
d15e2d54b8333518
>>
Sean Boon [MS] Apr 29 2003, 11:50 am show options

Newsgroups: microsoft.public.sqlserver.olap
From: "Sean Boon [MS]" <seanb...@online.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...@dbforums.com> wrote in message
news:2819556.1...@dbforums.com...

> The following is working

> =======================
> Select
> filter(
> State.allmembers, --abc

> measures.[Sales Units]>1)
> //instr(1,[State].currentmember.name,"USA") > 0)
> on 0 from sales

> =========================
> But the following is not working

> ==========================
> Select
> filter(
> State.allmembers, --abcsddf)

> measures.[Sales Units]>1)
> //instr(1,[State].currentmember.name,"USA") > 0)
> on 0 from sales

> ===================================
> What is the difference? because the 2nd comment contains a ")", which
is
> treated to close the the filter function, I guess.
> I believe this is a bug.

> Originally posted by Joerg
> > SQL 2000 Enterprise, SP3
..
>>

- Deepak

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

[marco...@loader.it]

Deepak Puri wrote:
> 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:
>
>

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

[Mosha Pasumansky [MS]]

> > - not sure if it's being fixed in SP4:

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.
==================================================