Post reply

Data extraction from SSAS cube

  • May 26, 2011 at 1:52 am

    #241147

    Dear Experts,

    I need to develop a .csv report from the MDX query which is run in SSAS cube.

    and also i need to format to .csv file i mean little bit of format to it.

    In simple if i can query a cube through MDX query and insert into a table then i can format and generate the .csv file from it.

    If somebody could pls help me in doing this will be helpful.

    Thanks,

    Gangadhar

  • May 26, 2011 at 2:58 am

    #1330114

    you could use SSRS for this and use your MDX as the data set and then export to CSV

  • May 26, 2011 at 4:37 am

    #1330146

    Another Way is to use OPENROWSET To Analysis Service

    http://support.microsoft.com/kb/218592

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply