Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    duplicating measures in different environments

Read-Only Read-Only Topic
Go
Search
Notify
Tools
duplicating measures in different environments
 Login/Join
 
Platinum Member
posted
We have measures that are created in a Development environment that then need to be re-created in a Q/A environment and then re-created again in a production environment.

Is there an efficient way of copying the measure definitions to PMF in the other environments rather than manually creating every measure definition in the Manage tab in each environment?

Thank you.


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
 
Posts: 100 | Registered: September 15, 2010Report This Post
Master
posted Hide Post
This question has come up occasionally on the forum. See previous threads.

In general you can use snapshot/restore to move a mart from one environment to another. The alternative is manual creation. There's no way to move metadata between data marts yet.

We are thinking about how to accomplish this and the problem is that it isn't easy even if there were a copy function. If you copy a measure from one system to another, do you copy the load directives? How would differences in the source databases between the environments be handled? How do you deal with the fact that the systems might be not in sync in terms of the source data they are accessing? What should we do if the adaptor connections needed were not set up, or the master files were missing. And if the actual data was out of sync, which would pertain? You could have differences in Dimensions between the two systems, both in name and structure and values, and differences in Measure values between them.

No-one has yet responded on these questions, and we haven't got a design that makes sense for this yet. In 5.3, we're building some new capabilities that make measure and dimension creation and management of fiels and sources simpler and easier, but the whole question of how to move one or more bits of metadata between systems that are probably not in sync still eludes us.

We welcome your participation in the conversation regarding how to solve this.

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Platinum Member
posted Hide Post
What would be a step in that direction would a command or button to create a report with one click that listed all the parameters and settings for every measure definition.

This would make a handy checklist. This could also be the basis of a file that got "exported" from PMF in one environment and could be imported into PMF in another.

Regarding the issues you presented, just brainstorming... why not have this measure definition copy utility prompt the user for Y/N repsonses to these issues, and if the 2 environments are not 100% in sync in all aspects, then it only partially creates the measure definitions as much as it can safely do so. Even creating the measure names and descriptions and other such "safe" parameters would certainly be start and save time.


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
 
Posts: 100 | Registered: September 15, 2010Report This Post
Master
posted Hide Post
Well, hey! Progress: PMF does have the Administration reports which indeed do this.

If you look at Measures Load and Measures Metadata reports on Analytics, Administration, you'll have exactly what you need there.

You can even output these to Excel, thus making them saveable as worksheets.

This might make your life a bit easier...

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    duplicating measures in different environments

Copyright © 1996-2020 Information Builders