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 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)    Migrate configuration but not data from Dev to Prod?

Read-Only Read-Only Topic
Migrate configuration but not data from Dev to Prod?

Here's the situation:

We've got a production environment that has lots of data, but only live measures. This means that they have been UAT'ed and validated, and are used by the business.

We've got a development environment that has "moving target" data, depending on what's being worked on. It has all the live measures and some development measures. I'd describe a development measure as a work in progress, and it may or may not have data, but it will have a configured measure metadata and loader for each.

Now, the user asked me today how they would migrate the development measures to prod. I suggested re-keying them, but that didn't go over well. She had a valid point about how re-entering something could lead to errors not present in dev, plus something about re-work being bad...

So, is it possible to backup a portion of the Dev datamart and restore that portion in Prod? Just the configuration bits, not the data. If not that, is there a best practice for this sort of thing?



-WebFOCUS 8.2.01 on Windows
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
posted Hide Post
SO we've had two questions about this in a few days... are you both from the same company? Or is this just a topic that's gaining currency?

I'm sort of going to paste my response to the other topic to this one as well...

We haven't and aren't yet making a commitment to do such a thing yet. But we coudl explore the implications and expectations for such a capability. So...

What aspects of a measure would you think should be transportable between instances? Is it just the measure definitions and metadata, or the values as well which you would primarily are interested in transporting? Would you expect the software to indicate if the data could not be correctly synchronized between the environments due to things like naming conflicts, dimensions not loaded on target, dimensions loaded differently between the source and the target? Any other capabilities you would expect from this?

Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management

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

Posts: 919 | Registered: March 26, 2003Report This Post
posted Hide Post
Hi Bob,

Thanks for the reply. I did notice the other post as well, and yes, that's a post by my client (trigger dramatic musical flourish... Duh duh duuuuh)!

To answer your questions and feedback:

I would love to be able to transport my dashboards and gadgets, since I'm starting to build them for my next phase. The fact that you said that's in development means I will have to do it manually for now, so that's something for me to plan for. Good to know.

We would like to transport just the measure definition (the Edit Measure screen contents) plus the setup of the Measure Loader (field mappings, source table, refresh method). Naming conflicts or missing dimensions should cause a full stop of the migration, in my opinion. Differently loaded dimensions would show up when we try to load the measure, so that's not something that needs to be handled.

Suppose, just suppose, that we wanted to try to extract the measure info from the datamart... is there any guidance you could provide as to which tables would be involved? I'm not saying we'd extract from dev and then load into prod, but if we could extract from dev, manually key in prod, extract from prod, we would have a solid method to compare setups between environments (examine the two extracts for differences).


Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
posted Hide Post
Yes I agree with Joey on what he suggests to transport: Edit measures contents and the contents on each of the tabs of Measure Loader(Dimensions, Field Maps and Filters)

Business Analyst - Specialist in Business Intelligence
Posts: 24 | Registered: March 12, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Migrate configuration but not data from Dev to Prod?

Copyright © 1996-2020 Information Builders