Set Custom Extraction

In the Set Custom Extraction dialog box, you can add, edit, or delete custom extracts.

To open the dialog box, start the Application Wizard and select Plan Administration > Customize Plan > Set Custom Extraction. Then select a plan and click OK.

Option Description
Custom Extract List of custom extracts. There are three custom extracts that you can use: Performance Values, Expected Targets Report, and Ad-hoc Report.
Name Specify the name for the custom extract.
Description Optional. Specify a description for the custom extract.
Available to user Select this check box to make the extract available to other users.
MDX Specify the MDX code that will gather the data in the database that you want to display. We recommend copying the MDX code from a report, pasting it in the MDX tab, and then edit the code, instead of trying to write the code from scratch.
XSL Specify the XSL code that is used to format the data retrieved by the MDX code. You can also copy the XSL code from a report and paste it in the XSL tab, and then edit the code.
Clear Clear the selected tab.
Add Add a custom extract. After adding, change the name and provide a description of the extract.
Delete Delete the selected custom extract.
Apply Apply the changes.
OK Apply the changes and close the dialog box.
Cancel Close the dialog box without saving the changes.

If it is required to change the width of a report, the XSL code can be updated by finding the line that sets the width of the table containing the data and changing the value to a smaller or larger size depending on your preference. The line to change will look similar to "<table width="xxxx"" where xxxx is a numeric value containing the width in pixels of the table that is created. Changing this value changes the width of the table and the width of the columns within the table.