How to export data from cube to CSV file

Question

How to export data from cube to CSV file

Viewing 8 posts - 31 through 37 (of 37 total)

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

rumsmaster Mr or Mrs. 500 Points: 594 More actions · Answer 1

James, I think you are right......SSIS packages are quick.....but the MDX query actually needs to be optimized before it is put into action.

@smith..You can try and fetch a small dataset from the cube and not the time for data transfer

Here is the link for your help

http://bhavikmerchant.wordpress.com/2009/09/06/using-mdx-queries-in-ssis-without-openquery/

Regards,

Rafayz

james.ciesla Mr or Mrs. 500 Points: 504 More actions · Answer 2

Also, I do have one tip. If you are not that strong in MDX I would recommend you install ProClarity (If you have an MSDN account) and create your report visually. Once you have the filters, dimensions, measures, etc in place then go up to 'View' and 'MDX Editor'. It will generate the MDX for you and then you can just use this for the 'SQL Command' in the data flow task.

rumsmaster Mr or Mrs. 500 Points: 594 More actions · Answer 3

Dear James,

How do you install ProClarity?? And can you post some links for Beginners MDX Queries?

Regards,

Rafayz

P Jones SSChampion Points: 12353 More actions · Answer 4

Why not take a step back and create your SSIS export by querying the tables used to create the cube?

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 5

... That's the current system....

Customer wants it from CUBES only for some good reason...

I explained the scenario in my first post it self...

Thanks.

james.ciesla Mr or Mrs. 500 Points: 504 More actions · Answer 6

Sorry, it appears Microsoft has removed ProClarity Desktop Professional from it's available MSDN downloads. In this case you should browse the cube via Visual Studio (BIDS) and then run a SQL Profiler trace (logging SSAS commands). This will expose the underlying MDX query that the cube browser is using.

Alternatively you can use Excel pivot tables or Power Pivot instead of Visual Studio if you do not have the project files.

For resources on MDX queries, I would pick up a book on SSAS as it will have everything from the basics right up to some pretty advanced topics.

James

rumsmaster Mr or Mrs. 500 Points: 594 More actions · Answer 7

Dear James,

Many thanks on the useful insights. I am new to SSAS and would like your help in future as well.

Regards,

Rafayz

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 8

For resources on MDX queries, I would pick up a book on SSAS as it will have everything from the basics right up to some pretty advanced topics.

Yup... I baught one 2 days back..

Getting confident on MDX now.. Think I will be able to handle all these in week's time..

Thanks.