blogs.conchango.com

I have been keeping a close eye on machinations in the SQL Server Data Services (SSDS) arena and whilst the product hasn't reached the masses yet (I'm still waiting for my beta invite - hint hint) there is a still a lot of activity going on. There is a very active blog called The Long Term Storecast ...

If you are making changes to a linked object measure group after you have created the initial link, such as adding a new measure, you can come across the following error when you next deploy the solution. "Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against ...

On the off chance you haven't come across this one before: If you get the following error 'No mapping between account names and security IDs was done' when trying to deploy a cube project then check the membership of all the roles on your cube. Chances are one of the users listed has actually been removed from the Domain. Simply ...

I suspect that many of you have already come across this in your day to day MDX'ing but just in case: The standard YTD function only works with the Year level of Time hierarchies when the Attribute Type is set in the Basic Properties section to type Years. If you have a Fiscal Hierarchy in your Time dimension and have the Type set to ...