Break distinct count measures into separate measure groups

יום רביעי, יולי 10, 2013

The  easier method to to this if you already have the measure group built is:Right click on the cube on the Cube Structure tab and select new measure. Then select DistinctCount as the usage, then your measure to count and it will automatically be created in a new Measure Group.
תגיות: ,
אין תגובות

Upgrade SSIS from SQL 2005/2008/R2 to SQL 2012

יום שלישי, ינואר 1, 2013

This post will describe whats new in SSIS 2012 and will touch on Upgrading SSIS Packages to SQL Server 2012. Whats New? I will show in this post whats new in several subjects: Deployment Management and Troubleshooting (follow me on future posts) Development Enhancements Performance (follow me on future posts) Data Quality (follow me on future posts) Deployment The type of deployment model that you choose for a project determines which development and administrative options are available for that project. The following table shows the differences and similarities between using the project deployment model and using the package...

Microsoft® SQL Server® 2012 SP1 Feature Pack

יום ראשון, דצמבר 16, 2012

To better run EXCEL against SQL 2012 SSAS, Please download the following: Microsoft® SQL Server® 2012 SP1 ADOMD.NET ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2012 SP1 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.Note:The English ADOMD.NET setup package installs support for all SQL Server 2012 languages. Filename: X86 and x64 Package(SQL_AS_ADOMD.msi)Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012 SP1 The Analysis Services OLE...
אין תגובות

ssis connection manager not storing sql password

  The designed behavior in SSIS is to prevent storing passwords in a package, because it's bad practice/not safe to do so. Instead, either use Windows auth, so you don't store secrets in packages or config files, or, if that's really impossible in your environment (maybe you have no Windows domain, for example) then you have to use a workaround as described in http://support.microsoft.com/kb/918760 .The simplest answer is a config file to go with the package, but then you have to worry that the config file is stored securely so someone can't just read it and take the credentials....
אין תגובות

Microsoft® SQL Server® 2012 PowerPivot for Microsoft® Excel® 2010

יום שני, נובמבר 12, 2012

Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010.Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love — Microsoft Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. You can: Process large data...
תגיות: , , ,
תגובה אחת

SQL Server Data Tools – November 2012 is now available!

יום חמישי, נובמבר 8, 2012

Get it here SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015 SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014 What's new? Selective XML Index support We've added support for selective XML indexes, enabling users to import, edit, add, refactor, build, and publish selective XML indexes in SSDT. Add new selective XML index in Table Designer Check for SSDT Updates This release adds support for automatic and manual checks for SSDT updates. You can view information about your current SSDT installation and verify that it's up to date by selecting "Check for Updates…" under the top-level SQL menu in Visual Studio. Check...
תגיות: , , , ,
אין תגובות

SQL Server 2012-RTM demo

יום שבת, אוקטובר 20, 2012

The new SQL Server 2012-RTM demo is fully integrated with SQL Server 2012, SharePoint 2010 and Office 2010 including: PowerPivot and MDS Excel integration Reporting Services integration with SharePoint Power View integrated with SharePoint Data Quality Services Master Data Services Multidimensional and Tabular instances of SQL Server 2012 Analysis Services Visual Studio 2010 Silverlight 5 Picnic Power View sample loadedThis image also includes demos of the RTM version of AutoSales, TailspinToys, Contoso Energy, Telco (PowerPivot and Power View), Contoso Schools and the Telco demo. You can  download the Virtual...
תגיות: , , ,
אין תגובות