OTBI Cross Subject Area analysis

Summary

I just attended your 2/23 OTBI training and trying to do a cross subject area analysis

Content

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,