Working With Financial Reporting For Oracle Enterprise .

2y ago
58 Views
2 Downloads
699.73 KB
103 Pages
Last View : 2m ago
Last Download : 2m ago
Upload by : Nora Drum
Transcription

Oracle CloudWorking with Financial Reporting for OracleEnterprise Performance Management CloudE96239-17

Oracle Cloud Working with Financial Reporting for Oracle Enterprise Performance Management Cloud,E96239-17Copyright 1989, 2021, Oracle and/or its affiliates.Primary Author: EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,any programs embedded, installed or activated on delivered hardware, and modifications of such programs)and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Governmentend users are "commercial computer software" or "commercial computer software documentation" pursuantto the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such,the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works,and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloudservices are defined by the applicable contract for such services. No other rights are granted to the U.S.Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registeredtrademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will notbe responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.

ContentsDocumentation AccessibilityDocumentation Feedback1About Financial Reporting2Using the Explore RepositoryAbout the Explore Repository2-1Using a Single Instance of the Explore Repository2-2Personalizing the Explore Repository2-2Resizing the Masthead2-2Resizing the View Pane2-3Displaying Columns2-3Reordering Columns2-3Sorting Columns2-3Displaying Specific File Types2-3Managing ItemsSupported Items in the Explore ng Files2-5Other Standard Files2-6Folders2-6Using Ambiguous Items2-6Importing Items2-6Importing Files2-6Importing URLs2-6Importing Financial Reporting Artifacts2-7Importing Financial Reporting Documents2-7Exporting Items2-8iii

Exporting Use Cases2-8Exporting Financial Reporting Artifacts2-8Exporting Financial Reporting Reports and Snapshots to Microsoft Office2-8Creating Shortcuts2-9Creating Email Links to Repository Items2-10Selecting Recipients to Receive Emails2-11Managing Files and Folders2-11Accessing Files or Folders2-11Opening Files or Folders2-11Opening Files Using Menu Options2-11Opening Financial Reporting Files in Another Format2-12Saving Financial Reporting Files2-12Creating Folders2-12Moving or Copying Files and Folders2-13Renaming Files or Folders2-13Deleting Files or Folders2-13Using Favorites2-13About Using Favorites2-13Adding Items to Your Favorites2-14Managing Favorites2-14Using Subscriptions2-14Creating a Subscription2-14Modifying or Removing Subscriptions2-15Subscribing to Folders2-15Receiving and Viewing Subscriptions2-15Using URLs in the Explore Repository2-16Opening a URL2-16Opening a URL in a New Window2-16Updating a URL2-16Searching for Items in the Repository2-16About Searching2-16Searching for Documents and Reports2-17Using Advanced Search2-17Search Syntax2-18Supported MIME Types2-20Security2-21Search Results2-21Using Smart View2-22Installing Smart View From the Explore Repository2-22Exporting to Smart View2-22Using Smart View to Import Financial Reporting Content2-23iv

Setting PermissionsAbout Setting Permissions2-24Defining Permissions for Files and Folders2-25Applying Permissions to Artifacts in a Folder2-25Working with Properties3452-242-26Setting File Properties2-26General Properties2-27Advanced Properties2-27Changing Ownership of Artifacts2-27Setting Preferences for Financial ReportingSetting Financial Reporting Preferences3-1General Financial Reporting Preferences3-1Reporting Studio Preferences3-3Managing Database ConnectionsDatabase Connection Manager4-1Adding and Editing Database Connections4-1Logging On to Database Connections4-2Database Connection Properties4-2Selecting an Application and Database Name4-2Editing Database Connections4-3Deleting Database Connections4-3Changing the Database Connection4-3Overview of Financial Reporting Web StudioAbout Files, Folders, and Documents in the Explore Repository5-1Creating Documents5-1About Books5-1Types of Books5-2Book Point of View5-3Book Output5-3Creating Books5-3Considerations When Creating Books5-3Creating a Book5-4Setting Book Properties5-5Behavior of Related Content in Books5-6Processing Behavior of Hyperlinks and FRExecute5-6Adding a Table of Contents5-9v

