2 Replies Latest reply: Mar 13, 2012 11:24 PM by Zahid Yener RSS

Universe on BW Query How to change 0calmonth MMYYYY into YYYYMM

Martin Thomas
Currently Being Moderated

Hi

I created an universe using a BW Query. I want to use it to load a BO Explorer  Infospace. I'm using the time characteristic 0calmonth. If I load the Infospace, 0calmonth is shown in the fomat MMYYYY.   I need it in the format YYYYMM because I want to  sort it. Unfortunately it seems that there are no string functionaity for OLAP-univerese.

 

Has anyone a solution for my problem?

 

best regards Thomas

Actions