Working with Gallery Transformations

Add a Gallery Transformation to a Report Job

The Adapter Setup wizard creates Gallery transformations and report jobs automatically for a number of supplied adapters and domain categories. However, you might need to create your own Gallery transformation and report job. For example, you might want to create batch reports for domain categories for which SAS IT Resource Management does not already provide reports.
To create a Gallery transformation and add it to a report job, perform the following steps:
  1. In SAS IT Resource Management, open the report job that is to contain the new Gallery transformation. The job shows on the Diagram tab of the Job Editor window.
    Note: If you want to add a Gallery transformation to a new job, you must first create the job. For more information about how to create a job, see the “Create a Job” topic in the SAS IT Resource Management: Administrator's Guide.
  2. In the Transformations tree of SAS IT Resource Management, expand the ITRM Transformations folder.
    ITRM Transformations Folder
    ITRM Transformations Folder
  3. Drag and drop the Gallery transformation onto the Job Editor window. The Gallery transformation appears in the process flow diagram for the job.
    Sample Job with a New Gallery Transformation
    Sample Job with a New Staging Transformation
  4. Right-click the Gallery transformation and select Properties.
  5. On the General tab, specify the name and description of the transformation.
    Note: SAS IT Resource Management uses the naming convention <domain category> <time period> to name Gallery transformations. For example, a Gallery transformation that generates weekly reports for the Server System domain category of DT Perf Sentry is named System Weekly. For best results, use the same naming convention that SAS IT Resource Management uses for consistency and efficiency.
    General Tab of a Gallery Transformation
    General Tab of a Gallery Transformation
  6. On the Server tab, specify SAS Content Server parameters for the transformation.
    Server Tab of a Gallery Transformation
    Server Tab of a Gallery Transformation
    The Server tab includes the following parameters:
    • SAS Content Server specifies the name of the SAS Content Server that stores the report output for the Gallery transformation.
    • Repository folder path specifies the path, relative to the SAS Content Server, in which to store the reports.
    • URL file name parameters specifies the parameters that pertain to the URL filename, such as Proxy, user ID, or password. For example, the contents of this field could be user='userID', pass='password', and so on. A value is optional in this field and the default value is blank.
      Note: The contents of this field are not verified.
  7. On the Report Parameters tab, specify the style and graph formats for the reports that the transformation creates.
    Report Parameters Tab of a Gallery Transformation
    Report Parameters Tab of a Gallery Transformation
    The Report Parameters tab includes the following parameters:
    • Style template specifies the name of the style template that is used by all of the reports that the Gallery transformation creates. The style template determines graph colors and other attributes inside the graph portion of a report.
      You can use the standard style template that SAS IT Resource Management provides (named ITRMDefault) or create your own style template that includes your own custom colors and visual design. For more information, see About Templates and Style Sheets.
    • Location for style sheet specifies the cascading style sheet (.css file) that is used when viewing a report. It controls colors and other attributes outside of the graph portion of a report.
      Any of the following location types are valid values for this field:
      • a full URL to the style sheet folder on a specified server (such as http://<server>:8080/<folder name>/).
      • a URL to a style sheet folder on all the clients where the Web browser was initiated (such as file://c:/programfiles/<folder name>/).
      • a relative URL to the style sheet folder on the middle tier where the graphs are installed (such as /<folder name>/<subfolder name>). The option to use only the relative path provides portability of this value. For example, if the name or location of the middle tier changes, the location value does not need to change as long as the folder names in the middle tier remain the same.
      The default value (/SASContentServer/repository/default/sasdav/ITRM/styles/ITRMDefault.css) provides a path to the default style sheet for SAS IT Resource Management reports . You can create a style sheet that includes your own custom colors, logos, and visual design. For more information, see About Templates and Style Sheets.
    • Graph format override specifies the graph format to use when generating the reports, regardless of the graph format indicated in the corresponding report definition. The available formats are ActiveX, PNG, or JAVA type images. A value is optional in this field, and the default value is blank. When this field is blank, the reports use the graph format that is specified in the report definition.
    • Location for graph applet jar files specifies the path to the SAS code that is used only to render reports that are specified as Java reports. A value is optional in this field, and the default value is /sasweb/graph.
      Any of the following location types are valid values for this field:
      • a full URL on a specified server.
      • a URL to a folder on all the clients where the Web browser was initiated (such as file://c:/programfiles/<folder name>/).
      • a relative URL to a folder on the middle tier where the graphs are installed (such as /<folder name>/<subfolder name>). The option to use only the relative path provides portability of this value. For example, if the name or location of the middle tier changes, the location value does not need to change as long as the folder names in the middle tier remain the same.
      Note: If this field is blank, then the Gallery transformation uses the path that is specified for the –APPLETLOC option in the SAS configuration file.
    The Report Parameters tab also enables you to reset the parameter values on the tab to their original default values. To do so, select Reset next to a specific field to reset the value for that parameter to the default value. Or, select Reset to defaults to reinstate the default value for all parameters on the tab.
  8. On the Report Definitions tab, you can specify the report definitions and expiration date criteria for the reports that the transformation creates.
    Report Definitions Tab of a Gallery Transformation
    Report Definitions Tab of a Gallery Transformation
    The Report Definitions tab includes a Report Definitions table at the top of the page. This table provides a detailed list of the report definitions that the Gallery transformation uses to generate reports.
    Report Definitions Table on the Report Definitions Tab
    Report Definitions Table on the Report Definitions Tab
    This table includes the following parameters:
    • Report Definition Name specifies the name of the report definition.
    • Report Definition Folder specifies the folder where the report definition is stored.
    • Data Source Folder specifies the folder where the data source for the report is located. If this field is blank, then the report job looks for the data source in the data path that is specified in the report definition or in the same IT data mart folder as the report job, respectively.
      You can double-click a Data Source Folder cell to open the Select a Location dialog box. This dialog box enables you to navigate to and select a folder that contains the data source for the corresponding report definition.
      For more information, see Specifying a Data Source Location.
    The Report Definitions tab enables you to add report definitions to the Gallery transformation. To do so, perform the following steps:
    1. Click Add. The Select Report Definitions dialog box appears.
    2. Navigate to the report definition folders that corresponding to the adapter and domain category that you are using.
      The report definitions that the Adapter Setup wizard uses are in Supplied folders at Shared Data/SAS IT Resource Management/3.2 IT Report Definitions/<adapter>/<domain category>/Supplied/<time period (such as Day, Week, or Month)>.
      The report definitions that you have modified or created on your own are, by default, in User Defined folders at Shared Data/SAS IT Resource Management/3.2 IT Report Definitions/<adapter>/<domain category>/User Defined/<time period (such as Day, Week, or Month)>.
      Note: The supplied SAS Enterprise Guide projects that you can use to create your own report definitions provide this default location. However, you can specify a different location for the report definition. For best results, use the default User Defined folders as detailed above for consistency and efficiency.
      The following display shows the supplied report definitions that the Adapter Setup wizard uses for Day reports of the Server Disk domain category of the DT Perf Sentry adapter.
      Select Report Definitions Dialog Box
      Select Report Definitions Dialog Box
    3. Select one or more report definitions that you want to add to the Gallery transformation.
    4. Click OK. The report definition appears in the Report Definitions table at the top of the Report Definitions tab.
    To remove a report definition from the Report Definitions table, perform the following steps:
    1. Select a report definition from the Report Definitions table at the top of the Report Definitions tab.
    2. Click Remove. The report definition is removed from the Report Definitions table.
    The Properties of report definition box provides additional information about the report definition that is selected in the Report Definitions table.
    Properties of Report Definition Box of the Report Definitions Tab
    Properties of Report Definition Box of the Report Definitions Tab
    Tip
    Report definition names are unique within a domain category. However, they are not unique across all domain categories. The only means of distinguishing between two report definitions with the same name is by viewing their properties. You can use the information in the Properties of report definitions box to confirm that you have selected the correct report definition for your report job.
    Properties of Report Definitions on the Report Definitions Tab
    Property
    Notes
    Data path
    (Optional) Specifies the path to the data source.
    Data source
    Specifies the data source such as an information map. Verify that the data source is in the same folder as the report job. If it is not, verify that the data source is in the data path of the report definition or in the Data Source Folder of the Gallery transformation.
    Domain category
    Specifies the adapter and domain category for the report definition. For example, the value DTPerfSentry_ServerDisk indicates that the report definition corresponds to the Server Disk domain category of the DT Perf Sentry adapter. This value is a primary filter that is specified for the report definition in the ITRM Gallery task.
    Verify that the adapter and domain category is correct for the IT data that you are using and the reports that you want to create.
    Domain subcategory
    (Optional) Specifies the domain subcategory that corresponds to the domain category for the report definition. This value is a primary filter that is specified for the report definition in the ITRM Gallery task.
    Expire after
    Specifies the number of days that the corresponding reports are stored on the SAS Content Server before they are expired. If a report is expired and its report job is run again, the expired report is deleted and replaced with the new report.
    Note: The Override Expiration Date options in the Gallery transformation can override this value.
    Gallery task
    Specifies the name of the ITRM Gallery task that created the report definition. The ITRM Gallery task and the report definition have the same name.
    Keywords
    Specifies the keywords that the report definition assigns to the reports that it creates. Keywords are primary filters that are specified for the report definition in the ITRM Gallery task.
    Process flow
    Specifies the name of the process flow that includes the ITRM Gallery task that created the report definition.
    Project
    Specifies the name of the SAS Enterprise Guide project that includes the ITRM Gallery task that created the report definition.
    Report author
    Specifies the user ID of the person who created the report definition. If the value is Supplied, then the report definition was supplied by SAS IT Resource Management and is used by the Adapter Setup wizard.
    Schedule frequency
    Specifies when the corresponding reports for the report definition should be scheduled to run. This value is a primary filter that is specified for the report definition in the ITRM Gallery task.
    Note: This value is a report filter in metadata only. It does not affect the schedule for the corresponding report job. However, for best results, you should schedule the corresponding report job to run according to this filter. For example, if the schedule frequency is Weekly, then schedule the report job to run weekly.
    For more information about the naming standards that SAS IT Resource Management uses for reporting components, see About Naming Standards for SAS IT Resource Management Reporting Objects.
    The Override Expiration Date group box provides the ability to override the expiration date that is specified in the report definition.
    Override Expiration Date Options on the Report Definitions Tab
    Override Expiration Date Options on the Report Definitions Tab
    The following override options take effect the next time the report job is deployed and run.
    • Delete report content based on the expiration date in the report definition causes the expiration date that is specified in the report definition to take effect. This option is the default.
    • Delete report content that is older than specified days enables you override the expiration data that is specified in the report definition and enter the number of days that must elapse before the reports are deleted.
  9. Click OK. The Gallery transformation icon in the process flow diagram of the report job appears with a green check to indicate that it is complete and ready for execution.
  10. Deploy and run the report job. For more information, see About Report Jobs.

Edit a Gallery Transformation

To edit an existing Gallery transformation, perform the following steps:
  1. In the IT Data Marts tree of SAS IT Resource Management, double-click the job that contains the Gallery transformation that you want to edit.
  2. Right-click the Gallery transformation in the process flow diagram and select Properties. A Properties dialog box displays and enables you to modify the various parameters that are specified for the Gallery transformation and the code that it generates.
    For more information about the specific parameters that are available for configuration in the Gallery transformation, see the detailed steps in Add a Gallery Transformation to a Report Job.
  3. Click OK to save your changes.
  4. Deploy and run the report job. For more information, see About Report Jobs.

Delete a Gallery Transformation

To delete a Gallery transformation from a job, perform the following steps:
  1. In the IT Data Marts tree in SAS IT Resource Management, double-click the job that contains the Gallery transformation that you want to delete.
  2. Right-click the Gallery transformation in the process flow diagram and select Delete. The Gallery transformation object is deleted from the job.
  3. Click OK to save your changes.
  4. Deploy and run the report job. For more information, see About Report Jobs.