nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to implement time series function without time hierarchy

3123015

Hi All,

Please let me how to implement time series functions(Ago,TO_DATE) without time hierarchy with case when or with other methods ?

Thanks,

Aritra Sen

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Wow you really wrote your heart out here :-)

cesar.advincula.o

First I agree with both of you, OLAP Option is a new technology, and has extra cost, for that reason I give the information about extra cost and this a new technology. Return to your comment, Cloudera? OK dont know why is your point being sarcastic? " The cons is that if you want a "1 month ago" and a "1 year ago" figure you need to build it separately (not a unique setup for all the timeseries calculations but a different alias with it's own joins for each different timeserie needs). " I take the advice of gianni and wait for Aritra Sen say to us.

Manoj Dixit

When I did a Google search, I found this: http://obiee100.blogspot.co.uk/2011/07/period-comparison-without-time-series.html

Is there any particular reason for not creating a time hierarchy? Perhaps an issue described here? https://greatobi.wordpress.com/2012/11/09/tuning-time-series-metrics/

Ignoring time series, a hierarchy will still be useful in drilling up and down through years, quarters, months, weeks (weekends! ☺) and days?

My 2 cents.

Regards.