Home Forums SQL Server 2005 Business Intelligence need suggestions on converting cognos cubes to ssas cubes RE: need suggestions on converting cognos cubes to ssas cubes

  • 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