Advanced Reporting and Reports and Jobs Are Rendering Different Result

Document ID : KB000099872
Last Modified Date : 23/07/2018
Show Technical Document Details
Issue:
When I run reports in both "Advanced Reporting" and "Reports and Jobs" they are rendering different results for the same reports, using the same parameters. 

Steps To Reproduce in Advanced Reporting:
1. Access the Financial Budget vs. Forecast by Period Detail report within Advanced Reporting
2. Run the report with the follow Options populated:
a. Investment
b. Financial Plan Type
c. Fiscal Year
d. Fiscal Period Type
e. Report Currency
f. Investment Type
g. Financial Plan Group By 1  
h. Financial Plan Group By 2

Expected Result: The Financial Budget vs. Forecast by Period Detail report is run successfully with column/row headers populated correctly
Actual Result: The Financial Budget vs. Forecast by Period Detail report is run successfully with column/row headers populated correctly

Steps To Reproduce in Reports and Jobs:
1. Access the Financial Budget vs. Forecast by Period Detail report within Advanced Reporting
2. Run the report with the follow Options populated:
a. Investment
b. Financial Plan Type
c. Fiscal Year
d. Fiscal Period Type
e. Report Currency
f. Investment Type
g. Financial Plan Group By 1  
h. Financial Plan Group By 2

Expected Result: The Financial Budget vs. Forecast by Period Detail report is run successfully with column/row headers populated correctly
Actual Result: The Financial Budget vs. Forecast by Period Detail report is run successfully, but some column/row headers say "Undefined"
Cause:
If the Cost Plan "group by" (Grouping Attribute) does not match the Reporting "group by" (Options: Financial Plan Group By 1 and 2) then columns may display "Undefined" within the report.
Resolution:
It must be confirmed that the "group by" found in the Cost Plan > Properties page matches those of the "group by" report parameters in "Reports and Jobs".