OBIEE: How to compute a number from two separated tables?

Iliaa

I want to create an analysis in OBIEE 11g showing a number in a Tile view. Logically, this number is derived from two separated tables, say T1 and T2.

In Edit Formula section of the "T1"."ID" column in Criteria section I've tried it something like the below ...

COUNT("T1"."ID") / (COUNT("T1"."ID") + COUNT("T2"."ID"))

but instead of the calculated number, it shows the above query as result table header and zero as result value.

I think it may be due to the fact that there is no relation between two tables. So, I decided to compute the Sum of the rows of these tables as a "calculated item" column in Facts logical table in BMM layer of .rpd.

I read some tutorial about it and also I see some calculated item in the rpd of SampleApp, but my calculated item (which is defined on T1 and T2 with "Count" or "Count Distinct" value as the "default aggregation rule" ) only shows the aggregated value of the first source table, i.e. Count of the rows of the first table. Now, I think "calculated item" is another thing than what I have assumed before. I think it is just a rule that can be defined on multiple source table and in runtime, i.e. in analysis, it performs the defined rule just on the specified column or columns separately.

I want to know that how can I create this analysis?

Any help will be appreciated.

SriniVEERAVALLI

No need to read anything and try to work on database query to get your output data

once you done let me know I'll guide next steps.

BI cant get anything which is not related to existing fact table