Symptom
You run the Financial Statement report and want to expand all G/L accounts as default every time the report is opened.
Environment
SAP Business ByDesign
Reproducing the Issue
- Navigate to Business Analytics work center.
- View Design Reports.
- Open Design and Assign Reports.
- Click Financial Statements.
- Enter the required parameters.
- Press Go.
You cannot view all the G/L accounts in the reports as a default view.
Resolution
To expand all Structure levels, you need to define hierarchy setting directly for the Balance Sheet And Income Statement Item:
- Navigate to Business Analytics work center.
- View Design Reports - Design and Assign Reports.
- Open the Financial Statements report.
- Enter the required parameters.
- Go to View option.
- Access the Characteristics Settings of the Balance Sheet And Income Statement Item (click the three little dots beside the characteristic and select Characteristic Settings).
- Choose an option from the Initial Expansion Level column under Characteristics in Rows.
- Under Hierarchy, in the Initial Expansion Level field select the expansion level of your choice (up to 10) or select Fully Expanded (up to 98 levels).
- Press OK.
- You can save the view by selecting View button and Save.
- Set the saved view as default by selecting the Set as Default button.
- Close and re-open the report and you should be able to see the report opening with the desired layout.
Keywords
Initial Expansion level; Financial Statements; Hierarchy level expansion; Fully Expanded; Report; , KBA , initial expansion level , financial statements , hierarchy level expansion , SRD-FIN-ANA , Analytics Content , How To
Product
SAP Business ByDesign all versions