Problem with char to integer
Alex1Jan 15 2009 — edited Jan 22 2009Hi!!
I would like to get the integer that belongs to my month dimension.
So In criteria tab I choose my month dimension and I apply ascii formula.
ASCII("Dim Date".Month) and when I go to see results obiee don't return to me twelve numbers (one of each month)
else only return this:
65 August and April
68 December
69
70
74 June and July
77
78
79
83
Is like that only get the first letter...
And for example if I click on 65 appear August and April. Is there any possibility to return to me a unique number for each month????
Thank you!!