--- schema_version: "1" id: 53f790912185967de0b8a2726bba8dfab4146f3adee7a977a19a255486afad14 title: Upload Dataset collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_template_comms_bus_import_data.md canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_template_comms_bus_import_data.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 5ba6f68d70b74a9099f7ca506dc70a03dd94c3360d6f34138aff73f58fa1d1e2 description: Upload the plain_quota Dataset to view relevant metrics in the Home dashboard. products: - CRM Analytics - Cross Cloud release: "264" --- # Upload Dataset Upload the plain\_quota Dataset to view relevant metrics in the Home dashboard. ### Required Editions
Available in: Developer edition and for an extra cost in Enterprise, Performance, and Unlimited editions.
Optionally, you can upload quota data by overriding the plain\_quota dataset in your app by following these instructions. The plain\_quota dataset is used to provide you with quota attainment metrics in the Opportunities section of the Home dashboard. If you don’t want to see this metric, you can skip this section. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png) Note When you work with .CSV files you want to import to CRM Analytics Comms-Business, create and open them using only a UTF-8-compliant text editor. Opening them in Microsoft Excel or other spreadsheet software reformats .CSV files and makes them unusable in CRM Analytics Comms-Business. ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_important.png) Important When you create the .CSV file, be sure it contains the following fields, in this order, with exactly these names. Field names are case-sensitive: - StartDate (in yyyy-mm-dd format) - QuotaAmount - OwnerName - Username 1. Create a .CSV file to include the fields described, that is StartDate (in yyyy-mm-dd format), QuotaAmount, OwnerName, Username. For an example, see [Sales Analytics Example .CSV File](https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_quota_csv.htm&release=264.0.0&type=5 "Here’s an example of the .CSV file you create to update the Sales Analytics Quota (Target) dataset."). 2. Save the file to a location that you can easily remember. 3. In Salesforce, go to the CRM Analytics home page and find the plain\_quota dataset. 4. Click the arrow at the upper right corner of the dataset panel and select **Edit**. ![Analytics Studio edit dataset](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_apps_edit_dataset.png) 5. Salesforce displays the dataset editing screen for the plain\_quota dataset. Look for **Replace Data** in the upper right corner and click it. ![Analytics Studio replace data in dataset](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_apps_replace_dataset.png) 6. In the dialog box that opens, navigate to the .CSV file you created in Step 1, and double-click it. 7. To open the Replace Dataset Data page, click **Next**. 8. If your fiscal period is different than calendar period, that is if it starts on a date other than January 1, update the plain\_quota Metadata file. If your fiscal period starts on January 1, skip to the next step. 1. Copy the JSON from [Sales Analytics Quota Dataset JSON File](https://help.salesforce.com/s/articleView?id=analytics.bi_app_sales_wave_quota_json.htm&release=264.0.0&type=5 "Use this file to update the Sales Analytics Quota dataset with your fiscal year start date if it’s not January 1.") and paste it into a text editor of your choice. 2. Change the value of `"fiscalMonthOffset"` from 4 to a number that represents the month your fiscal period starts. In metadata, the numeral “0” stands for January, “1” stands for February, and so on, up to “11,” which stands for December. Save the file to your desktop. 3. In CRM Analytics Studio, go to the Replace Dataset Data page and locate the Data Schema File area of the page. Click the arrow next to Quota .JSON file, select Replace File, find the file you saved and upload it to CRM Analytics. 9. On the Replace Dataset Data page, click **Next** to open the Edit Field Attributes page. The first column —QuotaAmount— is selected. If not, select it. In the **Field Attributes** panel on the right, make sure **Field Type** is set to **Measure**. ![Set the QuotaAmount field attribute to Measure.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_app_dataset_set_field_type.png) 10. After uploading your quota data, rerun the recipe to update the dashboards. 1. Click the Gear menu at the upper right of the CRM Analytics Comms for Business screen and select Data Manager. 2. Select the Dataflow & Recipes view from the menu at the top left of the Data Manager screen and click the Recipes tab in the main pane. ![The Analytics Dataflow Scheduler](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_app_data_manager_dataflow.png) 1. Find your app’s recipe. Open the menu on the far right of the screen next to the app icon and name, and click Run now.