OBIEE - Calculation

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

1 - Pass-through

A Pass-through calculation is not computed by the Oracle BI Server but is passed to another data source. Enables advanced users to leverage data source features and functions without the need to modify the Oracle BI repository.

2 - How to calculate the number of rows for a combination ?

In answer or in a logical Sql

SUM(MAX(1 BY MyDim1.MyAttribute1, MyDim2.MyAttribute2, ....) BY MyDim1.MyAttribute1, MyDim2.MyAttribute2, ....)
Advertising

3 - How to create a attribute column to group the transaction all 5 minutes

evaluate(
  'TO_CHAR(TO_DATE(%1,''YYYY-MM-DD HH:MI:SS''),''YYYY-MM-DD HH:'') ||
  lpad(TO_CHAR((to_number(TO_CHAR(TO_DATE(%1,''YYYY-MM-DD HH:MI:SS''),''MI'')) 
  - MOD(to_number(TO_CHAR( TO_DATE(%1,''YYYY-MM-DD HH:MI:SS''),''MI'')),%2))),2,0)',
  CAST("D12 Call"."Start Tijd" AS CHAR) -- The time transaction
  ,'5' -- The time interval
)

In this case, the NLS_DATE_FORMAT must be set to 'YYYY-MM-DD HH:MI:SS'.