# Data Store using a Flat File Data Connector

{% hint style="success" %}
*Look at the given walk-through on how to create a Flat File connector based Data Store.*
{% endhint %}

<figure><img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Fv2t86R4GJKxRmCdulxXW%2FFile%20Data%20store%20creation.gif?alt=media&#x26;token=c87d63a6-e869-40f4-9bd1-1886d769b252" alt=""><figcaption></figcaption></figure>

This section describes steps to create a Data Store using a Flat File.&#x20;

* Navigate to the Data Center homepage.
* Click the ***New*** option.
* Select the ***Data Store*** option from the context menu.

![Accessing the Data Store option under the New context menu](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FD8C2WQxmRAcyjCV9x7G7%2Fimage.png?alt=media\&token=1488caad-226e-4588-93a6-ad501ac2cef9)

* The Data Connectors page opens.
* Select a Connector Type from the ***Data Source*** filter (E.g., A file data source is selected in the following image).
* Select a data connector from the Data Connector list.
* Click on the ***Create Data Store*** option. &#x20;

![Accessing the Create Data Store option](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FBg0mL1rBcWQHaORdq1I8%2Fimage.png?alt=media\&token=cb8caafc-3599-4b47-b9a6-e1b3300e599f)

* The ***Getting Data*** tab option opens to create a new Data Store based on a Flat File Data Connector.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FK9Bp2MgkjyZ1fkGPqbuq%2Fimage.png?alt=media\&token=8772a7bf-ffb5-49ed-a5ae-7179380c48bf)

### **Getting Data**

* Enter a name for the Data Store.&#x20;
* The *pre-selected* ***Data Connector Name*** gets displayed.
* Click the ***Choose File*** option to browse a file from the system.
* Select a sheet using the ***Sheet List*** drop-down menu.
* Select an option to display ***Sheet Layout*** using the drop-down menu out of Column Headers or Row Headers.
* Click the ***Next*** option to proceed.&#x20;

![Configuring the Getting Data tab](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FMpD2P7yx8owhmDYmTzfu%2Fimage.png?alt=media\&token=757f03f5-5cc7-4942-9904-73b2d92ddd17)

{% hint style="info" %} <mark style="color:green;">Please Note:</mark> *The user can choose an Excel or CSV file as a file data connector.*
{% endhint %}

&#x20;

### **Data Type Definition**

* Navigate to the ***Data Type Definition*** tab.
* Define the required Dimensions, Measures, and Time by interchanging the categories.&#x20;
* Enable the Dimensions by using a checkmark to avail LOV lookup in the filter panel of the Self-service BI Report.
* Click the ***Next*** option to proceed.

![Configuring the Data Type Definition tab](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FdE7JvFzAQsmXzKFpzxau%2Fimage.png?alt=media\&token=e50cd9d9-6522-4111-af5d-63ff3af151c7)

### **Hierarchy Definition**

Define hierarchy using multiple dimensions or dropping the selecting time fields in the Drill Definition box.

* Navigate to the ***Hierarchy Definition*** tab.
* Click the ***Add*** option  provided in the Hierarchy Definition window.
* A new ***Drill Def*** box gets added to the screen.
* Drag and drop the dimensions or time options to define a hierarchy.
* Proceed to the next tab by clicking the ***Next*** option.

![Configuring the Hierarchy Definition tab](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FlZeFqCuJCHEtD1RawwJX%2Fimage.png?alt=media\&token=7c8ef642-0413-4827-b0cd-b271164d9fce)

### **Data Restrictions**

The Administrator can restrict access to data for a specific user by configuring the User Property via the ***Data Restrictions*** tab.

**E.g.,** If for a user/user group ***Country*** custom field value is ***USA*** and the administrator passes ***Country*** as a User Property while creating a data store. Users for whom ***USA*** was selected as a value for the ***Country*** custom field can access data related only to the USA from the data store.

* Navigate to the&#x20;
* Click the ***Add*** icon to add a new box for inserting the data restriction parameter.&#x20;
* Select a dimension using the drop-down menu.
* Enter the user/group-specific custom field to restrict the data.
* Click the ***Finish*** option.    &#x20;

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Fin8Pw5HLGP2FtU7AN7JI%2Fimage.png?alt=media\&token=2e586eb2-b2ee-4b67-921c-22444d287b99)

* A success message appears to confirm the data store configuration.
* The ***Data Stores*** list opens.
* The newly created Data Store gets added at the top of the ***Data Stores*** list.     &#x20;

![The File Data Store gets added to the Data Stores list](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FDHfkxiHDwIsNMcbgsERt%2Fimage.png?alt=media\&token=8a3fcef2-943e-48f0-b54e-35603439fe7f)

&#x20;   &#x20;

&#x20; &#x20;

&#x20;

&#x20;

&#x20;

###

###