Setting Table of Contents Text5-9Adding Heading Text to a Book's Table of Contents5-10Customizing the Table of Contents5-10Adding a Cover PageAdding Reports and Documents to Books5-125-12Adding a Report to a Book5-12Adding a Document to a Book5-13Using Microsoft Word Documents in Books5-13About Using Microsoft Word Documents in Books5-13Creating Hyperlinks in Microsoft Word5-13Using FRExecute to Embed Financial Reporting Reports into MicrosoftWord and HTML Documents5-14Printing Text Files5-16Setting Up the User Point of View for Financial Reporting DocumentsWorking with Members5-165-17Selecting Members for a Document in a Book5-17Limiting the Members That Can Be Selected5-18Selecting the User Point of View as a Member in the Book Point of View5-19Assigning Members Using Functions5-19Selecting Multiple Members Based on Criteria5-20Searching For Members5-21Changing Page Members5-21Changing Members for Grid POVs5-22Copying Members from One Report to Another5-22Previewing Selected Members5-22Removing All Members from a Report or a Book5-22Opening, Renaming, and Saving Books5-23Opening Books and Snapshot Books5-23Renaming Books and Snapshot Books5-23Saving Books5-24Viewing Reports, Books, and Snapshot Books5-24Viewing Reports5-24Viewing Books5-25Viewing Snapshot Books5-25Printing Reports, Books, and Snapshot Books5-26Printing Reports5-26Printing Books5-26Printing a Report From a Book5-27Features of a PDF File Generated From a Book5-27Opening a Snapshot Book That Has the Same Name as Other Financial ReportingObjects5-28vi

67Designing BatchesAbout Batches6-1Designing a Batch6-1Defining Prompts for a Batch6-2About Prompts6-2Responding to Prompts6-2Defining Prompts6-3Scheduling BatchesAbout Scheduling Batches7-1Scheduling a Batch to Run7-1Providing Logon Credentials7-2Selecting a Member for the Batch Point of View7-2Specifying the Batch Destination7-3Selecting Email Addresses for Batch Scheduling7-3Scheduling Batch BurstingAbout the Bursting Destination File7-5Selecting the Bursting File7-5Previewing the Bursting List7-6Specifying Burst Output Labels7-6Batch Scheduler OperationsDeleting Batches87-47-77-7Deleting Batches from the Batch Scheduler7-7Automatically Removing Batch Scheduler Results7-8Retrieving the Exported Output7-8Viewing Details of a Scheduled Batch7-9Changing Logon Credentials for Scheduled Batches7-9Copying Batch Properties to New Batches7-9Modifying Batch Properties7-10Assigning File Permissions to Snapshots and Snapshot Books7-10Using AnnotationsAbout Annotations8-1Annotation Elements8-1Considerations When Using Annotations8-1Creating Annotations8-2Showing and Hiding Annotations8-3Behavior of Annotations in Formula Cells8-3Viewing Annotation Summaries8-4vii

9Viewing Annotation Details8-4Editing Annotations8-5Editing Annotation Context8-6Setting Annotation Printing Preferences8-6Using the Annotation ManagerSearching for Annotations109-1Context Lookup9-1Advanced Search9-2Viewing Reports Associated with Annotations9-2Responding to Annotations9-3Deleting Annotations9-3Changing the Source for Annotations9-4Showing Cell Text, Planning Unit Annotations, and Document Attachments asAnnotations9-4Changing Annotation Context Elements9-4Auditing Annotations9-5Accessing Financial Reporting From a Mobile DeviceOverview of Accessing Financial Reporting From a Mobile Device10-1Viewing Reports and Books10-2Viewing Reports10-2Viewing Books10-3Working With Reports and Books10-3Changing the User POV10-3Responding to Prompts10-4Using Expansions10-4Using Related Content10-5viii

Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit theOracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic supportthrough My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id info or visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trsif you are hearing impaired.ix

Documentation FeedbackDocumentation FeedbackTo provide feedback on this documentation, click the feedback button at thebottom of the page in any Oracle Help Center topic. You can also send email toepmdoc ww@oracle.com.x

1About Financial ReportingFinancial Reporting applies to these Enterprise Performance Management Cloudservices: Enterprise Planning and Budgeting Cloud Planning and Budgeting Cloud Financial Consolidation and Close Cloud Profitability and Cost Management Cloud Tax Reporting Cloud1-1

2Using the Explore RepositoryAbout the Explore RepositoryUse the Explore Repository to list and navigate repository contents, manage andcontrol files and folders, and use elements that present the repository as a filemanagement system.To access the Explore Repository, from the Welcome page, clickExplore Repository., and then selectItems opened in the Explore Repository display as tabs at the top of the ExploreRepository. Access privileges or permissions determine which items you can view,modify, run, and delete in the repository.Based on the following criteria, menus and the toolbar are updated as you use thesystem: The roles granted you by the administrator. Roles determine which modules aredisplayed in the View pane and toolbar. The components used and the task performed.From the Explore Repository, you can perform the following tasks: Preview Financial Reporting documents, such as reports and books Organize, search for, and assign access permissions to files Schedule batches Create documents Set preferences Define favorites Install the following components:–Oracle Smart View for Office–Predictive Planning–EPM AutomateNote:When entering names for items in the repository such as files and folders,you can use uppercase and lowercase letters and numbers. Spaces cannotbe used at the beginning or end of folder names. Invalid characters include:\,/,%,?, , , , , ,*,".2-1

