10 Replies Latest reply on Nov 1, 2017 4:41 AM by Saro

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.

Regards,

Saro

• 1. Re: Time series measure turning into an attribute in Union Analysis

What is the aggregation rule in both criteria?

• 2. Re: Time series measure turning into an attribute in Union Analysis

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

• 3. Re: Time series measure turning into an attribute in Union Analysis

Icons are changed in 12c for measures and non measures. is it not aggregating properly. Each criteria?

• 4. Re: Time series measure turning into an attribute in Union Analysis

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

• 5. Re: Time series measure turning into an attribute in Union Analysis

Can you push the logic for YTD into the rpd and try it?

• 6. Re: Time series measure turning into an attribute in Union Analysis

Hi Robert,

I tried that also, but it results in the same way of behaving like an attribute.

Regards,

Saro

• 7. Re: Time series measure turning into an attribute in Union Analysis

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'?

• 8. Re: Time series measure turning into an attribute in Union Analysis

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

• 9. Re: Time series measure turning into an attribute in Union Analysis

So often the keys are the answer when you get 'strange' behaviour....

• 10. Re: Time series measure turning into an attribute in Union Analysis

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