SSAS partitions

  • Everything I read says you need Enterprise edition to partition a measure in a SSAS cube. I'm running 2008 R2 on my production server.

    SELECT @@Version; returns:

    Microsoft SQL Server 2008 R2 (SP1) - 10.50.2796.0 (X64)

    Dec 9 2011 11:27:20

    Copyright (c) Microsoft Corporation

    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    Yet, when I open my production cube in BIDs/VS and look at a cube's Partitions tab, I see measures that have multiple franchises (See attached graphic).

    What am I missing?

    Thanks,

    Rob

  • Could you be using Enterprise SSAS & Standard SQL Server?

    Mack

  • Mackers (10/25/2012)


    Could you be using Enterprise SSAS & Standard SQL Server?

    I don't think so, but I double checked. I connected to the SSAS server with SSMS, right clicked on the server and went to Reports, Standard Reports, General and it says:

    Edition: Standard64

    Version: 10.50.2796.0

    Was partitioning something that changed between SSAS 2005 and 2008? so that it's now allowed in Standard edition?

    Puzzled,

    Rob

  • You need to make sure that your development environment edition in BIDS is set to match your production environment. See the link below:

    http://www.mssqltips.com/sqlservertip/2150/edition-specific-ssas-development-using-bids/

  • Charles,

    But my situation is that I have 2008 R2 Standard edition on the production server, but when I open the production SSAS database directly through BIDS/VS I see partitions on my measures -- which I didn't think was possible in Standard edition. (See attached screen capture of production SSAS db)

    Rob

  • robert.gerald.taylor (10/25/2012)


    Charles,

    But my situation is that I have 2008 R2 Standard edition on the production server, but when I open the production SSAS database directly through BIDS/VS I see partitions on my measures -- which I didn't think was possible in Standard edition. (See attached screen capture of production SSAS db)

    Rob

    That is interesting...what do you see when you look at the partitions in Management Studio?

  • In SSMS, I have the partitions as well. See attached screen capture.

    It makes me think that this changed since SSAS 2005 to allow for partitions in Standard edition.

    Rob

  • robert.gerald.taylor (10/25/2012)


    In SSMS, I have the partitions as well. See attached screen capture.

    It makes me think that this changed since SSAS 2005 to allow for partitions in Standard edition.

    Rob

    Not according to BOL...but hey, if you are getting it for free there's no reason for complaints 🙂

  • Martin Schoombee (10/25/2012)


    Not according to BOL...but hey, if you are getting it for free there's no reason for complaints 🙂

    Okay; I wanted to make sure I wasn't losing it or missing something obvious as everything I had read as well said you needed Enterprise edition to use partitions in SSAS.

    Thanks,

    Rob

  • This is interesting. Do you know if its allowing parallel processing of the partitions?

  • Charles Hearn (10/25/2012)


    This is interesting. Do you know if its allowing parallel processing of the partitions?

    I don't know if it allows for parallel processing -- where would I check for this?

    As an aside, I was talking with a consultant that was on site today, and he said that Standard edition allowed a max of three partitions -- which was a new one to me. I guess I'll have to play around with this some more to see if I can create a fourth partition.

    Rob

  • Only thing I can find is that SQL 2012 Multi Dimensional supports up to 3 partitions under the Standard license. Are you sure you're not possibly running 2012 Analysis services?

  • richykong (10/25/2012)


    Only thing I can find is that SQL 2012 Multi Dimensional supports up to 3 partitions under the Standard license. Are you sure you're not possibly running 2012 Analysis services?

    100% positive it's 2008 R2 -- see earlier in the thread; I double checked both db engine and SSAS.

  • Charles Hearn (10/25/2012)


    This is interesting. Do you know if its allowing parallel processing of the partitions?

    Charles, investigating further, it doesn't appear that parallel processing is allowed (see attached screen capture from SSMS) in SQL Server Standard edition even though partitions are allowed.

    HTH,

    Robo

Viewing 14 posts - 1 through 13 (of 13 total)

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