The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Recommended Posts

Posted

Our organization likes the use of EBX column inheritance to ease some of the burden on data stewards. In one of our use cases, we utilize inheritance on address fields, including city, state, and zip code for example. We have a Site table which has the address columns and our data stewards enter the address information there. We also have a LineOfBusiness table and we inherit the address columns from the Site table. We do this because we do not want our data stewards to enter the information more than once. We also allow them to override the address fields on the LineOfBusiness (LOB) table because some LOB's can exist at a site, and the adress may slightly differ.

Here is our challenge: We have custom reports we have created that show the addresses foreach LOB. We rely on using the EBX replicated table as the source for the reports. Unfortunately, inherited columns, computed columns, etc, do not have persisted values in the replicated tables. We have implemented custom code to overcome the challenge, but there are several draw backs in our implementation.

What is the best way to take advantage of EBX column level inheritance and get persisted values in the replication table Should we approach this without inheritance, or is there a way to configure EBX to replicate inherited/computed columns

Posted

Hi Mark,

Thanks for your comment.

Have you tried setting the Refresh Policy to "On demand" instead of "On commit" The refresh policy is located under the replication configuration of the data model.

This will allow the inherited values to persist, but it will only update the replicated table when you ask it to instead of an on-going basis; therefore you may want to create a task to populate the replication table over a defined period of time, if you decide to go this route.

 

Hope that helps. Let me know if you have any questions.

Regards,

Kevin

Posted

Hi Kevin,This is helpful, and thank you for the response.  Can you provide some guidance on how to create a task to have the replicated table refresh  Would this be a new scheduled task within EBX that we would create, or is there a built-in feature for thisThanks,

Mark

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...