OBIEE - Calculation


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.

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, ....)

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

  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'.

Powered by ComboStrap