Chapter 2Using a Single Instance of the Explore RepositoryNote:Because importing Financial Reporting objects with invalid characters intheir names or path is allowed, you must rename the objects after they areimported into the Explore Repository. Scheduled batches containing objectnames with invalid characters fail when PDF and HTML are selected asoutput options.Using a Single Instance of the Explore RepositoryWith the single instance feature, if you re-launch the Explore Repository, a new tabopens in the existing Explore Repository instance.This includes launching repository items from external URLs such as emailed links,SmartCuts, Subscriptions, Related Content, links on other web sites, and browserbookmarks.Personalizing the Explore RepositoryWhen using the Explore Repository, you can customize the appearance of the userinterface.Table 2-1Customization Options for the Explore RepositoryCustomization OptionMenu CommandShow/hide the View paneView, and then View PaneShow/hide the MastheadView, and then View MastheadResize the View pane andSee Resizing the View Pane and Resizing the Masthead.content area or the MastheadWhich file types are listed inthe content areaView, and then Display Items of Type. See Displaying SpecificFile Types.Sort items in the content area View, and then Sort By. See Sorting Columns.Which item properties aredisplayed in the content areaView, and then Show Columns. See Displaying Specific FileTypes.Whether to show hidden filesin the content areaView, and then Show HiddenWhether to show duplicateitems in the content areaView, and then Show DuplicatesResizing the MastheadTo resize the masthead:1.In the Explore Repository, point to the area between the menu options and thecontent area.The Masthead Area Adjuster is displayed as a line.2.When the pointer changes to a vertical double-headed arrow, resize the mastheadby dragging the arrow up or down.2-2

Chapter 2Personalizing the Explore RepositoryResizing the View PaneTo resize the View pane:1.Point to the column border between the View pane and the content area.The View Pane/Content Area Adjuster is displayed as a line in the border.2.When the pointer changes to a horizontal double-headed arrow, resize the Viewpane by dragging the arrow right or left.Displaying ColumnsFrom the Explore Repository, items and properties are displayed in the columns withinthe content area. Column settings are retained after you log off.To hide or display columns:1.Select View, and then Show Columns.2.In the Show Columns dialog box, display or hide columns by selecting or clearingthe corresponding check box.3.To specify the column width, click a column check box, and enter the new columnwidth in pixels.4.Click Save.Reordering ColumnsTo reorder columns, do one of the following: Select View, and then Show Columns. In the Show Columns dialog box select acolumn and use the andarrows.From the content area in Explore, drag the columns to the desired location.Sorting ColumnsTo sort columns by name, type, owner, modified date, or desciption, select View, thenSort By, and then select a sort option.To alphabetically sort the items in a column, click a column heading, and then click theup arrow or down arrow to change the sort. (Date columns are sorted chronologically.)Displaying Specific File TypesFrom the Explore Repository, you can specify which file types to display in the contentarea. Your role and permissions determine if an item is displayed.To display specific file types, select View, then Display Items of Type, and then selectan option: All Files—Displays all files All Financial Reporting Objects—All Financial Reporting reports, snapshotreports, books, snapshot books, and batches2-3

Chapter 2Managing Items All Images—All image files with the following extensions:–.gif–.jpg–.png–.bmp All Office Files—Microsoft Word, Excel, Power Point, and Project files All Reports—All Financial Reporting reports and snapshot reports External Links—All items imported as a URL Other—Select a file from the menu displayed.Managing ItemsManage documents, collections, supporting files, other standard files, and folders.Supported Items in the Explore RepositoryItems are objects stored in the repository, including: Documents Collections Supporting Files Other Standard Files FoldersAll objects have properties that store information, such as attributes and permissions.Attributes include: name, a description of the object, UUID, and owner. Properties forfile objects, URLs, and shortcuts include additional attributes.DocumentsDocuments include Financial Reporting reports and snapshots. Use the ExploreRepository to list and view documents. The items that you open in the ExploreRepository are displayed as tabs at the top of the Explore Repository.Documents can contain and generate reports, which are formatted data values andinteractive elements. Reports are displayed in tabular, grid, or chart formats.CollectionsCollections contain references to groups of documents, such as books. You use theExplore Repository to list and view collections. The items that you open in the ExploreRepository are displayed as tabs at the top of the Explore Repository.2-4

