Post reply

Connection to OLAP with DTS?

  • March 7, 2006 at 5:35 am

    #76500

    Could someone tell me if i can connect to OLAP using DTS (to the results i mean). I nead to extract two of the results and to use them into another report.

    Thank you!

  • March 8, 2006 at 3:01 am

    #625345

    Create a custom connection in DTS using the Microsoft OLE DB Provider for Olap Services 8.0.

    Then query your cube with mdx - use a transform data task to pipe the results to a table / xls / csv for your report.

  • March 8, 2006 at 3:25 am

    #625346

    10x for the tip...now i have to figure it out what you sayed. anyway...ill try it and ill let you know

    P.S a more detaliate explanation:

    the cube is allready processed. It is used in connection with an excel file but i cant take the information that i nead from that xls. I need just 2 of the elements in the cube and i dont want to create a procedure to solve this problem because it would run as long as the cube does(4 hours)...and the cube is processed each day...so i tought it could be a good thing if i could extract the allready calculated elements from the cube.

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

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