Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    7

    Unanswered: MDX error - Unable to open cellset

    Hopefully I am in the right forum

    I am trying to run the following mdx query:

    SELECT
    {
    ([Location].[Code],
    [Measures].Quantity)
    }
    ON COLUMNS,
    {FILTER (
    CROSSJOIN (
    [Manufacturer].MEMBERS, [Item].MEMBERS),
    (([Measures].[Quantity]) <> 0))} ON ROWS
    FROM
    [Stockbalance]

    But, I have encountered the error:
    Unable to open cellset
    Formula error - cannot bind: unknown dimension or member: "[Location].[Code]"

    This is my first query using mdx. -_-' Appreciate if someone could help me out.

    Also, what I am hoping to do:

    Location1 Location2
    Manufacturer Item Desc Qty Qty
    Last edited by sukino; 12-18-07 at 06:17.

  2. #2
    Join Date
    Dec 2007
    Posts
    1
    The correct syntax seems to be:

    SELECT
    {
    ([Location].[code].Members,
    [Measures].Quantity)
    }

    if you need only one specific eg. code = 2000 then use

    SELECT
    {
    ([Location].[code].&[2000],
    [Measures].Quantity)
    }

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •