Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Time series measure turning into an attribute in Union Analysis

Hi friends,
Im in obiee 11.1.1.7.150120
When i create a YTD for my measure column named Forecast with below formula, i can see the aggregation(yellow mark) appears to it like below
ifnull(TODATE("Fact_GL_balances"."Revopex BI Forecast", "Dim2_GL_periods"."2-Time"."Year"),0)
Suppose if i do the union analysis for my same measure column Forecast like below, it is turning into an attribute column(no yellow mark) and not behaving like a measure column
What could be the reason for the time series measure not appearing as a measure columns in the union analysis.
Is this expected behaviour and is there any soln for this problem.
Thanks in advance.
Regards,
Saro
Answers
-
What is the aggregation rule in both criteria?
0 -
Hi Asim,
In my formula ifnull(TODATE("Fact_GL_balances"."Revopex BI Forecast", "Dim2_GL_periods"."2-Time"."Year"),0), i have my Forecast column with an aggregation rule of sum in both criteria.
Regards,
Saro
0 -
Icons are changed in 12c for measures and non measures. is it not aggregating properly. Each criteria?
0 -
Hi Asim,
Yes it is not aggregating properly in the union analysis. This is happening only for the time series measures(That too in the union analysis). But for the measure without any time series formula it is working fine. What could be the issue with the time series measure in the union analysis.
Regards,
Saro
0 -
Can you push the logic for YTD into the rpd and try it?
0 -
Hi Robert,
I tried that also, but it results in the same way of behaving like an attribute.
Regards,
Saro
0 -
Have you looked at the physical sql to see what is happening there?
Is your answers presentation table, as opposed to pivot, where there can be extra logic applied over and above the 'base logic'?
0 -
Hi Robert,
The problem is because of wrong formation of time series calculation. After correcting the time dimension with the proper chronological key, the measures are appeared fine.
Thanks,
Regards,
Saro
0 -
So often the keys are the answer when you get 'strange' behaviour....
0 -
w.r.t to time series for its abnormal behaviour, the wrong formation of chronological key is the main reason in my case.
Regards,
Saro
0