tag:blogger.com,1999:blog-7650953985627040991.post5116545318023330506..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Stupid Programming Tricks #14 -- SET EMPTYMEMBERSETS ON doesn't work they way you might thinkCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7650953985627040991.post-40541711787253243132012-11-08T06:47:11.484-05:002012-11-08T06:47:11.484-05:00Great explanation. I'm actually on the 'n...Great explanation. I'm actually on the 'nester' side of the debate, by the way, but I guess I don't express myself clearly on OTN! I hope your request to have the doc updated bears fruit.TimGnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-70919261202596548262012-11-01T11:45:18.180-04:002012-11-01T11:45:18.180-04:00I don't know why I even wrote that comment abo...I don't know why I even wrote that comment about using AND in the FIX.<br />The script that i was working was using two attributes (which are attached to same dimension) and had an AND in the fix.<br />I think (and only that) could be the reason why i said it works with AND!!!!<br />My badAnonymoushttps://www.blogger.com/profile/13298318501635970708noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-23516174866010415592012-10-31T13:04:51.193-04:002012-10-31T13:04:51.193-04:00This is an eye opener, however when i feel that i&...This is an eye opener, however when i feel that i'll hit an empty set i use AND in my FIX statement<br /><br />FIX(@DESCENDANTS("East") AND @DESCENDANTS("100-10")) which works fineAnonymoushttps://www.blogger.com/profile/13298318501635970708noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-48635797878703195682012-10-31T05:46:01.658-04:002012-10-31T05:46:01.658-04:00Dear Anon,
Yes, SET EMPTYMEMBERSETS ON refers to ...Dear Anon,<br /><br />Yes, SET EMPTYMEMBERSETS ON refers to FIX statements. But the issue is that SET EMPTYMEMBERSETS ON works *differently* when the dimensions are in separate FIX statements than when they are in a combined FIX statement. <br /><br />We are told (well, or we erroneously think) that there is no practical difference between nested FIX statements and single FIX statements. And there isn't, but not when it comes to SET EMPTYMEMBER SET. Which is pretty huge in my book -- I must ALWAYS use nested FIX statements if I think there is *any* chance of an empty set occurring.<br /><br />Regards,<br /><br />Cameron LackpourCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-28491614739753981912012-10-31T05:40:05.837-04:002012-10-31T05:40:05.837-04:00Isn't is as simple as remembering that a [EMPT...Isn't is as simple as remembering that a [EMPTYMEMBER]"SET", is referring to a FIX statement? If you have included @DESCENDANTS("East") in your FIX, it will not be empty... regardless of what else you have in it. Do I oversimplify?Anonymousnoreply@blogger.com