calculations from different tables

building reports webintelligence
1

Hi Guys,

I have a scenario where my report includes only calculations based on objects from different fact tables.Each column in a report includes different calculations.If i include the obj’s from different fact tables in the where clause its giving me an incompatible error
eg.[measure]where(F1.obj=“ABC” and F1.obj1=“XXX”)this is validating correctly.
If i use [measure]where(F1.obj=“ABC” and F2.obj1=“XXX” and F2.obj2=“DDD”)this giving me an incompatible error.
Can’t we use obj from different fact tables in where clause?How to solve this?

Knr123 (BOB member since 2011-05-08)

2

Are the tables in different contexts? If so select the option “allow selection from multiple contexts” under SQL to enable selection from the different fact tables.
However, exercise caution. Are the two act ables at the same level of aggregation and will the objects if merged give a meaningful result?
See this post:
https://bobj-board.org/t/1057/1

Uvee :uk: (BOB member since 2005-10-26)