《ContributorAdd-inforExcel.ppt》由会员分享，可在线阅读，更多相关《ContributorAdd-inforExcel.ppt（20页珍藏版）》请在三一文库上搜索。
1、Use the Cognos Planning Contributor Add-in for Excel,Cognos Planning 7.2 - Contributor Application Administration,Objectives,In this appendix, we will: examine the Cognos Planning Contributor Add-in for Excel enter, save, and submit Contributor data using the Excel Add-in modify the display of Contr
2、ibutor data in Excel annotate data in Excel access client extensions from Excel,Use the Contributor Add-in for Excel: Overview,You can use the Contributor Add-in for Excel to view and edit Contributor data using the Excel interface. You can take advantage of Excel formatting and Contributor linking
3、functionality.,Access the Contributor Application using Excel,Before you can open a Contributor session in Excel, you must have the Excel Add-in installed on your machine. You must then log on to the Contributor application. After you log on, you see a graphical overview of all the areas you are res
4、ponsible for, and the status of the data.,View and Enter Contributor Data in Excel,To view and enter data into the Contributor application, click an item in the tree on the left side of the Workflow window. If you are not the current owner, click the Edit button to start editing.,Click a tab at the
5、bottom of the workbook to view or enter data into a cube.,View and Enter Contributor Data in Excel (contd),When you open a contribution, you can view or enter data depending on your rights and the state of the data. After you open the contribution, the Excel workbook consists of two zones: Contribut
6、or zone: view, enter, and submit data in the Contributor application Excel zone: insert graphs and calculations that link to or from data in the Contributor zone,Contributor zone,Excel zone,Edit Contributor Data in Excel,You can use standard Clipboard capabilities (for example, copy and paste) in ei
7、ther the Excel or Contributor zones of the workbook. You can type quick commands in the Contributor zone (for example, to copy data to the right) directly in cells to make data entry easier. If you type data into a calculated cell in the Contributor zone and press Enter, data in other cells that are
8、 part of the calculation are automatically recalculated (breakback). If necessary, you can reset all data in all of the tabs (cubes) in the Contributor zone to the saved version.,Use Outgoing Formulas,You can use formulas to link data from your plan in the Contributor zone to cells in the Excel zone
9、. As the Contributor data changes, the data in the linked Excel cells changes either manually or automatically, according to your Excel calculation option.,Contributor zone,Excel zone,Use Incoming Formulas,You can create formulas within the Contributor zone that are based on data in the Excel zone.
10、You can then link data and calculations directly to your Contributor plan. When the data in the Excel zone changes, you can decide whether to update the formula data in the linked Contributor cells.,Run or delete Contributor Excel formulas,The data in cell C2 is derived from a value on another works
11、heet in the Excel zone.,Modify the Display of Contributor Data in Excel,You can customize how data appears in the Contributor zone of the Excel workbook. For example, you can hide pages, rows and columns that contain only zeroes. You can also change the dimensions that you want to appear in the rows
12、 and columns.,Specify Update Options,When you enter data or change the view of data in a Contributor cube, the Add-in for Excel will: always update all of the data in the Contributor plan synchronize shared page dimensions in all Contributor cubes refresh the cells portrayed on worksheets not curren
13、tly visible on the screen To improve performance, you can choose to manually synchronize page dimensions and refresh off-screen data.,Annotate Contributor Data in Excel,You can annotate your plan to explain something, or add links to related information. You can annotate cells, tabs, or the model if
14、 you have Edit, Review, or Submit rights to the e.List item that you are working with. You can also browse annotations.,Submit and Review Contributor Data in Excel,After you enter data in the Contributor zone, you can save the data on the server and recalculate e.List items. Click the Submit button
15、to submit the data to the reviewer. The e.List item that you are working on will be locked after you click the Submit button.,Work with Locally Saved Workbooks,You can save drafts of your plan locally, which allows you to work on the plan without being connected to the Contributor server. When you h
16、ave completed your plan, you will need to rejoin your centralized planning process by saving a version back to the server. As long as your Add-in for Excel session is open, you can reload your active data from some or all of the cubes back into your workbook.,Work with Templates,You can retain forma
17、tting, non-Contributor content (for example, charts), and ad-hoc calculations by saving the workbook as a template. When a user opens the template, they will still see the formatting and calculations that you created, but the workbook will be populated with their own data.,Customized formatting that
18、 will be saved in the template.,Work Offline in Excel,You can take plan data offline using the Add-in for Excel. Click Work Online to bring the data back online. To commit the data to the plan, you must save it to the server.,Print Data: Options,Use the Contributor print functionality to print only
19、the Contributor data without any Excel data or formatting. Use the standard Excel print function to print the current two-dimensional view of your worksheet.,Excel print functionality,Contributor print functionality,Use Client Extensions in Excel,End users can access client extensions in the Excel i
20、nterface, if you have enabled these in the Contributor Administration Console.,Demo G-1,Use the Contributor Add-in for Excel,Summary,In this appendix, we have: examined the Cognos Planning Contributor Add-in for Excel entered, saved, and submitted Contributor data using the Excel Add-in modified the display of Contributor data in Excel annotated data in Excel accessed client extensions from Excel,