Hi Experts,
We do have quarter end date in table and we want to get previous quarter from there
we have 31/03/2017
30/06/2017
30/07/2017
31/12/2017
We need to calculate previous quarter as well YTD from the selected prompt created on this quarter ..how we can achieve this in OBIEE?
Also can we create time hierarchy on this data ? for two levels only Quarter and Year and then use time series function.