Thursday, August 31, 2006 - Posts

User and Attribute Hierarchy issues [Reed]


There are a couple interesting threads going on in the MS forums on attribute hierarchies vs user hierarchies. I added some long-winded comments to this one: http://forums.microsoft.com/MSDN/AddPost.aspx?PostID=560583&SiteID=1

-- Reed Jacobson


posted Thursday, August 31, 2006 8:05 PM by RJacobson with 0 Comments

New Style and Old Style Calculated Member commands [Reed]


Chris Webb posted an interesting observation about a new style for calculated members in scripts, where instead of

CREATE MEMBER CURRENTCUBE.[MEASURES].[Old Style] AS 1, VISIBLE = 1

you can just say

CREATE [New Style] = 1;

He points out a "bug" with the old style syntax. I added some comments relating to some experiments he inspired me to do. My conclustion is that it's too predictable a behavior to be a real bug, but if MS wants to call it a bug, that's OK; and in any event, it might be worth being aware of, especially if you mix script assignments with calculated members. Here's the link to his July 2006 blog page:

http://cwebbbi.spaces.live.com/?partqs=amonth%3d7%26ayear%3d2006&beid=cns!7B84B0F2C239489A!823&d=1&wa=wsignin1.0

-- Reed Jacobson


posted Thursday, August 31, 2006 5:04 PM by RJacobson with 0 Comments