OBIEE AGO and TODATE Series

Have a look a these two tables:

Let's create a MONTH_YEAR_AGO Column:

Have a look at the result:

....some thing is not right here....

Let's investigated the date dimension:

Looks alright? Have a look again without year and month:

We have a sorting issue here, so let's add a sorting column:

OK that's fixed, let's go back to our report:

Still a problem there, let's sort the chronological key:

That really fixed the problem!

Till Next Time

OBIEE Sort Order Column property

A customer had the following problem with his dates dimension:

The month year part of the date dimension wasn't sorted in the right way. He forgot to assign a sort column (format ('YYYYMM')):

The preferred result:

Till Next Time