Comments in MDX / - Sample Application

joerg

unread,

Apr 28, 2003, 7:26:56 AM4/28/03

to

Hello,
Thank you for reading this.

I have to build complex MDX statements with comments.
I got the following behaviour within the MDX SApp.
The statement below does not work until i remove the
commented line. Is there a special thing about comments?
Thank you!
Jörg

Select
filter(
customers.allmembers
--,measures.[store sales]>1000)
,instr(1,[customers].currentmember.name,"USA") > 0)
on 0 from sales

dxd

unread,

Apr 28, 2003, 9:22:49 AM4/28/03

to

Try the C++ style. Like //, or /* ... */
Originally posted by Joerg

> Hello,
> Thank you for reading this.
>
> I have to build complex MDX statements with comments.
> I got the following behaviour within the MDX SApp.
> The statement below does not work until i remove the
> commented line. Is there a special thing about comments?
> Thank you!

> J=F6rg
>
> Select=20

> filter(
> customers.allmembers
> --,measures.[store sales]>1000)
> ,instr(1,[customers].currentmember.name,"USA") > 0)
on 0 from sales

--
Posted via http://dbforums.com

joerg

unread,

Apr 28, 2003, 9:48:06 AM4/28/03

to

i tried all options; same problem

>.
>

Sean Boon [MS]

unread,

Apr 28, 2003, 2:15:37 PM4/28/03

to

What version of Analysis Services are you using? Comments weren't
introduced until Analysis Services 2000.

Sean

--
Sean Boon
SQL BI Product Unit

**This posting is provided AS IS, with no warranties, and confers no
rights.**
"joerg" <joerg....@alreadyspamed.com> wrote in message
news:052201c30d8c$cbf8f960$a501...@phx.gbl...

joerg

unread,

Apr 29, 2003, 6:38:22 AM4/29/03

to

SQL 2000 Enterprise, SP3

>.
>

dxd

unread,

Apr 29, 2003, 8:49:09 AM4/29/03

to

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
>
>
> >-----Original Message-----
> >What version of Analysis Services are you using?
> Comments weren't
> >introduced until Analysis Services 2000.
> >Sean
> >--
> >Sean Boon
> >SQL BI Product Unit
> >**This posting is provided AS IS, with no warranties, and
> confers no
> >rights.**

> >"joerg" wrote in message
> >news:052201c30d8c$cbf8f960$a501...@phx.gbl"]news:052201c3-
> 0d8c$cbf8f960$a501...@phx.gbl[/url]...

> >> i tried all options; same problem
> >> >-----Original Message-----
> >> >
> >> >Try the C++ style. Like //, or /* ... */
> >> >Originally posted by Joerg
> >> >> Hello,
> >> >> Thank you for reading this.
> >> >>
> >> >> I have to build complex MDX statements with comments.
> >> >> I got the following behaviour within the MDX SApp.
> >> >> The statement below does not work until i remove the
> >> >> commented line. Is there a special thing about
> comments?
> >> >> Thank you!
> >> >> J=F6rg
> >> >>
> >> >> Select=20
> >> >> filter(
> >> >> customers.allmembers
> >> >> --,measures.[store sales]>1000)
> >> >> ,instr(1,[customers].currentmember.name,"USA") > 0)
> >> >on 0 from sales
> >> >
> >> >--
> >> >Posted via

> http://dbforums.com/http://dbforums.com
> >> >.
> >> >
>.

Sean Boon [MS]

unread,

Apr 29, 2003, 1:05:35 PM4/29/03

to

I can reproduce this behavior. I'll check to see if this is doc'd anywhere.

Sean

--
Sean Boon
SQL BI Product Unit

**This posting is provided AS IS, with no warranties, and confers no
rights.**

"dxd" <membe...@dbforums.com> wrote in message
news:2819556.1...@dbforums.com...

Sean Boon [MS]

unread,

Apr 29, 2003, 2:48:20 PM4/29/03

to

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" <membe...@dbforums.com> wrote in message
news:2819556.1...@dbforums.com...
>

Olivier Kovacs

unread,

May 6, 2003, 10:22:21 AM5/6/03

to

I use the MSSQL comments for single lines.
Just start your line with -- (2 minus signs)
It works for me!

"joerg" <joerg....@alreadyspamed.com> wrote in message
news:052201c30d8c$cbf8f960$a501...@phx.gbl...