MDX Sample Application | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MDX Sample Application

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