OBIEE Usage Tracking Stopped Working 2016 - 11.1.1.7.140225 (Build 140209.2017

Gianni Ceresa

Ok, with no access to MOS the option you have is to create the data yourself.

In the end it's all around dates, so using a normal query and the functions Oracle provides to work with dates (to_char etc.) you can generate the same kind of data, it will maybe takes you half an hour but you can do it column after column.

As a beginning you can start by this:  select TO_DATE('20151231','YYYYMMDD') + LEVEL from dual connect by LEVEL < 1828;

It will return you all the days between 1.1.2016 and 31.12.2020.

dcb9a72e-f3dd-40b1-b716-19c122b9bee3

Ok I will try that solution, seems like a good start ! thanks a lot