Google Groups Home
Help | Sign in
microsoft.public.sqlserver.olap
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Bug in parsing MDX rollup formula
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Marco Russo  
View profile
  More options Jan 8 2005, 1:48 pm
Newsgroups: microsoft.public.sqlserver.olap
From: marco.ru...@loader.it (Marco Russo)
Date: 8 Jan 2005 10:48:47 -0800
Local: Sat, Jan 8 2005 1:48 pm
Subject: Bug in parsing MDX rollup formula
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
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


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
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 | Individual message | 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...

- Deepak

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


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
marco.ru...@loader.it  
View profile
  More options Jan 9 2005, 4:53 am
Newsgroups: microsoft.public.sqlserver.olap
From: marco.ru...@loader.it
Date: 9 Jan 2005 01:53:25 -0800
Local: Sun, Jan 9 2005 4:53 am
Subject: Re: Bug in parsing MDX rollup formula
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

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

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Mosha Pasumansky [MS]  
View profile
  More options Jan 11 2005, 12:08 am
Newsgroups: microsoft.public.sqlserver.olap
From: "Mosha Pasumansky [MS]" <mos...@online.microsoft.com>
Date: Mon, 10 Jan 2005 21:08:15 -0800
Local: Tues, Jan 11 2005 12:08 am
Subject: Re: Bug in parsing MDX rollup formula
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

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


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google