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)    Trigger PMF Measure Loads without RC?
Page 1 2 

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Trigger PMF Measure Loads without RC?
 Login/Join
 
Guru
posted
Hi,

My client has a custom process for running ETLs, various DW jobs, checking refresh statuses, and restarting services if required. They do use Report Caster, but only as one part of the overall process of updating their data warehouse.

We have a built a staging process to load weekly chunks of measure data into PMF-ready format. This piece will slot in very well to the custom refresh process.

The measure by measure scheduling in PMF using RC might be a bit of an issue. It has no awareness of the flags they have set to indicate the latest data is ready to be used. There is also an issue about if the data refresh goes quickly, PMF won't run the job sooner than it's scheduled, even if the data is ready.

So... long story, short question: Is is possible to trigger a PMF load from outside PMF?

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Platinum Member
posted Hide Post
Here is an opinion of how it could be done:

From what I have seen the measure loader scheduler invokes the Report Caster interface , the traditional one with all the tabs. The customer may have a process with its DW process that updates a flag in a MSSQL table. Webfocus can read that flag via a pre-procedure in Report Caster. We can then set the &&KILL_RPC flag in order to run the schedule or not.

This could be an option with multiple time intervals or schedules.

Regards,Merci


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
 
Posts: 127 | Registered: March 02, 2009Report This Post
Member
posted Hide Post
Hi,
(the client) Actually the flags are files that are created and deleted for each process during the datawarehouse refresh and laod. Not actual flags in a database.
Amanda


Business Analyst - Specialist in Business Intelligence
 
Posts: 24 | Registered: March 12, 2009Report This Post
Master
posted Hide Post
It is certainly possible to schedule loads without ReportCaster but this process of course requires work. With Caster it requires no work of course.


  • MEAS_LOADER_SCHED - measure loader schedule interface. Call the FOCEXEC passing measure number for the measure series you want to load. You can get the measure series number by doing a lookup on measure name.
  • DIM_LOADER_SCHED - dimension loader schedule interface. Call the FOCEXEC passing dimension code (single letter code).


Note that specifics of calling into the WebFOCUS server to run a procedure from an OS shell depend on the platform, and can be found in the standard WebFOCUS documentation.

Hope this gets you on the right track.


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
Hi,

Thanx for the feedback. Ideally we want to use Caster completely and not need to do extra work.
Current status is for every existing measure we load it into PMF three times.

So if their are 30 measures, and we schedule each loadable measure, that would be 90 schedules. We obviously do not want to do that.

We are looking at having one schedule called over and over again with different parameters.
An alternativve would be to incorporate code to the existing ETL process as a parameterized step.

I will keep everyone posted of our final solutions.

Thanx.


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
 
Posts: 127 | Registered: March 02, 2009Report This Post
Platinum Member
posted Hide Post
I created a prototype to load measure via a fex outside of Caster.
At a High Level this is what it does.

I capture the measure series via the PMF_MEAS_SRC table.

Once I have the id I pass it as a parameter to the MEAS_LOADER_SCHED focezec. It will load the fex with the load characteristics in place.

I have done this succesfully for a test measure. I will try and load several or all measure of my deployment calling the same fex within a Loop and passing different parameters.

Will keep all posted.

Merci

A plus tard. John


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
 
Posts: 127 | Registered: March 02, 2009Report This Post
Platinum Member
posted Hide Post
Dimension Section...

I ran into an issue with the load of the dimension when I try to load a dimension from a focexec I get the following error.

Compilation failed for called Procedure: DIM_LOADER.

When I try to schedule a PMF schedule I get the following error in the Report Caster Log.

Starting worker thread
Starting task: Task for Schedule
Task type: EDA RPC
Procedure name: DIM_LOADER_SCHED
Connecting to server EDASERVE with execution id admin
Executing focexec.
About to run Dimension Loader for Dimension Type: H
Compilation failed for called Procedure: DIM_LOADER.

Measure Section.

I am able to schedule a measure load with RCaster within PMF with Success.

We will need some assistance for the Dimension Section.
Should we open a case on this ?

Merci , John


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
If you're running outside caster, you're sort of working in a way we don't code for or test. You should be able to get it to work but the scheduler must call into IBI software in a compliant way.

