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 unknown dimension or member "[Batch].[Batch Number]"

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

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

Hi,

if the [Batch Number] is a member in dimension [Batch]
then the MDX should be like:
SELECT {[Batch].&[Batch Number]} ON COLUMNS,{[Measures].[Line Total]} ON
ROWS FROM MyCube

if not, and if the [Batch Number] is a name of a level, then you have to say
what do you want to do with that level;
for example if you would like to see all members in that level:
SELECT {[Batch].[Batch Number].members} ON COLUMNS,{[Measures].[Line Total]}
ON ROWS FROM MyCube

HTH,
Andrej


"May" <May (AT) discussions (DOT) microsoft.com> wrote

Application to run the script: SELECT {[Batch].[Batch Number]} ON
COLUMNS,{[Measures].[Line Total]} ON ROWS FROM MyCube

Hi Andrej,

Thanks a lot ! It works!

ym

"Andrej Hudoklin" wrote: