Thursday, August 31, 2006

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


No comments: