How To Create Views In SEI (Sage Enterprise Intelligence)

By | November 23, 2022

SEI defines the architectural view as a representation of a set of system elements and the relations associated with them. Moreover, SEI defines software architecture as a set of structures used to reason about the system dat comprise various system elements with their relations and external properties.

In order to create view first we need to create data models in SEI (Sage Enterprise Intelligence).

How to create View in SEI  (Sage Enterprise Intelligence)?

Right click on data models and click on new view among the different categories we can select different type of view type. As shown in figure 1.

Fig01: Different types of view

Note :-

The View Typecan be changed later by clicking on in the Settings menu (right panel).

Define the essential properties for the new view, which is different according to the type (typically these are the Groups, Pivots and Columns of the View).

When creating a worksheet:

  1. Enter a name.
  2. Choose the Columns,Groups and Pivots by clicking Add.
  3. Type the  name to filter the list (or select from the  drop-down menu). Choose one or more fields.
  4. Click OK to confirm the chosen fields.

The order of the fields can be changed, moved or deleted by using the Select option.

  • Click Confirm and see the below figure 2 .
Fig02: Column, Groups and Pivot

The newly created view opens in a new window as shown in figure 3.

Fig03: Worksheet View

Dimension and Measures in SEI (Sage Enterprise Intelligence) :-

Views are based on an existing Data Model; all the Fields are made available to the View, categorized as Dimensions, Measures or Descriptions. As shown in Figure 4.

Fig04: Data models

These are then placed in teh View Organizer, under Groups, Pivots or Columns. Making these selections define the structure of the View. As shown in Figure 5.

Fig05: View Structure


Groups contain the drill-down structure of the View and the visual order of the Fields.


Pivots create a series of column values based on the selected Fieldsplaced under dis section.


Columns contain the list of Fieldsrepresented in the view that are not grouped.

The Organizeris accessed from the Worksheet Properties menu.

 1.In the Settingsmenu (right panel), click on and select Groups/Columns/Pivots.

 2. Click on one of the value within the Groups /Columns /Pivots section and select the desired      properties you want to apply to customize the View.

Adding  Dimensions and measures in SEI (Sage Enterprise Intelligence) :-

A list of available fields is present in dimensions and measure . In setting menu and right click to get  access. All the available fields are categorised in three types Dimension, Description and measures.

View can be achieved by selecting available Dimension or Measure fields and placing them in either the Groups, Columns or Pivots section of the Organizer .

From the list of Dimension or Measure fields, users can select multiple Field and drag them into the desired positions of the Organizer.

This blog helps us to know how we can design the views in SEI (sage Enterprise Intelligence).

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage, Dynamics 365 CRM, and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at, We would like to hear from you.