Shared Items RRS feed

  • Question

  • I did not use Shared Items very much in previous projects and now I have come to a project that is using them heavily.  Can I get some reasons as to the benefits of using them over putting those types of calculations in the cube, like: 

    Are sets as Shared Items dynamic as compared to SSAS 2005?

    So would sets as Shared Items be dynamic like the added functionality of sets within SSAS 2008? 

    Is performance better on calculations within the cube?
    I'm trying to understand the differences, pros and cons.
    Thank you.



    Tuesday, May 12, 2009 3:47 PM


  • The main draw of Shared Items over the years has been the ability of analysts to create and share business logic.  However, you are also correct in that shared items are dynamic, which was an advantage up until the concept of dynamic sets in SSAS 2008.  The con to them has always been maintenance and administration, since they're not associated directly with the cube.
    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Sean_Flanagan Monday, July 27, 2009 2:54 PM
    Thursday, May 21, 2009 10:37 PM