In order to start working in GoodData, you need to specify the data model for your data. Here's a couple things you should know:
- Each dataset is represented by one star schema or a dimension (multiple linked attributes without a fact)
- Multiple datasets can be linked together to represent a snowflake schema
- On the lowest level, data model is described using MAQL DDL language
- GoodData CL makes modeling easier by generating MAQL DDL out of an XML Schema
In order to generate a data model, you need to run one of the
Load* commands, and then proceed to
GenerateMaql (which produces a MAQL file) and
ExecuteMaql (which runs this MAQL in your project on GoodData server). See
examples and
documentations for more.
Next: Load ▶
- Your data model from previous step determines a Data Loading Interface (DLI)
- GoodData CL automatically transforms your data into the DLI/SLI format
In order to load data, you need to run one of the
Load* commands before running one of the
Transfer* commands. See
examples and
documentations for more.
Previous: ◀ Model
Next: Report ▶
- GoodData uses the data model (the mapping between logical and physical data model) to automatically create database queries based on your reporting
- Structure of the data model determines what attributes/facts can be used in a single report together
Sometimes you see "grayed out", inactive attributes/metrics in What/How dialog when constructing a report. The connections in data model are the root cause. The selected combination of existing attributes and metrics cannot be connected to some other attributes and metrics. We deactivate these in the 3CD to save you the trouble of constructing reports that cannot be computed.
Contact us if you have questions around how to create your data model
Previous: ◀ Load
