Embedded Analytics: Downloading to Excel and Printing



The Pennsylvania State UniversitySIMBA Hands-On Guide TITLE \* MERGEFORMAT Embedded Analytics: Downloading to Excel and Printing? 2020 The Pennsylvania State University? Copyright 2020 Labyrinth Solutions, Inc. All rights reserved. Labyrinth Solutions, Inc., the LSI logo, and CampusOneTM are trademarks of Labyrinth Consulting, Inc. SAP, R/3, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.Embedded Analytics: Downloading to Excel and Printing?Description:Reports can be exported as an Excel file. Choosing the Export As option will provide the ability to include filters that were previously added. Once the report is exported, it can be opened and printed.Process Steps?GL Balance Report - Google Chrome StepActionThe Fiscal Year is written as the closing year. This is a general accounting practice.1.2020 is typed into the Fiscal Year field.? StepActionPenn State's fiscal year runs from July 1 of the current year to June 30 of the next year. The number 1 represents July which is the first month of the fiscal year. The number 12 represents June which is the final month of the fiscal year. The numbers 13, 14, 15, and 16 represent special periods for closing entries in preparation for the financial statements.2.1...16 is typed into the Fiscal Period field.3.10000000 is typed into the G/L Account field.?GL Balance Report - Google ChromeStepAction4.The Go button is clicked.?GL Balance Report - Google Chrome StepActionTo view further details on a line item, you can double-click the line item number. ?Note:?Double-clicking on the field will take you away from the GL Balance Report and will open the GL Transaction Report.5.The 10000000?line item?is double-clicked.?GL Transaction Report - Google Chrome StepActionThe GL Transaction Report is now open.6.The Export to Spreadsheet button is clicked.?GL Transaction Report - Google Chrome StepActionSystem Status Bar Confirmation:? StepActionYou can now open the Excel Workbook and print the data.?Disclaimer?Alternative Format Statement This publication is available in alternative media upon request.??Statement of Non-Discrimination The University is committed to equal access to programs, facilities, admission, and employment for all persons. It is the policy of the University to maintain an environment free of harassment and free of discrimination against any person because of age, race, color, ancestry, national origin, religion, creed, service in uniformed services (as defined in state and federal law), veteran status, sex, sexual orientation, marital or family status, pregnancy, pregnancy-related conditions, physical or mental disability, gender, perceived gender, gender identity, genetic information, or political ideas. Discriminatory conduct and harassment, as well as sexual misconduct and relationship violence, violates the dignity of individuals, impedes the realization of the University’s educational mission, and will not be tolerated. Direct all inquiries regarding the nondiscrimination policy to Affirmative Action Office, The Pennsylvania State University, 328 Boucke Building, University Park, PA 16802-5901; Email: aao@psu.edu; Tel: 814-863-0471. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download