Keep in mind the following restrictions when using cross-subject analysis:
You can create a query joining only subject areas within your security access.
A cross-subject area query is limited by the underlying schema relationship and is only possible through common dimensions shared by the select subject areas.
Degenerate dimensions are not supported.
A “degenerate dimension” is a local dimension that exists only in the selected subject area. If additional attributes are added, the query does not return correct data.
Figure 94, Example of Data Results When Using Degenerate Dimension shows the incorrect data resulting from using the Worker Assignment Details dimension which exists only in the Worker Assignment subject area. Here, the Worker Assignment Details.Primary Flag attribute has been added, causing the column Count of Goals in Different Status with a Goal Plan to not display any data.
Non-conforming dimensions are not supported.
“Conforming dimensions” are those dimensions that exist in all subject areas selected for the query; thus a “non-conforming” dimension is one which does not exist in all subject areas selected for the query.
Figure 95, Example of Data Results When Using Non-Conforming Dimension shows the incorrect data resulting from adding Performance Goals.Performance Goal to the query. Because Performance Goals is non-conforming dimension, the column Head Count is missing data.
