Incorrect value in report using sum function OBI

3244578

Hi All,

Facing a weird issue in OBI

I have a metric and i want to create a % of total metric in OBI

so i created sum metric first to get the total values,but whenever i am creating that metric

it's getting very weird values (there is no pattern too in that values)

I looked into other posts but didn't found anything

Any idea how to fix this?

metric name: Hires

metric name: sum(hires)

Regards,

Akshat

Thomas Dodds

You need a level-based measure for the Total ... then you need a logical column that does   100*(Hires / Total Hires)

Department A hires = 10

Department B hires = 15

Department C hires = 5

Level based total =  30

Then if I filter that logical calculation for a department I expect:

Dept A % of Total = 100*(10/30) = 33

Dept B % of Total = 100*(15/30) = 50

Dept C % of Total = 100*(5/30) = 17

3244578

Hi Thomas,

How to create that level based measure?

i am new to OBI so little confused

Thomas Dodds

http://gerardnico.com/wiki/dat/obiee/measure_level_based

Thomas Dodds

or OBIEE 11G - Aggregate At Function [Gerardnico]  will do similar...

3244578

hey,

can't we create the same in OBI web?

i don't have access to it?

Also, i was working on another metric and was able to create that

reason being , the values appearing were like this

Column  Hires  Total

A                10     10

B                 20      200

C                    20    200

etc. so i created my sum metric and then divided by the orignal metric and getting correct reuslts

it's just this metric which isn't working on this logic

3244578

so using this approach?

how will my formula be?

do i need to include all my dimensions in the report

?

Thomas Dodds

try the AGGREGATE( AT ) - providing you have the dimensional hierarchies in place to support this. 

Learn Oracle and OBIEE: Aggregate at

NOTE:  I still encourage you to have the total measure and the % of Total built in the RPD ... build once use many.

3244578

Hi Thomas,

I literally didn't understood how to use aggregate function to resolve my issue

my metric now is : candidate counts. # apps

and i am trying to create sum(candidate counts. # apps)

but getting very weird values

i have around six columns in my reporting grid

Thomas Dodds

Are you using on-prem OBIEE or BICS (cloud)?

3244578

Hi Thomas,

I am using prem OBIEE

but have no access to RPD