tag:blogger.com,1999:blog-6545695526051974540.post2520702895494224710..comments2023-02-20T02:49:43.236-06:00Comments on Everyday Essbase: Exporting Data using MDXTimFhttp://www.blogger.com/profile/05962713873726067372noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6545695526051974540.post-46613014861369705822015-08-24T02:06:22.814-05:002015-08-24T02:06:22.814-05:00cool post, thankscool post, thanksUnknownhttps://www.blogger.com/profile/06316078387624015564noreply@blogger.comtag:blogger.com,1999:blog-6545695526051974540.post-54606320428463111282015-08-19T09:06:14.417-05:002015-08-19T09:06:14.417-05:00@Kevin Kraft -- As a best practice I avoid using c...@Kevin Kraft -- As a best practice I avoid using commas in member names (maybe try to put them in aliases if they're really necessary?). I understand it's not always possible to live by that rule. If you change the following line from:<br />@columns = split /\,/, $1;<br />to<br />@columns = split /\, /, $1;<br />then it will handle a comma in a member name so long as it isn't followed by a space. I'm afraid there's no way to distinguish between a member with a comma and a space and what the MDX output gives you. I looked to see if there was a way to put quotes around member names (I think you can do that in Report Scripts) but couldn't find any.TimFhttps://www.blogger.com/profile/05962713873726067372noreply@blogger.comtag:blogger.com,1999:blog-6545695526051974540.post-83405795977275554062015-08-19T01:40:50.814-05:002015-08-19T01:40:50.814-05:00Really nice paper and script but not sure that peo...Really nice paper and script but not sure that people will prefer MDX export!srxhttps://www.blogger.com/profile/07171491730419232141noreply@blogger.comtag:blogger.com,1999:blog-6545695526051974540.post-83171103942388578192015-08-19T01:08:24.571-05:002015-08-19T01:08:24.571-05:00Great work, i tried the same using python but fail...Great work, i tried the same using python but failed with member names that have commas in it. Does your script handle that case?<br /><br />Greets<br />Kevin KraftAnonymoushttps://www.blogger.com/profile/12301775277571280020noreply@blogger.com