Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    18

    Unanswered: 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

    Fishey

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Does anybody know how to create a cube with MDX?

    If 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

  3. #3
    Join Date
    Jan 2003
    Posts
    18

    Re: Does anybody know how to create a cube with MDX?

    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

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Does anybody know how to create a cube with MDX?

    [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

Posting Permissions

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