September 1, 2015 at 9:11 am
Hello,
We have a growing vendor application uses a SSAS multi-dimensional cube for reporting. Another group (Cognos developers) were told to create some more reports from this vendor cube.
However, they can't connect Cognos to an SSAS cube.
Is there a way to export the cube to a database schema of some sort? This would be easier for the Cognos team since the cube has all of the aggregated data. This would be less work than creating their reports off of the raw database tables.
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
September 1, 2015 at 9:16 am
It's been a while since I've worked with Cognos, but I believe you can create a "pointer cube" in Cognos that will read from and essentially duplicate an SSAS cube.
You may need a specific module of Cognos for this, but I'm not 100% sure.
September 2, 2015 at 12:28 pm
That may be. I can check.
But is there a way to export a cube to a series of tables or a single table?
Thanks.
Things will work out. Get back up, change some parameters and recode.
September 2, 2015 at 2:51 pm
In theory, it would be possible to take the results of an MDX query and import that into a table. I don't think there are any built-in tasks in SSIS that extracts MDX into a result set, but you would be able to do it with a .NET script. Could be messy though...
I don't think it would be possible to extract the contents of an entire cube into relational tables. Remember that a cube also stores calculations and aggregated values, which just would not fit into the two-dimensional structure of a relational database.
What you could probably do as well, is look at the data source view of the SSAS project as well as the code for the calculated members...and recreate that in Cognos. Not sure if it would be worth the amount of effort though...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply