The best way to add calculated column in SEI Dashboard/View

Sage Enterprise Intelligence empowers enterprise customers, managers, and executives to provide and analyse enterprise stories, dashboards, and views.

In SEI knowledge fashions, we are able to add reality desk and different tables as properly and we are able to add columns from that tables in knowledge fashions as a dimension or a measure in dashboard and views. However typically we require totally different worth fairly than the worth of current columns so for that we have to create a brand new calculated column to fetch the required worth.

Following are steps so as to add calculated column in knowledge mannequin of SEI.

  1. For including calculated column, in knowledge mannequin display screen of SEI there are two strategies so as to add calculated column as follows:
  • There may be an Insert button in above row of SEI knowledge mannequin display screen. Click on on Insert button as proven in determine 1. There are two buttons for including desk and second one is ‘Add calculated column’. You may have click on on this button so as to add a column.
Fig 1 : Add calculated column button in Menu
  • Second methodology so as to add calculated column is clicking on already given add calculated column icon in second row of knowledge mannequin display screen as proven in determine 2.
Fig 2 : Add calculated column button (Direct)

2. After clicking on Add calculated column button utilizing any of the above methodology, one new column is added to the information mannequin fields as a final subject. If you wish to add new column in between any subject of knowledge mannequin then first it’s worthwhile to choose the sector after which it’s a must to click on on Add Calculated Column button. It is going to show new subject after the prevailing subject which you needed so as to add subsequent of it as proven in determine 3.

Fig 3 : Newly added calculated subject

3. As proven in determine 3, New calculated column is added in your knowledge mannequin, you may change Column heading for that subject. You may set visibility degree and format for that subject. Format may be Quantity, Share or foreign money. In format you may set decimal locations, main zeros, symbols and unfavourable format as properly. Additionally, you may select column kind for calculated subject reminiscent of Dimension Key, Dimension Knowledge, Measure Knowledge, Measure Calculated and Description Knowledge. Additionally, you may set description subject, description format, type order and in superior you may select datatype for that calculated subject.

4. Now most important factor is to do a calculation to show worth of that subject. For this we have to create components or want to put in writing code in SQL Script Builder.

5. For writing script, we have to click on on calculation subject from that new subject. After clicking on that, it should open SQL script builder as proven in under determine 4.

Fig 4 : SQL Script Builder

For instance, if you wish to show month identify as January fairly than 1. Then it’s worthwhile to write a script for that and after validating script you need to use that new subject in dashboard and views as proven in determine 5. It is going to show January fairly than 1, February fairly than 2 utilizing different fields or utilizing capabilities.

Fig 5 : easy methods to write and validate script

By following above steps, you may create new calculated subject fairly than current desk fields from knowledge fashions in SEI dashboard and views.

We could add calculated columns for needed knowledge to SEI views and dashboards by doing the above steps.

About Us

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

Greytrix caters to a variety of Sage X3, a Sage Enterprise Cloud Resolution, 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 Associate in East Africa, Center East, Australia, Asia, US, UK. We additionally provide best-in-class Sage X3 customization and growth companies, built-in purposes reminiscent of POS | WMS | Fee Gateway | Transport System | Enterprise Intelligence | eCommerce and have developed add-ons reminiscent of 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 varieties the spine of cloud integrations which might be managed in real-time for processing and execution of utility applications on the click on of a button.

Greytrix is a acknowledged Sage champion ISV Associate 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 info on Sage X3 Integration and Providers, please contact us at [email protected], We want to hear from you.

Related Articles


Please enter your comment!
Please enter your name here

Latest Articles