nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Time series measure turning into an attribute in Union Analysis

Saro

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

Find more posts tagged with

Accepted answers

All comments

asim cholas

What is the aggregation rule in both criteria?

Saro

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

asim cholas

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

Saro

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

Robert Angel

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

Saro

Hi Robert,

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

Regards,

Saro

Robert Angel

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

Saro

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

Robert Angel

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

Saro

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