A customer is trying to build dynamic reports in Fusion Financial Reporting. What are two ecommendations?
A.
Use Function on expanded data segments that are NOT placed on separate rows or columns.
B.
Create reusable objects and row and column templates.
C.
Use cell formulas to write efficient formulas rather than row or column formulas.
D.
Use multiple data segments for formatting or calculating.
Explanation:
When designing dynamic reports, consider the following information:
l Use expanded data segments for optimal performance:
* Use functions on expanded data segments that are not placed on separate rows/columns (A)
* Use multiple member selections on expanded data segments that are not placed inseparate rows/columns
* Use single data segments only when required for formatting or calculations
2 Write efficient formulas:
* Use row/column formulas rather than cell formulas, when possible (not C)
* Use reference properties
* Use a cell reference instead of cross-axis references
* Remove unnecessary parenthesis from formulas
3 Don’t limit your report to the Grid object:
* Add functions in text boxes that highlight specific areas
* Hide a grid of data in a report to highlight just the graphics
4 Create report templates:
* Leverage the power of POVs and prompting functions
* Design once using the CurrentPOV and prompting functions
* Learn the power of Grid, User, Book, and Batch POVs
5 (B) Create reusable objects and row and column templates. Text, Image, Grid, Chart objects,
and row and column templates can be reused in multiple reports
O R A C L E H Y P E R I O N F I N A N C I A L R E P O R T I N G Studio, Fusion
Edition, User’s Guide, Recommendations for Designing Dynamic Reports