|
Home > Archive > MS SQL Server OLAP > November 2005 > The star (*) in MDX
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
The star (*) in MDX
|
|
| Tim Chapla 2005-11-29, 9:24 am |
| Does anyone know what the (*) does in MDX?
I am trying to evaluate part of a query. First, what do the stars do? (*)
Also, this bombs in the MDX Sample Application telling me that the
'.item(0)' is where the end of the statement is. Can I get the '.item(0)'
to work here?
WHERE Extract(Extract(Hier
archize({[DistrictFAY].[All
DistrictFAY].[Yes]})*{[SchoolFAY].DefaultMember},& #91;DistrictFAY])*Hi
erarchize({[SchoolFAY].[All
SchoolFAY].[Yes]}),[DistrictFAY],[SchoolFAY]).item(0)
thank you in advance,
tim
| |
| shilpy 2005-11-29, 11:23 am |
| * represents a crossjoin
"Tim Chapla" wrote:
> Does anyone know what the (*) does in MDX?
>
> I am trying to evaluate part of a query. First, what do the stars do? (*)
> Also, this bombs in the MDX Sample Application telling me that the
> '.item(0)' is where the end of the statement is. Can I get the '.item(0)'
> to work here?
>
> WHERE Extract(Extract(Hier
archize({[DistrictFAY].[All
> DistrictFAY].[Yes]})*{[SchoolFAY].DefaultMember},& #91;DistrictFAY])*Hi
erarchize({[SchoolFAY].[All
> SchoolFAY].[Yes]}),[DistrictFAY],[SchoolFAY]).item(0)
>
> thank you in advance,
> tim
>
>
>
|
|
|
|
|