Semantic Query API

The Semantic Query API allows you to leverage your data in Data 360 through the Semantic Layer in order to answer a variety of business questions. You send a Semantic Query that references the dimensions, measurements, and data objects defined in your Semantic Model, and the API resolves relationships, applies filters and aggregations, and returns the result.

Use the links to the left to explore each part of the Semantic Query API:

• Overview — the request shape, how a query references a Semantic Model, and how queries are executed.
• Dimensions, Measurements, and Data Objects — select fields from the data objects in your model.
• Relationships and Joins — query across related data objects.
• Parameters — supply values to parameterized models at query time.
• Calculated Fields — reference model calculations or define inline ones.
• Functions and Formulas — the formula language used in expressions.
• Filtering — restrict rows with object, model, context, and aggregate filters.
• Grouping — group rows by dimensions.
• Aggregation and Totals — summarize measures and add subtotals and grand totals.
• Sorting and Limiting — order results and cap the number of rows.
• Predict and Forecast — query predicted values from EDC models and forecasted time series.
• Logical Views — query standard, union, custom SQL, and organizational-hierarchy logical views composed in the model.
• Shared Dimensions — analyze multiple fact tables along a common dimension.
• Currency and Fiscal Handling — currency conversion and fiscal calendar behavior.
• SemanticQueryRequest Fields — the complete request schema.

Each query topic links to the Authoring API Entities that define the corresponding metadata in the Semantic Model.