Chapter 2Managing ItemsTable 2-2Collections in the Explore RepositoryTypeDescriptionCreated inFile ExtensionBooksCollection of ReportingStudio documents.Dynamically specifydimension sections anddimension changes forbooks.Explore Repository.kbkSnapshot BooksGenerated bookscontaining static dataExplore Repository.kbtBatchesCollection of executableExplore RepositoryReporting Studiodocuments and books withspecial properties andare executed to generatereports.bchSupporting FilesThe following table lists supporting files that are used when authoring or managingdocuments or collections.Table 2-3Supported File Types, Descriptions, Studio Created in, and File ExtensionsTypeDescriptionStudio created inFile ExtensionFolderContainers that containsother folders and filesNAnoneShortcutLink to a repository item.Create shortcuts to easilyaccess the item to whichthe shortcut links.NAnoneURLLink to websites or HTMLpagesNAnoneGridReporting Studio objectReporting Studiothat contains data fromexternal sources. Gridscontain rows, columns, andoptionally, a page axis.rogChartReporting Studio objectthat contains chartsReporting Studio.rocImageReporting Studio imageobjectReporting Studio.roiTextReporting Studio textobjectReporting Studio.rotRow and Column Template Templates used to authorReporting StudioFinancial Reporting reports.ros2-5

Chapter 2Managing ItemsOther Standard FilesOther standard files include: Text files Image files Microsoft Office files HTML files PDF files Zip filesFoldersFolders exist with the repository and are arranged in a hierarchical structure. Foldersare used for organization, and they can cont

Using Smart View to Import Financial Reporting Content 2-25. iv. Exporting Use Cases2-9. Exporting Financial Reporting Artifacts2-9. Exporting Financial Reporting Reports and Snapshots to Microsoft Office2-9. Creating Shortcuts2-10. Creating Email Links to Repository Items2-11. Selecting Recipients to Receive Emails2-12. Managing Files and .

Related Documents:

Bruksanvisning för bilstereo . Bruksanvisning for bilstereo . Instrukcja obsługi samochodowego odtwarzacza stereo . Operating Instructions for Car Stereo . 610-104 . SV . Bruksanvisning i original

10 tips och tricks för att lyckas med ert sap-projekt 20 SAPSANYTT 2/2015 De flesta projektledare känner säkert till Cobb’s paradox. Martin Cobb verkade som CIO för sekretariatet för Treasury Board of Canada 1995 då han ställde frågan

service i Norge och Finland drivs inom ramen för ett enskilt företag (NRK. 1 och Yleisradio), fin ns det i Sverige tre: Ett för tv (Sveriges Television , SVT ), ett för radio (Sveriges Radio , SR ) och ett för utbildnings program (Sveriges Utbildningsradio, UR, vilket till följd av sin begränsade storlek inte återfinns bland de 25 största

Hotell För hotell anges de tre klasserna A/B, C och D. Det betyder att den "normala" standarden C är acceptabel men att motiven för en högre standard är starka. Ljudklass C motsvarar de tidigare normkraven för hotell, ljudklass A/B motsvarar kraven för moderna hotell med hög standard och ljudklass D kan användas vid

LÄS NOGGRANT FÖLJANDE VILLKOR FÖR APPLE DEVELOPER PROGRAM LICENCE . Apple Developer Program License Agreement Syfte Du vill använda Apple-mjukvara (enligt definitionen nedan) för att utveckla en eller flera Applikationer (enligt definitionen nedan) för Apple-märkta produkter. . Applikationer som utvecklas för iOS-produkter, Apple .

och krav. Maskinerna skriver ut upp till fyra tum breda etiketter med direkt termoteknik och termotransferteknik och är lämpliga för en lång rad användningsområden på vertikala marknader. TD-seriens professionella etikettskrivare för . skrivbordet. Brothers nya avancerade 4-tums etikettskrivare för skrivbordet är effektiva och enkla att

Den kanadensiska språkvetaren Jim Cummins har visat i sin forskning från år 1979 att det kan ta 1 till 3 år för att lära sig ett vardagsspråk och mellan 5 till 7 år för att behärska ett akademiskt språk.4 Han införde två begrepp för att beskriva elevernas språkliga kompetens: BI

**Godkänd av MAN för upp till 120 000 km och Mercedes Benz, Volvo och Renault för upp till 100 000 km i enlighet med deras specifikationer. Faktiskt oljebyte beror på motortyp, körförhållanden, servicehistorik, OBD och bränslekvalitet. Se alltid tillverkarens instruktionsbok. Art.Nr. 159CAC Art.Nr. 159CAA Art.Nr. 159CAB Art.Nr. 217B1B