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.
In answer or in a logical Sql
sum(max(1 by MyDim1.MyAttribute1, MyDim2.MyAttribute2, ....) by MyDim1.MyAttribute1, MyDim2.MyAttribute2, ....)
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'.