To pull a data cube with multiple months of data into a single period, take out the From and To Date from your cube and add the Period field instead.
Lastly, there is the ‘Period’ dimension where you can add a ‘To Date’ and ‘From Date’. Double click on the cube field for further field properties to appear i.e. After clicking on any field to add, a pop-up window gives you the option to edit it.įor the ‘Fact’ dimension, we’ll first select the ‘Retail’ section and then ‘Sales at Sell’ and ‘Sales Quantity’. In the ‘Section’ drop-down menu, first select ‘Retailer Hierarchy’ after which you can add your various levels such as:įollowing that, we’ll select ‘Item Detail’ and add ‘Product Code’, ‘Barcode’, ‘Brand’, ‘Product Description’, and ‘Size & UOM’. Next is the ‘Product’ dimension, which has two parts. Once you are happy, you can click on ‘OK’. In this window, you will be able to edit the ‘Field Name’, amount of ‘Num Decimals’, and choose if you would like to include ‘Aggregation’.įor this example, we selected ‘Unique Count’, as highlighted in the image below. Please note that each field can have its own independent aggregation type, which means that the selected aggregation type would apply to the selected field only and not to all fields.
For ‘Store Detail’, that includes ‘Store Name’. However, you have the option to add ‘Market’, ‘Product’, ‘Period’, ‘Fact’, ‘Ranging’, and ‘Clustering’ dimensions, as seen from the drop-down menu in the image below.Īs per our example, after selecting the ‘Market’ dimension, select ‘Store Detail’ from the ‘Section’ drop-down menu, and add your fields. Next up, it’s time to select the fields that you want to add to your Data Cube.įor this example, we’ll add all the relevant ‘Market’, ‘Product’, and ‘Fact’ information to our data cube, all found under the DotActiv structure. In the ‘Source’ section, select ‘Database’ and choose which database you want to use. Please note that when using a CSV as a data source, the data can only be retrieved if the user is connected to the local server.Ī planogram would be used as a data source if the user would like to retrieve specific product information that is ranged on a particular planogram.
This means that the data does not need to be imported into the DotActiv database structure nor a planogram beforehand. Pulling data from a CSV/Excel spreadsheet allows you to populate a Data Cube with data directly from the raw format which can be retrieved and populated in custom reports. You can also retrieve information from any other extra table that exists within the database. Period, Product, Market and Fact as well as cluster and ranging information. The data structure includes the four fact fields i.e. A Database is the most commonly used data source as any piece of data can be retrieved which is stored within the DotActiv software, however, this does take some time to load.