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
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
>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
> >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
>-----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" <joerg.schm...@alreadyspamed.com> wrote in message >news:052201c30d8c$cbf8f960$a501280a@phx.gbl... >> 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
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.
> >-----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$a501280a@phx.gbl"]news:052201c3- > 0d8c$cbf8f960$a5012...@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
> 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$a501280a@phx.gbl"]news:052201c3- > > 0d8c$cbf8f960$a5012...@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
> 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$a501280a@phx.gbl"]news:052201c3- > > 0d8c$cbf8f960$a5012...@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
> >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
