PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against tabular data sources such as SQL Server tables, SharePoint Lists, Excel Services, Import From Excel Workbooks, and even PowerPivot (with … Continue reading →
I have come across a number of tips while using MDS. These are tips not big enough for their own blog post, so I list them all here: To “hide” an attribute in the MDS Excel add-in, set the pixel … Continue reading →
As a 1099 consultant, I usually use a placement firm to find a contract job. I always ask the placement firm what rate they are billing the client. They usually tell me. When they don’t, it’s a sure sign that … Continue reading →
Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment to a QA environment. Below is some helpful tips if you need to do the same, along with details on … Continue reading →
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for a complete list. Enjoy!
Continue reading →There are five different way to interact with Master Data Services (MDS) to do things such as create a model, load data into MDS, manage business rules, versioning, etc. Master Data Manager Web User Interface (“UI”), also called the Master Data Manager Web … Continue reading →
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error: “Cannot insert the value NULL into column ‘Code’, table ‘MDS2012.mdm.tblStgErrorDetail’; column does not allow nulls. INSERT fails.” As described in … Continue reading →
UPDATE on 11/28/2012: I had this same error when trying to delete a model. Fortunately, SQL Server 2012 SP1 has fixed this bug! In Master Data Services (MDS), when trying to delete an attribute in an entity, I received the … Continue reading →
In Master Data Services (MDS), you can use the Master Data Manager Web User Interface “UI” to copy a version of a model and create a new version of it (via the Version Management screen). However, you may find the “Copy” … Continue reading →
In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch a staging table, which will load data from the staging tables into the appropriate MDS tables: [Execute SQL Task] Error: … Continue reading →
Here are some of my favorite Master Data Services (MDS) resources: SQL Server Master Data Services Utilities: A set of useful add-ons for SQL Server Master Data Services, including utilities for generating an MDS model, loading the model, writing a … Continue reading →
Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free! Get your learning cap on. Check them out here.
Continue reading →SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225). The SSDT team is committed to delivering regular, frequent releases of SSDT, and this is the first in a long line of updates. This … Continue reading →
In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member attributes” box on the “Edit Entity” screen is too small. It only fits four rows. This can be very annoying … Continue reading →
In Master Data Services (MDS), you can create multiple versions of the master data within a model. When you create a model for the first time, MDS creates a default initial version of your model data. You can create as many … Continue reading →
When moving from a data warehouse world to MDM, there is some new terminology to learn. Each of the terms below are components of a Master Data Services model. For details about Data Warehousing Visit us touroftoowoomba . In brackets … Continue reading →
I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and really like the product. Through my use of it I have learned some tips and tricks that I will share … Continue reading →
The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based on data in a source table in one easy statement, replacing lots of messy code. I use it frequently when … Continue reading →
With SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to use SharePoint 2013 instead of SharePoint 2010. If you would like to get a head start on learning what is new with SharePoint … Continue reading →
On July 16, 2012, Office 2013 Preview was released to the public (download). Excel 2013 now includes a lot of the SQL Server BI components directly in the initial install, as well as enhancements made to the business intelligence (BI) capabilities … Continue reading →