Analytics Software

Hi All,

I am trying to create report based on two fact column and one dimension. Dimension is connected with these two facts table. When i create report using one column from dimension and one column from respective facts so i get two scenerio...

For example let say..

D1 is dimension and F1 and F2 are two fact tables.
First i used a column which have aggregation rule from one fact and one column from other fact which also have aggregate column.
That is report like...

D1.c1,Agg(F1.c2),Agg(F2.c3)

When i run the report I get the data from dimension and only from first fact table. When i check the query, Query contain only one fact table and it doesnt hit the other one.

Now in second scenerio i used one column from dimension, one column from first fact which have aggregation rule and one column from second fact which doesnt have any aggregation rule.
like...

D1.c1,Agg(F1.c2),F2.c3


When i run the report i got the error. It says

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14026] Unable to navigate requested expression: F1 -C2 . Please fix the metadata consistency warnings. (HY000).

But there is no warning in RPD.

I am amazed that it is not taking both the fact columns even the dimension is confirmed dimension and have joined with both the fact tables.

As i am just started to learn OBIEE, So i am find it bit difficult that how OBIEE select the tables and formed physical query.

Waiting for your help.

Regards
Suhail