OTBI Cross Subject Area analysis
Summary
I just attended your 2/23 OTBI training and trying to do a cross subject area analysisContent
I'm trying to build a utilization report. Standard working hours and frequency are available in Workforce Management - Person Real Time and actual hours by week and billability are available in Project Costing - Actual Costs Real Time for an employee.
I've built both separately from each subject area, now I'm trying to combine and get errors.
Query is as follows:
SET VARIABLE ENABLE_DIMENSIONALITY=1;
SELECT OuterQuery.s_1, OuterQuery.s_, OuterQuery.s_6/OuterQuery.s_2
FROM
(
(SELECT "Workforce Management - Person Real Time"."Worker"."Employee Name" s_1,