how to Combine sub-reports columns into a master report?
I have to build a Report to show the monthly Compliance of Service Level Agreements using the raw data.
I need your suggestions about how to combine the partial values obtained by multiple sub-reports into a single compliance Value for each Agreement (if possible).
To evaluate the Monthly Compliance I should combine the values from 3 tables.
Records of one of those table do not have a column that may be used as join key, so this table cannot be included into a Data View with the rest of tables.
Considering Yellowfin BI features and approach:
1) Is it possible to create a calculated field combining the values of multiple sub-reports columns?
Simplifying, we basically need to calculate the compliance as pondered combination of partial values obtained by multiple reports:
Compliance % = Report 1 x related weight + Report 2 x Related weight + Report 3 x Related weight
2) Is it possible to create a Master report fed by other sub-reports?
I mean: is it possible to use a child column value into a Master report, or sub-reports can be only combined to create a Master Report (eg. As detailed report or drill-down report)
3) Is it possible to include a stand-alone table into a Data View?
4) can you confirm this sentence: all data required to build calculated field must be retrieved by a single query?
Any suggestion will be really appreciated!