Fastest way Use analysis service dataset as dataset table in oracle

[radissoufan]

Hello...
Ssas technolgy is a great technlogy for one click to build a report as self service that can drag a measure with 2 or 3 diminsions and here you got your report... What is the fastest way to read a dataset built by ssas self service to load its result to a table in oracle database and use it later on as a datasource instead of build an oracle query from scratch until it matchs the result built by ssas... Is there any tobic or tool i can use?

[UlfBergqvist]

I think it depends a lot on the model complexity, data volumes and things like that.

If the model is simple and you don't need to automate the task I would use any query tool (like DAX Studio or Management Studio) and just write a query (In it's simplest form - EVALUATE 'Table'), save the result to a csv file (possible both in DAX Studio and Management Studio) and then import that csv file to the Oracle database.