|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/19/2007 3:04:00 PM
Posts: 3,
Visits: 1
|
|
We currently have over 500 Legends in our CRM Application and we manually refresh Legends as needed using the CRM Metadata application.
Does anyone have a way to automate such a refresh?
|
|
|
|
|
Junior Member
Group: Moderators
Last Login: 7/21/2008 2:27:50 PM
Posts: 24,
Visits: 9
|
|
Hello,
What version of TCRM are you using. There were some enhancements added in version 5.1 that should help automate what you want to do. Before TCRM 5.1, in order to pick up certain metadata changes, all Middle Tiers would have to be shut down and the buffers deleted. Now with 5.1 and later, the offline Middle Tier components are designed to refresh any outdated buffers automatically when necessary. As a result, metadata changes (such as modifying a legend) can be used immediately.
Also, what part of the process do you want automated? Once a legend change is made in TCRM Metadata, in version 5.1 TCRM metadata automatically updates the middle tier buffers. So, whenever a TCRM client logs into the application, they get the latest set of legends. Is this the part you want automated or are you referring to some other part of the process?
thanks,
Carol
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/19/2007 3:04:00 PM
Posts: 3,
Visits: 1
|
|
We're on CRM 5.1.1.2.
What we're trying to accomplish, is a way to refresh a legend when a new value has been added to a table.
For example:
A new value shows up in a table/view (e.g., 'U' for Unknown). Because we haven’t refreshed the range, the 'U' won't be one of the values in the legend. We're looking for a way to automatically pick up the 'U' in the legend without signing into the Metadata application and manually refreshing that one legend.
Since we have over 500 legends with the potential of new values being added to the tables/views, is there something we could run to refresh all Legends at one time.
I apologize if I'm not communicating this very well.
Thanks,
Robby
|
|
|
|
|
Junior Member
Group: Moderators
Last Login: 7/21/2008 2:27:50 PM
Posts: 24,
Visits: 9
|
|
Hello Robby,
Asked some of our CRM SME's to get you an answer. Here is what they came back with.
There is no facility to automatically update a legend range value after it has been changed in a table/view. However, it could be accomplished through some relatively straightforward customization that would utilize the Windows Scheduler to run a process written to let TCRM know that tables containing the legend range value(s) that have been changed. The Teradata CRM application needs to know that some of the legend details have changed and that the next time a user (client PC) accesses these records, there may be a need to re-buffer the data. To do this, the Table Alias records (IOS_TBL_ALIAS table) need to be updated for the tables impacted which could be accomplished using a custom written script run in an automated fashion using the Windows Scheduler. This will update the tables in Teradata CRM so that they will be buffered again as needed.
Let me know if this answers it for you.
Thanks for your post!
Carol
|
|
|
|