Time series analytics functions built into Semantic Layer
I would like that time series analytics functions are built into the semantic
layer - to dramatically speed up analytics for faster and more complex real-time and historical analysis
Will the universe designer have Time series analytics functions like AGO, TODATE as found in OBIEE/Microstrategy semantic layer (OBIEE Admin)
Like Year to Date, Year Ago. Functions like TODATE and AGO functions found in OBIEE semantic layer (siebel analytics). It was just simple there, I had to use the function on the semantic layer and BI server would raise the query to get the answer.
OBIEE issues time-series queries, in the form of AGO and TODATE. AGO gives you, for example, the value of sales one month ago or one quarter ago, whilst TODATE gives you the total of sales month-to-date, or quarter-to-date, or year-to-date. Both of these time-series functions rely on the existence of a time dimension in your business model and mapping layer, with the period you can refer to in the AGO and TODATE functions being determined by what levels you have in this time dimension.
This eliminates the need to create and store complex time-based reporting tables.