Re: MDX newbie question please

I guess you just copied and pasted the sample, so it includes
carriage-return in the member name.

Try below again,

SELECT Measures.MEMBERS ON COLUMNS,
{[Store].[Store State].[CA], [Store].[Store State].[WA]} ON ROWS
FROM [Sales]

Ohjoo

"Buster Coder" <dice_response@xxxxxxxxxxx> wrote in message
news:1168136451.499208.196740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am just getting into writing these queries and am trying to test with
a simple MDX query against my Sales cube that I've been working with
through the SQL Server 2000 Analysis Services tutorial:

SELECT Measures.MEMBERS ON COLUMNS, {[Store].[Store
State].[CA], [Store].[Store State].[WA]} ON ROWS
FROM [Sales]

I keep getting this error:

"Unable to open cellset
Formula error - cannot find dimension member ("[Store].[Store
State].[CA]") - in a name binding function"

If someone could show me where I'm going wrong I'd really appreciate
it. I copied this sample from the following site so I'm sure the syntax
is correct:

http://publib.boulder.ibm.com/infocenter/ablxhelp/v8r4m0/index.jsp?topic=/com.ibm.db2.abx.dev.doc/abx-t-develop-212.html

So, is there something else other than this query that is wrong or I
need to check?

Thanks in advance,
Buster



.

Relevant Pages

  • Re: Inconsistent query results
    ... If you executes your MDX query in MDX Sample Application, ... > 'select product.children on columns from sales' ... Default member is 'all member' for all dimensions. ...
    (microsoft.public.sqlserver.olap)
  • Display Parent details
    ... I am writing a MDX Query which will show the Sales Information of Product ... I am passing the Brand Name to the query and I expect to get the ... Sales for Brand Name, Product Subcategory, Product Category, Product ...
    (microsoft.public.sqlserver.olap)
  • Re: HELP! MDX query from Query Analyzer to a Linked Analysis Server
    ... execute an mdx query interactively using query analyzer. ... > I have followed tutorial 1 to build a basic cube in Analysis Manager. ... > database is called Tutorial and the cube is called Sales. ... > When I try and do an MDX query from Query Analyzer to a Linked Analysis ...
    (microsoft.public.sqlserver.olap)
  • Creating an MDX named Set using variables
    ... I have the following MDX query that works. ... The intention is to return the top X states by sales, and within those X states, return the top Y products by sales. ... However, I'd like to abstract out as much of this as possible into a Named Set in the cube, because I might want to use the same logic in another OLAP designer. ...
    (microsoft.public.sqlserver.olap)
  • Using function to add member to a set
    ... I have created the following MDX query that queries the ... Foodmart 2000 Sales Cube: ... We need to preserve the repeating member (". ...
    (microsoft.public.sqlserver.olap)
Loading