PMF load jobs called from Caster also take into account the APP PATH as set on the server (e.g., you should call into the WebFOCUS server the way the WebFOCUS Client does), and you have to make sure to pass the proper parameters to the job. The dimension code, an uppercase letter, must be passed as a parameter to the loader FOCEXEC. Also, the execution ID "admin" might not be enabled for PMF... remember, PMF is a secure environment and the user ID must be enabled as a PMF admin within PMF authorization (Owners); IBI/MR special IDs like "admin" don't grant you any special rights in PMF.


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
Presently I am trying to isolate this with PMF.
I am scheduling Loads with the Schedule button in PMF.
If I schedule a measure with the PMF button it works
If I scheduled a dimension with the PMF button it fails.


They both use the same execution id.
The App Path is the same.

I am trying to see anything that is different between these two processes in terms of environment settings.


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
 
Posts: 127 | Registered: March 02, 2009Report This Post
Member
posted Hide Post
You mention that "If I scheduled a dimension with the PMF button it fails." Which part is failing, the load, or the creation of the schedule? What is the error you are getting?





 Rob Recker
  Information Builders
800 . 736 . 6130
 
Posts: 8 | Location: New York | Registered: November 09, 2004Report This Post
Platinum Member
posted Hide Post
The Creation of the schedule is fine.



The load is failing.
This is the Caster log

Starting worker thread
Starting task: Task for Schedule
Task type: EDA RPC
Procedure name: DIM_LOADER_SCHED
Connecting to server EDASERVE with execution id admin
Executing focexec.
About to run Dimension Loader for Dimension Type: H
Compilation failed for called Procedure: DIM_LOADER.



Note * I can manually load a dimension in PMF.

Regards,John


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
Compilation failed implies a maintain error.

You can manually load a dimension but can you manually load the *H* Dimension?

Is there anything special about the *H* dimension... any prefix code being used, etc.? Any temp tables being built for it?

Is Caster running the same exact maintain environment as you are running while you're in PMF?

If we don't get indications from the answers to these questions you'll need to go to CSS and open a case and let them get into serious debugging. It sounds like a discrepancy between the environment Caster runs in, and the one live WebFOCUS runs in... but that's a guess without further info.


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
Hi,

I don't understand the *H* dimension question?

We have three dimension here and they load fine when clicking on the load button within PMF.

I opened a case with CSS and uploaded trace files as well as a screen shot of the compilation error.

Our regional SE will be onsite on Thursday to investigate . I will keep you up to date as the process continues.

Thanx


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
The "H question" referred to the information from the Schedule trace: "About to run Dimension Loader for Dimension Type: H". The DImension type (single letter code for the dimension) is coming over as "H".

We'll also have a look at the case...


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
Member
posted Hide Post
Hi,

I am continuing on malapejohn footsteps BUT i would like to make it work through RC. Right now, when we schedule a Dimension load in PMF with the Schedule button, then go into RC, the job is created and calls DIM_LOADER_SCHED. When the job runs, the process hangs at MODIFY and we have to kill the job. In PMF, if we use the LOAD button, it works out fine.

Back in RC, if we open the job and open up the task, we cannot click on ADVANCED... given us an error that it cannot find the fex. I think it's normal because for the MEAS_LOADER_SCHED, it does the same thing but yet it works.

So, my understanding after some research, the DIM_LOADER_SCHED calls PMF_DIM_LDR_LOAD which the LOAD button in PMF also seems to call. The DIM_LOADER_SCHED seems to set some parameters that PMF doesn't need to prior to calling PMF_DIM_LDR_LOAD. In DIM_LOADER_SCHED, if I comment out the INCLUDE PMF_DIM_LDR_LOAD, i can open the ADVANCED button in RC for DIM_LOADER_SCHED, which tells me, something in PMF_DIM_LDR_LOAD is not permitting RC to open the parameters (ADVANCED) list.

So, next, we tried calling the DIM_LOADER_SCHED from a command dos with edastart.bat -x "DIM_LOADER_SCHED" R which seems to run but does a loop back at the end, and no changes were seen for the dimension in PMF.

Going through the mainstreet app folder, I found a few fexes like DIM_LOADER, DIM_LOADER_LOAD and our DIM_LOADER_SCHED (also PMF_DIM_LDR_LOAD). What are the differences between these except for PMF_DIM_LDR_LOAD?

Also, you have any tips for making the DIM_LOADER_SCHED work in RC? Where should I go to see logs or detail but the problem is that it hangs, so I doubt it will be useful.

Thank you for reading,


WebFOCUS 769
Windows 2003 SP2
Tomcat app server
Excel, HTML, PDF
 
Posts: 17 | Location: Montreal | Registered: March 05, 2009Report This Post
  Powered by Social Strata Page 1 2  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Trigger PMF Measure Loads without RC?

Copyright © 1996-2020 Information Builders