Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Data Warehousing » Analysis Services » SSAS partitions
Add to briefcase
14 posts, Page 1 of 2
12»»

SSAS partitions Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
robert.gerald.taylor
Posted Wednesday, October 24, 2012 12:01 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 740, Visits: 790
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 (10 views, 47.24 KB)
Post #1376611
Mackers
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: Yesterday @ 4:19 AM
Points: 117, Visits: 460
Could you be using Enterprise SSAS & Standard SQL Server?

Mack
Post #1376810
robert.gerald.taylor
Posted Thursday, October 25, 2012 6:32 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 740, Visits: 790
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
Charles Hearn
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: Yesterday @ 4:45 AM
Points: 557, Visits: 4,822
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
robert.gerald.taylor
Posted Thursday, October 25, 2012 7:52 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 740, Visits: 790
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 (4 views, 43.01 KB)
Post #1376996
Martin Schoombee
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: Thursday, April 18, 2013 6:20 AM
Points: 317, Visits: 3,605
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
robert.gerald.taylor
Posted Thursday, October 25, 2012 8:27 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 740, Visits: 790
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 (7 views, 21.29 KB)
Post #1377020
Martin Schoombee
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: Thursday, April 18, 2013 6:20 AM
Points: 317, Visits: 3,605
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
robert.gerald.taylor
Posted Thursday, October 25, 2012 8:33 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 740, Visits: 790
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
Charles Hearn
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: Yesterday @ 4:45 AM
Points: 557, Visits: 4,822
This is interesting. Do you know if its allowing parallel processing of the partitions?
Post #1377074
« Prev Topic | Next Topic »

Add to briefcase
14 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.