- Moved by Amanda ZhuMicrosoft contingent staff Monday, May 12, 2014 3:06 AM
Hi,
I moved this thread to SQL Server Analysis Services forum for better support.
Best regards,
Hi Tony,
If I understanding correctly, you can create partition in SQL Server Management Studio (SSMS), however cannot create a partition in Visual Studio (VS). I have tested it on my local environment, we cannot reproduce this issue. I can create partitions on VS
without any problems. So in your scenario, please ensure that the steps you created partition are correct, here are some links about how to create partition on VS step by step, please see:
http://www.bidn.com/blogs/briankmcdonald/bidn-blog/1212/creating-analysis-services-partitions-using-bids
http://www.mssqltips.com/sqlservertip/1549/how-to-define-measure-group-partitions-in-sql-server-analysis-services-ssas/
Hope this helps.
Regards,
I am having the same issue. I already have multiple partitions created and I wanted to add another. I select "Add Partition" go through the wizard steps and then nothing changes. I have reviewed the links provided and was unable to resolve the issue.
FYI: The project I am working in is source controlled with TFS, but I do not think this is relevant because all other changes seem to work properly.
Same issue here. I can edit the default partition but cant add new ones. The partition wizard just closes and does nothing. VS version is 2012.
edit: additional info: it does work with the sql server data tools (VS2010 shell) and the difference seems to be in the version of the partition wizard.- Edited by Dusan Frolkovic Thursday, June 12, 2014 3:23 PM additional info
Same here! It just started happening to me. It seems some recent update must have broken something. I'd have no problem going through SSMS, EXCEPT I CANT IMPORT THE CHANGES into an existing project (and I'm not sorry for yelling, but that is just stupid).
So, fix the partition issue. And make it so we can do a "Schema Compare" between an existing cube on a server and the ssas project files. Then allow for importing of those changes from the existing cube to the project files.
I'm trying to create new partitions in my OLAP cube in Visual Studio 2012. The partition wizard appears and I go through all the steps. When I click finish, nothing happens. No error message and no partition is created. Is this a possible bug in the application. I'm updated fully. It just doesn't create the partition. I can create it in SSMS but not in VS2012. Any help would be appreciated.
Hi
I have the same issue. I have followed the links and tried every angle to add new partitions with vs 2012. The wizard shows up, every step is done, but nothing is added when confirming.
Iam running the project with TFS 2010 in SQL Server Enterprise SSAS Enterprise mode 11.0
Vs 2012 ver. 11.0.61030.00
SQL Server Data Tools 11.1.40706.0
/Michael
*EDIT: I worked around it and created them with SSMS and then reversed it back to a new project and copied the cube and partitionfile to the TFS project. Not a nice solution but it worked :-/
- Edited by Mike 3 Tuesday, August 19, 2014 2:37 PM
I am having the exact same issue doing a MOLAP cube partition within Visual studio 2012 fails to launch Aggregation Design wizard. the same thing in SSMS runs fine and does moves on with creating a new partition.
Such a basic bug, I am thinking what the heck happened and why is this not getting resolved?
Thanks.Ram.
Me Too. I'm having the same problem with visual studio 2013.
Help please!
The workaround is to bring it up in SSMS Analysis services, add the partition to the cube in SSMS, save it, process it and then convert that processed OLAP cube back to a model by importing from VS 2012 again and save it as a model.
I did this successfully. it is a workaround. the issue seems to be VS 2012 does not successfully kickoff aggregation design.
should be some code versioning issue as probably something else overwrote the fix. This was always working until well, it broke. :)
Hi Everyone,
Even I struggle for 4 hours with same issue, then I install SSDT 2012 and it works fine. Now I am having both SSDT 2013 and SSDT 2012 installed on my server. When I try to create partition through SSDT 2013 it does not work and no error message shown but when I create partition through SSDT 2012 then it works fine.
I just got it resolved on my server.
Count me as another person having the same issue. I have partitions created a few months ago in the same project, but now it doesn't work. Wizard opens normally, I complete all steps, and when I hit finish, it closes without error, but doesn't create the partition.
Strangely enough, when I deleted the original partition, it disappeared from the list in VS, but it was still present in SSMS.
I was able to create the partitions through SSMS, but it's a pain that I can't do it in VS. I'm running VS 2012 with TFS 2010.
Hi Tony,
If I understanding correctly, you can create partition in SQL Server Management Studio (SSMS), however cannot create a partition in Visual Studio (VS). I have tested it on my local environment, we cannot reproduce this issue. I can create partitions on VS without any problems. So in your scenario, please ensure that the steps you created partition are correct, here are some links about how to create partition on VS step by step, please see:
http://www.bidn.com/blogs/briankmcdonald/bidn-blog/1212/creating-analysis-services-partitions-using-bids
http://www.mssqltips.com/sqlservertip/1549/how-to-define-measure-group-partitions-in-sql-server-analysis-services-ssas/Hope this helps.
Re
How did you originally create the partitions? Did you create it using VS or from SSMS? If latter then VS project will never show the partitions unless you sync project from AS serverCount me as another person having the same issue. I have partitions created a few months ago in the same project, but now it doesn't work. Wizard opens normally, I complete all steps, and when I hit finish, it closes without error, but doesn't create the partition.
Strangely enough, when I deleted the original partition, it disappeared from the list in VS, but it was still present in SSMS.
I was able to create the partitions through SSMS, but it's a pain that I can't do it in VS. I'm running VS 2012 with TFS 2010.
I'm jumping in as well with the same problem. I've even upgraded to SQL Server 2014 and I still have the same problem. I hope someone here can find solution to this.
One thing I have noticed on this thread is that we're all using TFS. Maybe that is the common point of the issue.
Hi All,
Because of my curiosity I downloaded SSDT 2012 for VS 2012 and tried to mimic the problem you all are facing but I was able to create the partitions through VS2012 and was able to deploy and process them. For your reference I am uploading the screenshots.
Partition created by using VS 2012
Patition in SSMS Cube Browser
Let me know if you need further details about my development environment.
Best regards...
I'm trying to create new partitions in my OLAP cube in Visual Studio 2012. The partition wizard appears and I go through all the steps. When I click finish, nothing happens. No error message and no partition is created. Is this a possible bug in the application. I'm updated fully. It just doesn't create the partition. I can create it in SSMS but not in VS2012. Any help would be appreciated.
Hi
I have the same issue. I have followed the links and tried every angle to add new partitions with vs 2012. The wizard shows up, every step is done, but nothing is added when confirming.
Iam running the project with TFS 2010 in SQL Server Enterprise SSAS Enterprise mode 11.0
Vs 2012 ver. 11.0.61030.00
SQL Server Data Tools 11.1.40706.0
/Michael
*EDIT: I worked around it and created them with SSMS and then reversed it back to a new project and copied the cube and partitionfile to the TFS project. Not a nice solution but it worked :-/
The SSDT Version you are using is a higher version than my dev environment. From where did you get "SQL Server Data Tools 11.1.40706.0"? I downloaded the SSDT and installed on VS2012 and still my environment is lower than yours. So it seems like an update to SSDT 2012 caused the issue.
Best regards...
Hi All,
I guess I figured out where the problem is. It is because of the incorrect SSDT version is installed for VS 2012. I downloaded the SSDT installation files from the following location;
http://msdn.microsoft.com/en-us/jj650015
This link will download the SSDT for SQL Server 2014 not SQL Server 2012 (I assume you all use SQL Server 2012). I fixed this issue by doing the following;
- Uninstall the existing SSDT from the Add Remove Programs.
- Remove all the installations related to SQL Server 2014 (I did this because I do not have SQL 2014 on my machine and therefore I uninstalled all the SQL 2014 installations.).
- Download SSDT 2012 from http://www.microsoft.com/en-ca/download/details.aspx?id=36843
- Run the Setup (As Administrator... This is what I do all the time)
- Select the options as in the following screen
After the installation restart your machine and Launch VS 2012 and create partitions. You should be able to create partitions using VS 2012 now.
Best regards...
I was having this problem yesterday in VS2013.
I applied the latest SSDT update via Visual Studio ..
Tools | Extensions and Updates | Updates
Tried the adding Partition add again and it's working now.
I don't have SQL2014 local either.
- Proposed as answer by Miami486 Tuesday, December 02, 2014 10:16 PM
I can confirm for VS 2013 the problem is rectified by peforming an Update to VS 2013 as this post indicates.
After doing this, I was able to create partitons in VS 2013 and deploy to SQL 2008 R2 SSAS Server.
Regards
Don
IS the solution you made stored on a TFS? I think whats common amount people experiencing this is that the solution is sourced in a TFS.
Just a thought.
This is definitely still an issue.
Here's what I have:
------------------------------------------------------------------------
Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51641
Installed Version: IDE Standard
Microsoft Visual Studio Tools for Applications 2012 04932-004-0017006-02501
Microsoft Visual Studio Tools for Applications 2012
Team Explorer for Visual Studio 2012 04932-004-0017006-02501
Microsoft Team Explorer for Visual Studio 2012
Visual Basic 2012 04932-004-0017006-02501
Microsoft Visual Basic 2012
Visual C# 2012 04932-004-0017006-02501
Microsoft Visual C# 2012
Microsoft Team Foundation Server 2012 Power Tools 3.0
Power Tools that extend the Team Foundation Server integration with Visual Studio.
Microsoft Visual Studio Process Editor 1.0
Process Editor for Microsoft Visual Studio Team Foundation Server
PreEmptive Analytics Visualizer 1.0
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 11.0.5058.0
SQL Server Data Tools 11.1.41025.0
Microsoft SQL Server Data Tools
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 11.0.3436.0
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 11.0.3436.0
BIDSHelper
BIDS Helper 2012 - An add-in to extend SQL Server Data Tools - Business Intelligence (SSDTBI formerly BI Development Studio)
(c) 2013 Version 1.6.5.0
http://www.codeplex.com/bidshelper
SQL Prompt 6
For more information about SQL Prompt, see the Red Gate website at
http://www.red-gate.com
For customer support, call 1-866-733-4283.
Copyright 20062009 Red Gate Software Ltd
------------------------------------------------------------------
Installation steps:
1) Installed SSDT via the SQL Server install (which only installs the VS2010 SSDT)
2) Installed SSDT for visual studio 2012
3) Installed Team Explorer for TFS
4) Installed Power Tools for TFS
5) Installed SSDT-BI file version 11.0.3360.12 dated 4/3/2013 (SSAS - 11.0.5058.0; SSIS - 11.0.3360.12; SSRS - Version 11.0.3360.12)
Tested partitions, didn't work
6) Installed SSDT-BI file version 11.0.3436.0 dated 6/26/2014 (SSAS - 11.0.5058.0; SSIS - 11.0.3436.0; SSRS - 11.0.3436.0)
Notice that the SSAS version did not change, but SSIS & SSRS did.
Tested partitions, didn't work. Aggregation designer never started and partition was never created.
Cheers All
Flattened my dev box and reinstalled OS (win 8.1), SS , VS, SSDT and the partitioning does not work. The Aggregation Wizard did not start after finishing the partition design. No partition created.
My environment
Microsoft Visual Studio Ultimate 2012
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650
Installed Version: Ultimate
Architecture and Modeling Tools 04940-004-0039002-02386
Microsoft Architecture and Modeling Tools
UML and Unified Modeling Language are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.
LightSwitch for Visual Studio 2012 04940-004-0039002-02386
Microsoft LightSwitch for Visual Studio 2012
Microsoft Visual Studio Tools for Applications 2012 04940-004-0039002-02386
Microsoft Visual Studio Tools for Applications 2012
Office Developer Tools 04940-004-0039002-02386
Microsoft Office Developer Tools
Team Explorer for Visual Studio 2012 04940-004-0039002-02386
Microsoft Team Explorer for Visual Studio 2012
Visual Basic 2012 04940-004-0039002-02386
Microsoft Visual Basic 2012
Visual C# 2012 04940-004-0039002-02386
Microsoft Visual C# 2012
Visual C++ 2012 04940-004-0039002-02386
Microsoft Visual C++ 2012
Visual F# 2012 04940-004-0039002-02386
Microsoft Visual F# 2012
Visual Studio 2012 Code Analysis Spell Checker 04940-004-0039002-02386
Microsoft Visual Studio 2012 Code Analysis Spell Checker
Portions of International CorrectSpell spelling correction system 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.
The American Heritage Dictionary of the English Language, Third Edition Copyright 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.
Visual Studio 2012 SharePoint Developer Tools 04940-004-0039002-02386
Microsoft Visual Studio 2012 SharePoint Developer Tools
NuGet Package Manager 2.0.30625.9003
NuGet Package Manager in Visual Studio. For more information about NuGet, visit
http://docs.nuget.org/.
PreEmptive Analytics Visualizer 1.0
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 11.0.5583.0
SQL Server Data Tools 11.1.50318.0
Microsoft SQL Server Data Tools
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 11.0.5583.0
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 11.0.5583.0
Web Developer Tools 1.0.30710.0
Microsoft Web Developer Tools contains the following components:
Page Inspector: Tool that offers an efficient way to decompose Web Applications and diagnose front-end issues.
Web Publishing: Extensions required for Web Publishing for both hosted servers as well as on premises.
Web Form Templates: Includes the default templates for Web Form Applications.
Editor Extensions: Includes HTML, CSS, and JS editor extensions that greatly enhance the development experience.
Hi All
I found workaround for this issue, not the best but at least works.
1)Deploy your SSAS Cube on your local SQL Server, let assume that your project is call "Project1"
2)Using SSMS create new partition for this cube
3)Import to VS your cube as new SSAS project (In VS you have option to import SSAS project from SSAS server)
and name it "Project2"
4)Now the tricky part.
Go to the Project "Project2" go the right click on the Cube and click "View code".
Copy this XML content and past to "Project1" Cube definition.
VS will refresh your project and partition will show.
This is the only way which prevent me from making mess in my TFM server.
Solved for me.
You just have to install the Microsoft ...Database ... update (I forgot the name, sorry).
In your SSDT (VS2012/VS2013), go to Tools --> Extensions And Updates -> Updates -> ...Database...
- Proposed as answer by Diane_L 13 hours 10 minutes ago