Create a Report with Data Preparation- Partly from the Data Center
The page explains Report creation based on a Data Store (from the Data Center) that contains Data Preparation steps.
The page explains Report creation based on a Data Store (from the Data Center) that contains Data Preparation steps.
Check out the walk-through on a Report creation workflow with a Data Store that contains saved Data Preparation steps.
Please follow the below-given steps to create a new Report based on a Data Sandbox file with Data Preparation Steps:
Navigate to the Data Sandbox list from the Data Center module.
Select a Data Sandbox file from the list.
Click the Data Preparation icon to create a Data Preparation and make some transformations.
The user gets redirected to the Data Preparation module.
Apply transformations using the Transforms tab.
The applied transforms will be noted under the Steps tab. You may open it to see the applied transforms.
Click the Auto Prep option to apply the Auto Prep functionality.
The Auto Prep is also mentioned under Steps tab after being applied to the selected data.
Provide a name to the Data Preparation.
Click the SAVE option.
A notification ensures that the data preparation is saved.
The Data Preparation gets added to the Data Preparation list.
Click the Create Data Store icon for the same Sandbox file from the Sandbox list.
The Create Data Store window appears.
Provide a name for the Data Store.
Describe the Data Store.
Select the available Data Preparation using the drop-down menu.
Click the Validate option.
A note gets displayed ensuring that the Data Preparation is applied and unsupported headers are modified.
Click the Save option to finish the Data Store creation.
A notification ensures that the Data Store creation has been initiated and may take a few minutes.
The newly created data store with data preparation steps gets added to the Data Store list.
Wait till the Job Status for the newly created Data Store gets displayed as Running.
The user may open the Notifications section to check the Data Store update. It would notify that the data is loaded to the newly created Data Store.
Navigate to the homepage and click the Report icon or Create New Report option to initiate the report creation.
The Create New Report window opens.
Provide a name for the Report.
Describe the report.
Click the Select Existing Data Store option to create the report.
Select the data store earlier created with the Data Preparation steps using the checkbox.
Click the Create Report option.
A new report gets created based on the Datastore and the user gets redirected to the Design page of the report.
Drag and drop dimensions and measures to create a View.
Click the Save icon to save the View.
A notification message appears and the View gets saved to the Report.
