Nolt sure if this can be achieved because OBIEE gives only 4 datatypes with Essbase i.e. DOUBLE, INT, UNKNOWN, VARCHAR.
As you see Date or Timestamp types are not there...So, I do not think this is feasible.
Thanks for replying.
Any other idea? Any one?
Apart from the fact of reality that a measure (an account) does not make sense at all as "DATE" in analytical sense... A "MEASURE" measures something - i.e. counts, sums, averages.
So apart from that - what prevents you to CAST that in the BMM layer to whatever you want?