October 24, 2012 at 12:01 pm
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
October 25, 2012 at 1:20 am
Could you be using Enterprise SSAS & Standard SQL Server?
Mack
October 25, 2012 at 6:32 am
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
October 25, 2012 at 6:56 am
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/
October 25, 2012 at 7:52 am
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
October 25, 2012 at 8:08 am
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?
October 25, 2012 at 8:27 am
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
October 25, 2012 at 8:30 am
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 🙂
October 25, 2012 at 8:33 am
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
October 25, 2012 at 9:23 am
This is interesting. Do you know if its allowing parallel processing of the partitions?
October 25, 2012 at 12:17 pm
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
October 25, 2012 at 2:39 pm
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?
October 25, 2012 at 8:45 pm
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.
October 27, 2012 at 12:52 pm
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