Does anybody know how to create a cube with MDX?

I know how to use MDX for query, but i didn't find a way to create a cube with MDX. Can anybody help?
Thanks in advance
FisheyIf what you are asking is how to create Data Cubes, then the answer is that cubes are created using Analysis Manager after installing Analysis Services.

If your question is how to automate the creation of a cube so that users can do it, I don't think I have a good answer.

Finally, if your question is how to automate the update of a cube so that a job can do it on SQL server, there are DTS objects in DTS designer to do this for you.

And if I haven't answered your question, then I'll just go duck around this corner and hide for being so dull as to not understand the question.

;-)

Hugh Scott

Originally posted by fishey
I know how to use MDX for query, but i didn't find a way to create a cube with MDX. Can anybody help?

Thanks in advance

Fishey|||Thank you very much, Hugh.
Actually, I know how to create a cube in Analysis Manager and i also
can use DSO to create a cube in vb application. But now what i want to do is using MDX syntax to create a cube, just like using SQL script syntax to create a table. Do you know any workarounds about it?

Thanks again.

Fishey|||[peeks out from around the corner]

I'm sorry no, I have no clue. I should have figured out what you were really asking for from the context, but I guess I read your post wrong. I am very weak when it comes to MDX and data cubes. One day maybe I will learn...

The only thing that I can really offer is using the DSO object model and creating a shell around that...

Best of luck.

Hugh Scott

Originally posted by fishey
Thank you very much, Hugh.
Actually, I know how to create a cube in Analysis Manager and i also
can use DSO to create a cube in vb application. But now what i want to do is using MDX syntax to create a cube, just like using SQL script syntax to create a table. Do you know any workarounds about it?

Thanks again.

Fishey