Business Intelligence

• Universe

Universe

Universes constitute the basis for the configuration of a new model that we will call universe model. Users can then exploit it, through the Query module and/or Power BI, to generate graphic reports.

Examples

Basic universe

The following example builds a universe called Universe1:

<Universe Identifier="Universe1" DisplayName_L1="Universe 1" >

    <EntityInstance Identifier="Directory_User" EntityType="Directory_User" DisplayName_L1="Users" />    <EntityInstance Identifier="Directory_UserRecord" EntityType="Directory_UserRecord" DisplayName_L1="UserRecords" />    <AssociationInstance Association="Directory_UserRecord_User_Records" Instance1="Directory_User" Instance2="Directory_UserRecord" Direction="From1To2" /></Universe>

When getting Usercube data in Power BI, we see the following:

Basic universe with identifiers instead of display names

The following example builds a universe called Universe1 with identifiers as labels instead of display names:

<Universe Identifier="Universe1" DisplayName_L1="Universe 1" ColumnNamesMode="Identifier" >    <EntityInstance Identifier="Directory_User" EntityType="Directory_User" DisplayName_L1="Users" />    <EntityInstance Identifier="Directory_UserRecord" EntityType="Directory_UserRecord" DisplayName_L1="UserRecords" />    <AssociationInstance Association="Directory_UserRecord_User_Records" Instance1="Directory_User" Instance2="Directory_UserRecord" Direction="From1To2" />    </Universe>

When getting Usercube data in Power BI, we see the following:

Properties

Property	Details
ColumnNamesMode default value: DisplayName	Type UniverseColumnNamesMode Description Type of label to be displayed as the column names in Power BI, for this universe. 0 - DisplayName: display name of entity instances. 1 - Identifier: identifier of entity instances.
DisplayName_L1 optional	Type String Description Display name of the universe in language 1 (up to 16).
Identifier required	Type String Description Identifier of the universe.

Child Element: AssociationInstance

An association instance represents, within a universe, the occurrence in the model of an entity association.

Properties

Property	Details
Association required	Type Int64 Description Identifier of the entity association, in Usercube's entity model, that corresponds to the association instance.
Direction default value: 0	Type Direction Description Direction of the association between the two entity instances. It must be the same direction as between the two entity types specified in these entity instances. 0 - Both directions. 1 - From the instance 1 to 2. 2 - From the instance 2 to 1.
Instance1 required	Type Int64 Description Identifier of the entity instance number one.
Instance2 required	Type Int64 Description Identifier of the entity instance number two.

Child Element: EntityInstance

An entity instance represents, within a universe, the occurrence in the model of an entity type.

Properties

Property	Details
DisplayName_L1 optional	Type String Description Display name of the entity instance in language 1 (up to 16).
EntityType required	Type Int64 Description Identifier of the entity type, in Usercube's entity model, that corresponds to the entity instance.
FilterEntityProperty optional	Type Int64 Description Entity property used as filter (FilterProperty must be a navigation property to EntityProperty)
FilterEntityType optional	Type Int64 Description Entity type used as filter (FilterProperty must be a navigation property to EntityType)
FilterProperty optional	Type Int64 Description Property used to filter entity type's instance.
FilterResourceType optional	Type Int64 Description Resource type used as filter (FilterProperty must be a navigation property to ResourceType)
FilterValue optional	Type String Description Constant value used as filter.
Identifier required	Type String Description Identifier of the entity instance.
IsHidden default value: false	Type Boolean Description true if the entity instance is to be hidden in Power BI.