Each QQube Data Model is already configured for any version of Access 2013 or above. The underlying tables are already linked, and the relationships are already established. (In a typical data warehouse, there is only one way to attach the underlying tables).
All you need to do is open one of the examples, and refresh the links
Open up the Configuration tool, and highlight Microsoft Access under the Examples section. You should see a list of Access examples - at least one for each data model.
If you see a data model example grayed out, please review this guide on selection and synching.
Check the synch logs to ensure successful and accurate data extraction.
Open up the example from the QQube Configuration Tool. The Access database will open up to a blank canvas where there is at least one query example.
Retrieve your own data by invoking the Linked Table Manager as shown here, Select All, and click Refresh.
You should receive the following results:
If there are errors, go back to the First Step.
The single FACT table and associated DIMENSION tables are assembled for you, as there is only one way they can be connected.
Double clicking on the query example will show raw data
Looking at the design view for this example:
Please enable JavaScript to use file uploader.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/252/getting-started
Your session has expired. You are being logged out.