Using String Functions In MDX

[Former Member]

I am trying to modify an object in a universe built on BW using MDX. The object is [ZCALDAY2].[NAME]. The object brings back a list of dates yyyymmdd. I would like it to only bring back yyyymm ( and distinct values only). Is this possible?

I have tried <EXPRESSION>MID([ZCALDAY2].[NAME],1,6)</EXPRESSION> - no luck! Any help would be appreciated

Thanks

Tom

[Former Member · Accepted solution]

Not supported in BW