Part 8: Creating New Dimension Elements During Writeback

In this tutorial we will complete the Employee Management tab of the application which will allow the user to add an employee to the workforce list. This involves adding a new member to the employee dimension and updating the data for the newly created employee all in a single step perceived by the user. The application does not need force the user to create a new employee first, and then edit the details, as is frequently done.

Adding a new employee involves updating a dimension with a new member and then writing associated information to the cube that the dimension was used in. Performing this operation using a TI script can be problemmatic, especially when a large number of users are creating new dimension members at the same time. Timing is critical and you need to guarantee that the newly added member is also the same member the data being written back to, or you will have corrupt data.

This module shows how to ensure data integrity is maintained during this process. In one perceived operation by the user, this module will create a new member, update the information in the cube and then execute a TI process to allocate the labor expense in the corresponding months. This module also illustrates how to create local datasources from JavaScript arrays.

Highlights

• Define and bind to module level fields within an HTML form
• Create datasource based on an array of values
• Review ESWeb rules for writing back data with new members to TM1
• Use an ESWeb view to create new members
• Define a datasource at runtime and use it to update TM1
• Properly structure multiple requests that alter dimensions to ensure data integrity

Live Application

Part 8 - Creating New Dimension Elements During Writeback

Video Walkthrough

Video Coming Soon