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, Impo...

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 width to “0″ If you make a chang...

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 their markup is excessive (but note somet...

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 a bug I ran across. Use the Mod...

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! ...

There are four 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...

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’...

In Master Data Services (MDS), when trying to delete an attribute in an entity, I received the following error: “Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an ex...

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” icon on...

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: Executi...