SQL Server Performance

MDX Sample Application Error

Discussion in 'Analysis Services/Data Warehousing' started by DWHNewUser, Jul 12, 2004.

  1. DWHNewUser New Member

    Hi all,

    I'm a new user in Data Warehouse. I created my data warehouse database and cubes and could browser data in the cube. But when I tried the MDX Sample Application to run the script: SELECT [Batch].[Batch Number] ON COLUMNS,[Measures].[Line Total] ON ROWS FROM MyCube
    , I got the error message as following:

    Unable to open cellset
    Formula error - cannot bind:
    the name: "[Batch].[Batch Number]" is unbindable in the current context.

    By the way, if I selected the FoodMart2000 as database, Sales as cube, I could get results.

    Did I miss something to create the cube?

    Many thanks if you have solutions on it, I will really appreciate it !!

    ym
  2. Raulie New Member

    quote:Originally posted by DWHNewUser


    Did I miss something to create the cube?

    You didn't miss anything in your cube, you just forgot to enclose your set in Braces try this {[Batch].[Batch Number]}

  3. DWHNewUser New Member

    Hi Raulie,
    Thanks for your reply. I added the Braces and still got the error:

    Unable to open cellset
    Formula error - cannot bind unknown dimension or member "[Batch].[Batch Number]"

    But I can browser the dimensions and members in the cube pane with MDX Sample Application.

    Thanks

    ym
  4. Raulie New Member

    Thats strange....it should work.

    Try this

    SELECT
    {[Batch].[Batch Number]} ON COLUMNS,
    {[Measures].[Line Total]} ON ROWS

    FROM MyCube

    Also make sure you got the latest service pak on AS and SQL.

    www.microsoft.com/sql/downloads/2000/sp3.asp
  5. stevefromOZ New Member

    I think the problem is that you'r enot actualling calling a set or member, you're referencing a level.

    Try changing the mdx to something like

    SELECT
    {[Batch].[Batch Number].Members} ON 0,
    {[Measures].[Line Total]} ON 1
    FROM [MyCube]

    You need to identify a member or set of members to return. Making the call to just the Batch Number level isn't enough. Obviously you could call out a single member like {[Batch].[batch 12345]}.

    Hope this helps,

    Steve


    HTH,

    Steve
  6. DWHNewUser New Member

    Thanks a lot! It works!

    ym

Share This Page