Saving Office Documents to EPM Cloud in Smart View

You can save documents to Oracle Enterprise Performance Management Cloud in the Documents folder or subfolders that you have created.

In Oracle Smart View for Office, you may save Microsoft Office documents (Word, Excel, and PowerPoint files) to the EPM Cloud Library. Documents you save in the EPM Cloud Library are accessible to other users with the proper access rights. You can also download saved files from the library.

Before you begin, create any folders you may require. See Creating Folders in the EPM Cloud Library.

To save Office documents to EPM Cloud:

1. Open an Office application (Word, Excel, or PowerPoint), and connect to an EPM Cloud business process.

   If you aren't already connected, you will be prompted to sign in when you use the Save or Save As options.

2. Perform this step before saving an Office document to EPM Cloud the first time: In the Smart View Panel, navigate to a cube and, from the Action Panel, select Connect.

   Alternatively, right-click the cube in the Smart View Panel and select Connect.

   Note:

   This step only needs to be performed once for each business process to which you plan to save Office documents.

3. To save the currently-opened Office document to the same folder from which it was opened, click Save in the Smart View ribbon.

   Use the Save command after downloading and modifying a file. Clicking Save saves the file back to the same location in the Documents node.

   Note:

   If you have just started a new Office document, you must first perform a Save in the Office application. For example, if you just started a new Word file, save the file using the Save command in Word so that the file is saved locally or in a network location.

   When you click Save, Smart View saves the Office document with that name that appears on the file.

4. To save the currently-opened Office file to the folder you choose in the EPM Cloud Library, click Save As, then specify the settings below, and then click Upload.

   • Cloud Connection - Select the library provider connection from the drop-down list.

   • Library folder location - Use the Browse button to navigate to the folder to save the file.
   • Document name - Enter a name for the file; the name does not need to be the same as the actual file name.
   • Description - Enter an optional description for the saved file.

   You and other users can download and work with files saved to folders in the EPM Cloud Library. Keep in mind these guidelines:

   • After downloading and modifying a file, click Save to save the file back to the same location in the EPM Cloud Library.
   • Use the Save As option to save a downloaded file to a different folder location accessible to others within the EPM Cloud Library.
   • While saving documents using the Save As option, the file extension is automatically added based on the default file extension of your document. For example, if your local Excel sheet has the old extension format of .xls, the sheet will be saved to the EPM Cloud Library with the same extension.
   • To convert a document from the old format (.xls, .doc, .ppt) to the new format (.xlsx, .docx, .pptx), use the Save As command of the Office application to first save the file locally in the new format, and then upload it to the EPM Cloud Library using the Save As feature of Smart View.
5. Repeat the previous steps for any other Office documents that you want to save to the Documents folder to a folder you choose in the EPM Cloud Library.