Bug in parsing MDX rollup formula - microsoft.public.sqlserver.olap

Message from discussion Bug in parsing MDX rollup formula

Deepak Puri

View profile

More options Jan 8 2005, 11:33 pm

Newsgroups: microsoft.public.sqlserver.olap

From: Deepak Puri <deepak_p...@progressive.com>

Date: Sat, 08 Jan 2005 20:33:44 -0800

Local: Sat, Jan 8 2005 11:33 pm

Subject: Re: Bug in parsing MDX rollup formula

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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.1051620549@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!

Reply to author Forward