How to view data in different formats in SEI

By | May 29, 2024

We are able to produce reports, dashboards, and views with Sage Enterprise Intelligence. Additionally, SEI makes data analysis simple. Users may choose to view data in SEI in a different format at times. This blog post will explain how to see data in various formats within SEI.
Figure 1 illustrates how only the data code is visible when a column is added to SEI dashboards and views.

Fig01: SEI data record
Fig01: SEI data record

But occasionally, a user might like to add a code, a description, a title, or a mix of all four. Therefore, we need to take the actions listed below in order to accomplish that.

The following are steps to display data in different formats.

  1. As seen in fig. 2, you must first access the data model screen in SEI and choose the field from the column screen.
Fig02: Data model screen
Fig02: Data model screen

2. The following step is to choose the description format from the field where you want to enter the title or description code, as seen in fig 2.
3. As you can see, data is shown in several formats.
Title code description: When using this format, the field name, code, and description for that specific field will be displayed with a space between them.
Code for title description: Code is shown with a space between it and the title description.
Only the title and code are displayed, separated by a space.
Title and description only are displayed, separated by white space.
Description of code: Just the code and a space are displayed.
Code: Only Code and a space are displayed.
Only the description is shown, separated by space.
Code for description: Code is shown first, followed by a space.
Title-Code-Description: Shows the code, description, and title together with

After setting the description format save the data model and add that field in dashboard or view. You can see the data as follows:

  1. As shown in figure 3, how data will be display in Code-description format.
Fig03: Code description format
Fig03: Code description format

In fig 4 you can see that how data will be display in code description.

Fig04: Data
Fig04: Data

We can analyze data easily in SEI. In this blog we will see how to view data in different format in SEI. However, on sometimes, a user wants to add a title, a description, a code, or a combination of all four. Therefore, in order to do that, we must take the steps described above. 1. 2. you can see different formats to display data as follows. After setting the description format save the data model and add that field in dashboard or view.