Hi,

I am trying to build a basic report with one dimension  (lets assume it to be location) and 2 metrics from 2 facts (F1,F2) and location is a confirmed dimension.

I am missing values from either one of the fact for some rows in the report.

I have checked the sql and it gives right results,but i am not seeing the same results in the report.

I have created hierarchy for location dimension and made location_key as primary key and location_name as display key  for location level.I have just added location number to this level (it is not primary key nor display key)

when i use location number i dont see values form either one  of the fact and when i use display key i see all the values.

is this a bug in obiee 12c or am i missing something? do i need to use display key always to combine results from 2 facts.

This does not happen always ,it will sometimes show  numbers.

I have just attached samples :

location dimension:

Location_Key  Location_Number   Location_Name

10                             10                         California

20                             20                         ohio

30                             30                         virginia

expected result :

location_number     F1.metric       F2.metric

10                               25                   50

20                              17                   19

30                               10                   48

result i am seeing:

location_number     F1.metric       F2.metric

10                               25                   50

20                                                      19

30                               10                   48

result when i use display_key:

location_number     F1.metric       F2.metric

california                       25                   50

ohio                              17                   19

virginia                         10                   48