Prev: can't hit 2008 db with ssrs2005?
Next: series point value
From: Bink on 8 Apr 2010 16:42
I have a calculated member issue that I'm sure is simple but cannot get to
work.

This works fine ....

SELECT
NON EMPTY {[Measures].[Clm Amnt], [Measures].[Denial Detail Count]} ON
COLUMNS,
NON EMPTY{[DenialPostongTimeData].[PrimeDate].[Month_Date]} ON ROWS
FROM [Denial Detail Analysis]


I would think that this would return the same result but it errors out ....


WITH MEMBER [DenialPostongTimeData].[PrimeDate].[SomeName] as
'([DenialPostongTimeData].[PrimeDate].[Month_Date])'

SELECT
NON EMPTY {[Measures].[Clm Amnt], [Measures].[Denial Detail Count]} ON
COLUMNS,
NON EMPTY{[DenialPostongTimeData].[PrimeDate].[SomeName]} ON ROWS
FROM [Denial Detail Analysis]

From: Patrice on 9 Apr 2010 07:27
Hello,

> I would think that this would return the same result but it errors out
> ....

The error being ? Please never post about an error without telling what the
error message is....

> as '([DenialPostongTimeData].[PrimeDate].[Month_Date])'

Is this a typo in your post ? What if you suppress the enclosing '
characters ?

For now it seems to me you are confusing AS to define an alias and AS to
define an expression...

--
Patrice



From: Bink on 9 Apr 2010 09:39
Ther error message is the word '#Error' appears in the output. I get the same
result without quotes surrounding the AS clause.

"Patrice" wrote:

> Hello,
>
> > I would think that this would return the same result but it errors out
> > ....
>
> The error being ? Please never post about an error without telling what the
> error message is....
>
> > as '([DenialPostongTimeData].[PrimeDate].[Month_Date])'
>
> Is this a typo in your post ? What if you suppress the enclosing '
> characters ?
>
> For now it seems to me you are confusing AS to define an alias and AS to
> define an expression...
>
> --
> Patrice
>
>
>
> .
>
 | 
Pages: 1
Prev: can't hit 2008 db with ssrs2005?
Next: series point value