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
