How To Create Views In SEI (Sage Enterprise Intelligence)

SEI defines the architectural view as a illustration of a set of system parts and the relations related to them. Furthermore, SEI defines software program structure as a set of constructions used to motive in regards to the system dat comprise varied system parts with their relations and exterior properties.

With a view to create view first we have to create knowledge fashions in SEI (Sage Enterprise Intelligence).

create View in SEI  (Sage Enterprise Intelligence)?

Proper click on on knowledge fashions and click on on new view among the many completely different classes we are able to choose completely different kind of view kind. As proven in determine 1.

Fig01: Several types of view

Be aware :-

The View Typecan be modified later by clicking on within the Settings menu (proper panel).

Outline the important properties for the brand new view, which is completely different in keeping with the sort (usually these are the Teams, Pivots and Columns of the View).

When making a worksheet:

  1. Enter a reputation.
  2. Select the Columns,Teams and Pivots by clicking Add.
  3. Kind the  title to filter the record (or choose from the  drop-down menu). Select a number of fields.
  4. Click on OK to substantiate the chosen fields.

The order of the fields will be modified, moved or deleted by utilizing the Choose choice.

  • Click on Affirm and see the beneath determine 2 .
Fig02: Column, Teams and Pivot

The newly created view opens in a brand new window as proven in determine 3.

Fig03: Worksheet View

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

Views are primarily based on an current Information Mannequin; all of the Fields are made out there to the View, categorized as Dimensions, Measures or Descriptions. As proven in Determine 4.

Fig04: Information fashions

These are then positioned in teh View Organizer, below Teams, Pivots or Columns. Making these picks outline the construction of the View. As proven in Determine 5.

Fig05: View Construction


Teams comprise the drill-down construction of the View and the visible order of the Fields.


Pivots create a sequence of column values primarily based on the chosen Fieldsplaced below dis part.


Columns comprise the record of Fieldsrepresented within the view that aren’t grouped.

The Organizeris accessed from the Worksheet Properties menu.

 1.Within the Settingsmenu (proper panel), click on on and choose Teams/Columns/Pivots.

 2. Click on on one of many worth inside the Teams /Columns /Pivots part and choose the specified      properties you need to apply to customise the View.

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

A listing of obtainable fields is current in dimensions and measure . In setting menu and proper click on to get  entry. All of the out there fields are categorised in three varieties Dimension, Description and measures.

View will be achieved by deciding on out there Dimension or Measure fields and putting them in both the Teams, Columns or Pivots part of the Organizer .

From the record of Dimension or Measure fields, customers can choose a number of Discipline and drag them into the specified positions of the Organizer.

This weblog helps us to know the way we are able to design the views in SEI (sage Enterprise Intelligence).

About Us

Greytrix – a globally acknowledged and one of many oldest Sage Growth Companion is a one-stop resolution supplier for Sage ERP and Sage CRM organizational wants. Being acknowledged and rewarded for multi-man years of expertise, we deliver full end-to-end help in your technical consultations, product customizations, knowledge migration, system integrations, third-party add-on improvement and implementation competence. 

Greytrix caters to a variety of Sage X3, a Sage Enterprise Cloud Answer, choices. Our distinctive GUMU™ integrations embrace Sage X3 for Sage, Dynamics 365 CRM and Magento eCommerce together with Implementation and Technical Assist worldwide for Sage X3. At present we’re Sage X3 Implementation Companion in East Africa, Center East, Australia, Asia, US, UK. We additionally supply best-in-class Sage X3 customization and improvement companies, built-in functions akin to POS | WMS | Cost Gateway | Delivery System | Enterprise Intelligence | eCommerce and have developed add-ons akin to Catch – Weight  and Letter of Credit score and India Laws for Sage X3 to Sage enterprise companions, finish customers and Sage PSG worldwide. Greytrix Gross sales Fee App for Sage X3 simplifies fee calculations and postings on gross sales transactions.

The GUMU™ Cloud framework by Greytrix kinds the spine of cloud integrations which might be managed in real-time for processing and execution of utility packages on the click on of a button.

Greytrix is a acknowledged Sage champion ISV Companion for GUMU™ Sage X3 – Sage CRM integration additionally listed on Sage Market; 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 extra data on Sage X3 Integration and Companies, please contact us at [email protected], We wish to hear from you.

Related Articles


Please enter your comment!
Please enter your name here

Latest Articles