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)    how to execute multiple/all measure loads once

Read-Only Read-Only Topic
Go
Search
Notify
Tools
how to execute multiple/all measure loads once
 Login/Join
 
<Bert Utrecht>
posted
For each measure we can create a schedule to load. Is it possible to create for example one schedule with multiple measure loads. I have changed the name of a dimension level and now want to load all the measures once by executing a full refresh for all loaded measures.

Kind regards,
Bert Utrecht
 
Report This Post
Bob Jude Ferrante
Master
posted Hide Post
You can call pmf_meas_ldr_load.fex multiple times from a single batch FOCEXEC. The only parameter it needs is the measure Series ID (a.k.a. MEASURE_SERIES), a number that represents the meaasure's internal ordinal in the PMF data mart.

You can get the Measure Series ID number from the Measure Loader panel for the measure.

That said, use this knowledge with a measure of wisdom. Depending on how many Measures you are loading and how much database extraction is required to load them, batch loading every measure in the system at once could take a lot of time to run; it can be a massive job that can take hours and bring an RDBMS to its knees. Remember, this is ETL. You might decide to only run it overnight for example.


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)    how to execute multiple/all measure loads once

Copyright © 1996-2020 Information Builders