Working with and extending the cubes that ship with Dynamics AX 2009 RRS feed

  • Question

  • (where's the Dynamics AX forum?)

    I'm a SQL Server BI solution architect that has been called in by a client to extend and manage the cubes that come stock with Dynamics AX.  In a word, they're a huge mess.  All the objects; cubes, measures, measure groups, dimensions, attributes, etc. are based on normaized daabase with abuot 2,300 tables - rather than a dimensional data schema.  Most of the dimensions are based on relational lookup tables and are not organizd into hierarchies to support drill-down paths.

    Just wondering what, if anything, might make sense about this design or the features it contains before I blow the whole thing away and start over again.

    • I'm looking for experince with these cubes, stories from the trenches about what has and hasn't worked 
    • Have you extended these cubes or started over?

    Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com
    Friday, August 13, 2010 8:30 AM