BIX PageList table mapping
When mapping same table in the 'to table' for a pagelist in the Business Intelligence Exchange (BIX) extract rule form, a warning is being thrown stating that same table may not be provided for two different pagelists.
But in the earlier version of BIX that is BIX 6.3, there are no such limitations. See the use case below.
Usecase: User has a parent cover case that initiates two child sub cases having the different data and gets merged into the parent case after the child case is closed. These two data pages is merged into the parent page list separately but mapped to the same table in the BIX as the variables are same.
Steps to Reproduce
1. Create an extract rule.
2. Map two pagelists on the rule.
3. Try to define the same 'to table' to different pagelists.
A validation has been introduced in BIX 7.1 to restrict users in providing one table to multiple pagelists.
As a same table name cannot be used with different pagelists, follow the below steps:
1. Create a synonym or alias for the original table.
2. Repalce the synonym / alias in the To_Table field in the pagelist mapping.
After the above change, data gets inserted into the same table, as a synonym would point to the same table in the database as the original table.
0% found this useful