Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Digizuite™ Insights provides a self-service SQL interface, where business analytics developers can access the raw data directly, and integrate towards existing internal BI tools and user interfaces. On top of that, we also provide a powerful business intelligence reporting service built on Microsoft™ Power BI.

Self-service analytics

To support integrators that have their own cube technology and/or visualization, Digizuite™ Insights deliver a self-service SQL access. This access is only provided on request because it could potentially require some extra data warehouse setup. Within, integrators will find best practice business intelligence structures, along with all documentation.

Image Added


How to access

You need a connection string provided by Professional Services. This will give access to the SELFSERVICE schema and views.

Documentation

Each view is documented individually and may be seen by invoking the spHelp stored procedure.
In the below example we are getting documentation for the "Periods" view:

Code Block
EXEC [dbo].[spHelp] 'Periods'

The response output will be like this:


Code Block
Description:	Contains period definitions (LY=Last Year, LW=Last Week etc). 
				These provides an easy way to add new date period dimensions without changing anything else.
Type:			Dimension

There are 4 different types of views:

  1. Fact
    This type of views contains facts about actual usage.

  2. Dimension
    This type contains a dimension

  3. Binding
    This type is for binding other data, typically dimensions.

  4. Setting
    This type contains settings that may change the output of the data (e.g. language, max, min).


Power BI

Microsoft Power BI usage and documentation is not covered here.

Language

Language is controlled by the default language in the Digizuite™ DAM Center.