Skip to main content

Hi,

Let's say, i have a Employee table, with 3 fields, Name, EmpID Location. It has 1000 records.

Now, the requirement is, i should keep a OLAP table or something that sort of in View and in should have all the values of these 3 fields.

Now, after i created the report and send it to Management, they should have the provilage to change any value in the VIew itself and that should go and update in the Celonis Table itself. Is that possible?

 

Eg:

Name, EmpID, Location

John , 1000, USA

Peter , 1001, UK

Henry , 1002, UAE.

 

Now, from the View itself, if the client wants to update the Location of USA to 'America' in the front end itself and press okay, then the values should be updated in the view and underlying Table in the EMS. Is this achievable ?

Hi Sachin,

Yes, it is indeed achievable to allow management to update values directly from a View. Here's how it can be done:

  1. Augmented Attributes: Utilize Augmented Attributes to enable editing capabilities directly within the view. Augmented Attributes allow for the creation of editable columns in the view.
  2. Unique Identifier: Ensure that each record in your Employee table has a unique identifier. This identifier will be crucial for tracking and updating individual records when using Augmented Attributes.
  3. Create Augmented Attribute: Generate an Augmented Attribute for the desired record. This attribute will serve as the editable field.
  4. Auto-generated PQL Statement: When creating the Augmented Attribute, the system will generate a PQL statement. This statement retrieves and displays the desired value.
  5. Create New Attribute: Using the auto-generated PQL statement, create a new attribute.which will link to the original field to the augmented attribute. The attributes should look like this: CASE WHEN [here the auto-generated PQL statement from the Augmented Attribute] IS NULL THEN [here the original field from the data model] ELSE [here the auto-generated PQL statement from the Augmented Attribute] END
  6. Profile View Configuration: Configure a Profile View to enable the editing functionality. The parent view will display the attribute created in the previous step. Upon clicking on a value within this attribute, a new view with the Augmented Attribute should appear, allowing management to edit the value directly.

By following these steps, you can create a seamless experience for management to update values directly within the view, with changes automatically reflected in the Celonis EMS table.

If you need further assistance with any of these steps or have additional questions, feel free to ask!

 


Reply