Selecting Dimension as the Dimension for Publish in Microsoft Office

Draw QR-Code in Microsoft Office Selecting Dimension as the Dimension for Publish

One of the d-lists most often used as the Dimension for Publish is the primary calculation d-list, or the number 1 d-list for the Enterprise Planning d-cube However, sometimes you need to select a different Dimension for Publish When trying to decide which dimension to select, keep in mind your reporting needs For instance, you may be asked to produce a list report showing the calculations as the rows of your report, while showing the periods as columns In this case, you would want to select the time scale dimension, or the number 4 d-list, as your Dimension for Publish You might consider using a d-list as the Dimension for Publish for the following reasons: The d-list contains a combination of text, numeric, and date items (mixed data types) The d-list contains numeric items with different display formats, such as ##% and #,##### Report(s) will require additional calculations between items in the d-list You need to treat some of the d-list items separately

Part I:

Your decisions should be considered carefully and made prior to running the Generate Framework Manager Model Extension option If you need to make modifications to the Table-only Publish Layout container after generating the Framework Manager model, you can update your model by re-running the Wizard and/or by manually making changes to the Framework Manager model

The d-list that you select to use as the Dimension for Publish is reflected in the Table-only Publish Layout container with the et_ prefix This d-list will be published as the Measures Table within the Table-only Publish Layout container Depending on the options you select when publishing the data, this table will contain each item as one or all of the following data types: Numeric, Varchar, and Date-Time

If you want to be able to generate reports against the comments that users enter into the Enterprise Planning application, you should include user s annotations in your Table-only Publish Layout container

Now that you have prepared your contributor application for the Generate Framework Manager Model Extension, you are ready to begin gathering information needed for configuring and running the extension Your first step will be to gather information for the Generate Framework Manager Model Wizard Next, you can successfully run the extension You need to know the following to run the Wizard successfully: Location for the Framework Manager model A name for your package Which Enterprise Planning cubes you want to make available for reporting The type of list(s) you want to include in the model Whether or not to make annotations available for reporting

Dispatcher URI The URI can be located in Cognos Configuration by selecting the Environment Node It will display in the Dispatcher URI for external applications text box in the right pane of Cognos Configuration

4:

You always have the option of modifying the Framework Manager model by re-running the Wizard and selecting to update the existing model (as discussed later in this chapter)

Framework Manager Model Extension option must be a member of a user class higher than the highest user class that is included in the Enterprise Planning application For Enterprise Planning version 82, any user belonging to the Planning Rights Administrator role or who has been granted the appropriate rights within the Access Rights screen of the Contributor Administration Console will have the ability to run the Generate Framework Manager Model Extension

The location you choose for your Framework Manager Model should simply be a folder on your network or server where anyone who needs to make modifications to the Framework Manager model has read and write access Additional folders to hold the base model and log files will be created via the extension to hold the related files