Data Extract is an option located on the Tools ribbon which allows users to extract segment data directly from the Prospero database.
To extract Prospero data:
1. Select the Data Extract option from the Tools ribbon.
2. The Data Extract dialog will open and you will be prompted for how you wish to filter your extract data.
Select the following to define the data you wish to extract:
•Select Segment Filter – This allows you to select the specific segments for which to extract data.
•Columns – You must specify an existing Column Definition (containing periods only) in order to filter the extract data.
•Extract Date – Select the date for which you want to extract your data. Available options include ‘Current GL Period’, ‘Last GL Period’, ‘System Date’, ‘Last Period’, and ‘Custom’.
When selecting ‘Custom’, you may specify a specific Report Year and Report Period by entering the value in the field or you can select the Use current year and/or Use current period checkboxes.
•Display extracted data in Prospero – Selecting this checkbox will return the extracted data in the Prospero workspace as well as an Excel file of your choosing.
3. Select the OK button.
4. When prompted, enter a name for your Excel file and select the Save button. An Excel spreadsheet will open with your extract data.
5. If you had also checked the Display extracted data in Prospero checkbox, you will receive a “Raw Data View” in the Prospero workspace.
6. To close the workspace, click on the X next to the “Raw Data View” title on the tab.