Hi,
Is there function to covert "1", "3","12" to "01", "03", "12" in MDX.

If this is a value formatting issue, you can use the FORMAT_STRING
property with "0" numeric placeholder:

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agmdxadvanced_2aur.asp
The following table identifies the characters that can appear in the
format string for number formats.

Character Description

0 Digit placeholder. Displays a digit or a zero.

If the expression has a digit in the position where the 0 appears in the
format string, it displays the digit. Otherwise, it displays a zero in
that position.
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!