Skip to Content
avatar image
Former Member

0calmonth 200608 to be displayed as august 2006

hi gurus

here is an issue on Reporting.

0calmonth in the cube level must be like200608 but when i do reporting on the

cube it should be displayed in the report as August2006 in the results

i tried to display as key and name for 0calmonth,but its not working.

let me know the possible solution

points will be assigned

regds

preethi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 17, 2007 at 10:45 AM

    Hi,

    Using the text variable you can get the text display, you can create a text variable with processing type as replacement path and select the option Name(text), you will get the output.

    Regards,

    Siva.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 10:51 AM

    thnks for your reply

    using text variable i can only diplay as a heading

    but in my result rows say i got 200608 august 2006

    200203 as february 2002 like this i got plenty in my column of 0calmonth

    i want to display like this format.....

    regds

    preethi

    Add comment
    10|10000 characters needed characters exceeded