Define the aggregation method for the metrics in you fact tables. See image below:
Home » Archive for category "BI & ETL"
OBIEE – Choosing the Database Connection Type
Always choose the connection type: OCI 10g/11g.