Export Cognos 7 cube data and import to DB

[Cognos8]

I have Cognos 7 cubes but no source for that. How to extarct Cognos 7 cube data and load it in to other proper database?.
One way is create a report and export it in to CSV. but single report will not have all data of cube. exporting each dimension can also be challenge. because each dimenion can have multiple tables. Any experience on this???

[MFGF]

What happened to the data source(s) Transformer used in building the cubes in the first place? I'd suggest the easiest option is to locate these and use the data directly. Otherwise, it's (as you say) a challenge. Cubes are not designed to be sources for "data dump" list reports - you will probably have to put some effort in to building multiple reports for each dimension and your granular measures.

Good luck!

MF.

Sent from my iPad using Tapatalk HD