Re: Problems with SCOPE and EXCEPT()

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;

.

Relevant Pages

  • Re: Problems with SCOPE and EXCEPT()
    ... BTW, we are on SP1 ... Mike wrote: ... calculated members. ... When selecting on the expression; ...
    (microsoft.public.sqlserver.olap)
  • Re: Unable to import since install of Office SP1
    ... but not with Access 2007 SP1. ... Co-author - Microsoft Office Access 2007 Inside Out ... "Mike P" wrote in message: ... I have one computer that I did not install SP1 on and the import works ...
    (microsoft.public.access.externaldata)
  • Re: Drop Down Menu? Is it possible?
    ... Hi Mike, ... > Selecting a subject would populate a second combo box that lists all ... > Selecting a newspaper could populate a third box that shows all editions ... >> finnaly I decided I should enter the data by article, and not by newspaper ...
    (microsoft.public.access.gettingstarted)
  • Re: If not WHEN, then how about WHY?
    ... Mike, I'll just reiterate that our official stated range was Q3 CY 2004 ... I don't know where you saw "2 other release goals since SP1 was ... Check out the SMS Technical FAQ: ...
    (microsoft.public.sms.admin)
  • Re: Marquee
    ... Mike ... "Mary Sauer" wrote in message ... > When you marquee a page you are selecting that portion, ...
    (microsoft.public.publisher)
Loading