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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you have any questions or need access: Contact myibi@ibi.com


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Accessing target values from a budgeting system
Go
New
Search
Notify
Tools
Reply
  
Accessing target values from a budgeting system
 Login/Join
 
Member
posted
I am setting up a measure load. The question I have is what is the best way to set up the load if actual and target numbers are contained in different systems? Specifically, I have a transaction table in a MS SQL database where I can access the actuals for various revenue fields. My targets will come from a budgeting system, located in a different MS SQL table. What is the best way to set up a load in this environment? Any advice greatly appreciated.


WebFOCUS is 7.6.11
Windows
all output (Excel, HTML, PDF)
 
Posts: 6 | Registered: July 22, 2010Reply With QuoteReport This Post
Master
posted Hide Post
In PMF 5.2, you'd need to merge the two sets of records into one logical view and then load from that logical view. If the two different tables are both in same MSSQL DB, you can simply do a cross table JOIN to create the structure. If they are in separate databases I recommend doing a merge to a single table and then using that table as your data source.

Of course this will all be a lot easier in PMF 5.3.2 which will allow management of data by source and will perform any merges for you automatically. But for now this is the answer.

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, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Accessing target values from a budgeting system

Copyright © 1996-2020 Information Builders