Very Computer

Below, please find a query I'm currently being frustrated by.  I have
followed whatever WITH examples I could find in books by Wiley, Sams
and Wrox, but I'm not seeing the problem.

Any suggestions?

Thanks;
Duncan

-----------------------------------------

WITH
SET     [Vehicle Groupies]
AS
        '{
                [Vehicle Groups].[All Vehicle Groups]
        }'

SELECT

{       [cost month].children

Quote:}

CROSSJOIN
(       {        [document type].[document type].members
        }
        ,
        {       [measures].[measureslevel].[document id]
        }
)
on axis(1)

FROM
        [vehicle maintenance]
WHERE
(       [Vehicle Groupies]
)

--------------------------------------------------------

Microsoft? OLE DB Provider for OLAP Services error '80040e14'

OLAP server error: Formula error (no set holder: in referencing a named
<set>).

/english/maintenance_cost/tester.asp, line 246

Sent via Deja.com http://www.deja.com/
Before you buy.

I believe your statement should probably be closer to this format:
WITH
MEMBER [Vehicle Groups].[Vehicle Groupies]  AS '[Vehicle Groups].[All
Vehicle Groups]'
MEMBER [Measures].[Document] AS 'Crossjoin([Document Type].[Document
Type].members, [Measures].[Document ID])'
SELECT
{
   [Cost Month].Children

Quote:}ON COLUMNS,

Quote:} ON ROWS

Hope this helps !
denny  8-)
--

Denny Guang Yeu Lee
eCash Technologies

Quote:> Greetings:

> Below, please find a query I'm currently being frustrated by.  I have
> followed whatever WITH examples I could find in books by Wiley, Sams
> and Wrox, but I'm not seeing the problem.

> Any suggestions?

> Thanks;
> Duncan

> -----------------------------------------

> WITH
> SET     [Vehicle Groupies]
> AS
>         '{
>                 [Vehicle Groups].[All Vehicle Groups]
>         }'

> SELECT

> {       [cost month].children
> }
> on axis(0),

> CROSSJOIN
> (       {        [document type].[document type].members
>         }
>         ,
>         {       [measures].[measureslevel].[document id]
>         }
> )
> on axis(1)

> FROM
>         [vehicle maintenance]
> WHERE
> (       [Vehicle Groupies]
> )

> --------------------------------------------------------

> Microsoft? OLE DB Provider for OLAP Services error '80040e14'

> OLAP server error: Formula error (no set holder: in referencing a named
> <set>).

> /english/maintenance_cost/tester.asp, line 246

> Sent via Deja.com http://www.deja.com/
> Before you buy.

WITH
SET     [Vehicle Groupies]
AS
        'Generate({
                [Vehicle Groups].[All Vehicle Groups]
        })'

SELECT

{       [cost month].children

Quote:}

CROSSJOIN
(       {        [document type].[document type].members
        }
        ,
        {       [measures].[measureslevel].[document id]
        }
)
on axis(1)

FROM
        [vehicle maintenance]
WHERE
(       [Vehicle Groupies]
)

Cheers,  Ravi.

Quote:> Greetings:

> Below, please find a query I'm currently being frustrated by.  I have
> followed whatever WITH examples I could find in books by Wiley, Sams
> and Wrox, but I'm not seeing the problem.

> Any suggestions?

> Thanks;
> Duncan

> -----------------------------------------

> WITH
> SET     [Vehicle Groupies]
> AS
>         '{
>                 [Vehicle Groups].[All Vehicle Groups]
>         }'

> SELECT

> {       [cost month].children
> }
> on axis(0),

> CROSSJOIN
> (       {        [document type].[document type].members
>         }
>         ,
>         {       [measures].[measureslevel].[document id]
>         }
> )
> on axis(1)

> FROM
>         [vehicle maintenance]
> WHERE
> (       [Vehicle Groupies]
> )

> --------------------------------------------------------

> Microsoft? OLE DB Provider for OLAP Services error '80040e14'

> OLAP server error: Formula error (no set holder: in referencing a named
> <set>).

> /english/maintenance_cost/tester.asp, line 246

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Duncan,

I'm not sure but I believe that the problem is at your SET definition:

SET     [Vehicle Groupies]
 AS
         '{
                 [Vehicle Groups].[All Vehicle Groups]
         }'

It should be:

SET     [Vehicle Groupies]
 AS
         '{
                 [Vehicle Groups].[All Vehicle Groups].MEMBERS   (** or
CHILDREN? **)
         }'

I agree with Deny that using members could be a better solution in this
case. If you keep having problems, try making similar queries with Foodmart
database so that we can try to fix it for you. I know it is not the real
thing but this way other people can execute it also.

best regards,
Mauro Vianna

Quote:> Greetings:

> Below, please find a query I'm currently being frustrated by.  I have
> followed whatever WITH examples I could find in books by Wiley, Sams
> and Wrox, but I'm not seeing the problem.

> Any suggestions?

> Thanks;
> Duncan

> -----------------------------------------

> WITH
> SET     [Vehicle Groupies]
> AS
>         '{
>                 [Vehicle Groups].[All Vehicle Groups]
>         }'

> SELECT

> {       [cost month].children
> }
> on axis(0),

> CROSSJOIN
> (       {        [document type].[document type].members
>         }
>         ,
>         {       [measures].[measureslevel].[document id]
>         }
> )
> on axis(1)

> FROM
>         [vehicle maintenance]
> WHERE
> (       [Vehicle Groupies]
> )

> --------------------------------------------------------

> Microsoft? OLE DB Provider for OLAP Services error '80040e14'

> OLAP server error: Formula error (no set holder: in referencing a named
> <set>).

> /english/maintenance_cost/tester.asp, line 246

> Sent via Deja.com http://www.deja.com/
> Before you buy.