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