Sprinkle has redesigned and renamed cube feature into models with more simplicity and implementing additional features.
Models, a powerful feature in Sprinkle that helps in presenting multi-dimensional view of table. It can be created without any SQL queries, it is configured with simple point and click user interface.
Primarily Models comprises date dimension, dimensions, measures. Dimensions are the attributes on which the measures are calculated or grouped, and date dimensions are basically used to constrict the data within a timeframe.
Segments --> Models
The model page consists of 4 tabs, namely, Table, Column, Expression and Joins.
The table tab contains an overview about the model, the name of the schema and the table on which the user wants to create a model. For creating a model, a table has to be selected and its columns needs to be mapped to Measures and Dimensions fields.
In the column tab, the list of columns of a given table will be catalogued. Here, the user selects dimensions, measures at different aggregates like sum, average, count, distinct count, etc whereas in date dimensions, the time frame can be set for yearly, quarterly, monthly, weekly, daily and hourly basis.
Sprinkle allows users to create calculated columns at model level. These calculated columns might be a dimension expression or measure expression on a given table. The tool also supports dynamic bucketing where users can give just the ranges and variable name and the buckets are created easily.
Joins is a feature which allows the user to join the fact table (from which the model is created) with other models. All the dimensions present in the joined Model can be used in this model. For example, an Order Model having customerId as one of the columns can be joined to Customer table. Similarly it can also be joined to Product table.
User attributes are used to create relationships between users and artifacts. Sprinkle supports user attribute concept. This keeps the relevant users informed when an artifact is updated; Say, the user has two showrooms for their business, one in Bangalore and the other in Mumbai. There will be store managers respectively who take care of the operations. With Sprinkle, while creating reports the user can access the user attribute feature to perform restrictions where one store manager would be able to access just their operational store’s data but not others’.
This helps in detailed understanding of reports to the concerned person and also channelizing the information.