Skip to Content
avatar image
Former Member

Analytics services and MDX

Hi everybody

How to connect BODS to Analytics Services and then use MDX

Is it possible to use MDX (Multidimensional Expressions)in BODS , please help me.

Thanks you very much

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 17, 2015 at 09:11 AM

    There's no MDX support in DS. It supports relational and NRDM models only.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2015 at 06:49 PM

    Hi Save,

    "Can you use SSIS and create a job to extract the data from the cube.and then use it to write a SQL in the SQL transform in bods."

    Means, you extract the data from your source system with the help of SSIS package/job. And then once you have this data in sql database you can write a query on top of this for sql transform in BODS and process it further.

    Regards,

    Gokul

    Add comment
    10|10000 characters needed characters exceeded