This content has been marked as final. Show 7 replies
When the time dimension's chronological key is incorrect, there would generally be issues during time series functions usage. So, just check your chronological key for the lowest level in your period hierarchy if was set properly or not.
Hope this helps. If you are still unable to get it, please post more details of your hierarchy design, the period dimension sample data.
Can palce your ago function expression?
Ago(<<Measure>>, <<Level>>, <<Number of Periods>>)
Ago("Sales"."Base Measures"."Dollars" , "Sales"."Time MonthDim"."Quarter" , 1)
For more refer,
Let me know if it is resovled or not?
thank you for ur reply
i tried this way but same problem
for quarter ago i get previous year current quarter (
but i need previous quarter in the current year
how to find this
my ago function is
To understand your period dimension better, post some sample data of it and also your current dimensional hierarchy in OBI.
my hierarachy is level based
month--jan-11,feb-11,mar-11,apr-11 --like this
for quarter ago i get previous year quarter
but that get previous quarter current year
please see this