Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SSAS partitions Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 12:01 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 11:17 AM
Points: 1,184, Visits: 1,220
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


  Post Attachments 
SSAS partitions.PNG (15 views, 47.24 KB)
Post #1376611
Posted Thursday, October 25, 2012 1:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
Could you be using Enterprise SSAS & Standard SQL Server?

Mack
Post #1376810
Posted Thursday, October 25, 2012 6:32 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 11:17 AM
Points: 1,184, Visits: 1,220
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
Post #1376952
Posted Thursday, October 25, 2012 6:56 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:07 AM
Points: 567, Visits: 4,930
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/

Post #1376963
Posted Thursday, October 25, 2012 7:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 11:17 AM
Points: 1,184, Visits: 1,220
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


  Post Attachments 
Partitions.PNG (5 views, 43.01 KB)
Post #1376996
Posted Thursday, October 25, 2012 8:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, January 25, 2014 2:15 PM
Points: 317, Visits: 3,612
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?



Post #1377004
Posted Thursday, October 25, 2012 8:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 11:17 AM
Points: 1,184, Visits: 1,220
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


  Post Attachments 
SSMS partitions.PNG (16 views, 21.29 KB)
Post #1377020
Posted Thursday, October 25, 2012 8:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, January 25, 2014 2:15 PM
Points: 317, Visits: 3,612
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



Post #1377026
Posted Thursday, October 25, 2012 8:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 11:17 AM
Points: 1,184, Visits: 1,220
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
Post #1377032
Posted Thursday, October 25, 2012 9:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:07 AM
Points: 567, Visits: 4,930
This is interesting. Do you know if its allowing parallel processing of the partitions?
Post #1377074
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse