Post reply

need suggestions on converting cognos cubes to ssas cubes

  • September 29, 2014 at 2:34 pm

    #290441

    Due to the price of Cognos, my company has decided to convert all Cognos cubes to SSAS. I need suggestions how to do it efficiently.

    providing more details: our Cognos cubes are designed in "category", "feed" and "transformer" fashion, which to my understanding, are equivalent to calculated columns, named queries in ssas data sources and cubes. So will it be easier if I translate Cognos SQL queries and create SQL views to prepare dimensions and measures?

    any advices are appreciated.

  • October 19, 2016 at 10:37 am

    #1907468

    Hi,

    I got similar requirement now. Did you find any solution for this requirement?

  • October 19, 2016 at 1:23 pm

    #1907523

    I know that this is a few weeks old but since there was no answer:

    So will it be easier if I translate Cognos SQL queries and create SQL views to prepare dimensions and measures?

    This would be how I'd do it. There's no easy way to do this, you just need to build the SSAS cube from the SQL queries you used to build your Cognos cube. If you turn the Cognos queries into views I would suggest indexing them to spead up you SSAS cube processing.

    I can't speak too much to your aggregations, hierarchies, security, etc without more information.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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