Unique Entity Names in MS SQL Server Analysis Services

Posted Thu, 29 Sep 2005

I'm reading up on MDX for work, specifically with respect to Microsoft SQL Server and Analysis Services. I just wanted to post a quote from MDX Solutions with Microsoft SQL Server Analysis Services and then not comment on it any further.

Tip: Although it won't occur in every database, it is possible (in Analysis Services) for two members in a dimension to have exactly the same unique name... If you query for a member using it's "unique" name that is not unique, all the members that share that unique name will be returned. The key-based naming ... can be used to avoid this happening.

In MDX a unique name is an automatically generated identifying attribute of an entity. Apparantely Microsoft failed to understand this entirely.

Related Stories

Related Books

Modern Database Management (9th Edition) MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase Database Systems: Design, Implementation, and Management, Eighth Edition Fast Track to MDX Fundamentals of Database Systems (5th Edition)

Post a Comment




About

My name is Tim Fanelli, I am a software engineer in Northern NY. I spend most of my time working, and when I can, I try to post interesting things here.

Cigar Dossiers