Create a Model from the Data Hub Training Solution
Requirements
Data Hub v9.0 or later
Create a new data model
Click NEWResource > Model.
Select source
Under the Files & Other section, or the Training category on the left, select Data Hub Training.
From the source type pop-up, click Deploy on the Data Hub Training entry tagged Model.
Connect
The Data Hub Training connection details are pre-filled for ease of use.
Click Test Connection to verify that Data Hub can connect to the Data Hub Training data source.
Click Next.
Configure source
Specify which Company entities to include for analysis by selecting or clearing the check box beside the entity names.
Select the Primary Company check box for the primary entity (if there is more than one entity).
Click Next.
Create model
To deploy the data model provided by the Solution, complete the following fields:
Model name - Enter a name for the new data model.
Model location - Click Browse and select a root directory for the data model using the Select Folder pop-up window. New folders can be created by right-clicking on existing folders and selecting New Folder.
Model database name - Enter a name for the data warehouse table to be stored in Microsoft SQL Server. If the Model Database Name is already in use, attempting to create the model will not proceed until the Model Database Name is changed or the Ownership of the existing table is changed.
Deploy analytics - When checked, analytics provided by the Solution is deployed during model creation. When cleared, analytics will not be deployed during module creation and will need to be deployed later from the model task pane.
Modules - Select the pre-packaged modules to be deployed for this data model.
Once the model is configured, click Create Model. The model creation process takes several minutes.
Financial dimensions
Choose/Omit financial dimensions, depending on what may be applicable to your model. If none are chosen here, they can be added at any time from the data source screen once the model has been created.
Click Next
Select from the four calendars provided:
Note
All four calendars start on January 1 by default. This can be changed using the calendar pane.
Calendar YQMD - Calendar: Year, Quarter, Month, Day
Calendar YWD - Calendar: Year, Week, Day
Fiscal YQMD - Calendar: Year, Quarter, Month, Day
Fiscal YWD - Calendar: Year, Week, Day
Click Finish.