Re: Problems with SCOPE and EXCEPT()
- From: porter2347@xxxxxxxxx
- Date: 16 Jan 2007 09:19:39 -0800
BTW, we are on SP1
Mike wrote:
This snippet (below) is supposed to be replacing multiple calculated cells
that we migrated over from SSAS2000 to SSAS2005
The members; "Per Rentable Unit" and "Percent of Total Revenue" are
calculated members.
When selecting on the expression;
EXCEPT([Measures].allmembers,{[Measures].[Per Rentable Unit],
[Measures].[Percent of Total Revenue]}), the query results are fine.
But once I embed in the scope statement and attempt to process the cube I
get the following error:
Error 1 MdxScript(VIG_eReporting) (34, 25) The member '[Per Rentable Unit]'
was not found in the cube when the string, [Measures].[Per Rentable Unit],
was parsed. 0 0
SCOPE ({EXCEPT([Measures].allmembers,{[Measures].[Per Rentable Unit],
[Measures].[Percent of Total Revenue]})});
SCOPE ({[COA].&[80699]});
THIS = A Formula;
END SCOPE;
SCOPE ({[COA].&[80799]});
THIS = A Formula;
END SCOPE;
........
END SCOPE;
.
- Prev by Date: Re: calculation the median
- Next by Date: Re: Problems with SCOPE and EXCEPT()
- Previous by thread: Re: OWC and Analysis Services (cross-post)
- Next by thread: Re: Problems with SCOPE and EXCEPT()
- Index(es):
Relevant Pages
|
