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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Target Entry
 Login/Join
 
jsp_lbf
Gold member
posted
It is my understanding that in a loaded measure the target information to be loaded must be in the same table as the actual data. The exception would be if the target is fixed and input during the measure creation.

unfortunately, in our ERP environment most tables do not contain targets. Therefore, what we have been doing is creating a duplicate or subset of a table from ERP and then uploading target values from Excel so that we have a data source containing both. This is time consuming and error-prone.

If would really be a nice enhancement to allow fixed target entry manually on a by-month basis, so that I could put in measure targets for the entire year, and then hit the ERP table just to get the actual value only. I don't know if this is in development or is even possible.

Any other suggestions for handling this situation in a more efficient way would be greatly appreciated.

Thanks in advance.

PMF 5.1.1
 
Posts: 60 | Registered: December 30, 2008Report This Post
Bob Jude Ferrante
Master
posted Hide Post
Targets are currently stored period by period. If your lowest level for a measure is months, they are stored month by month.

As for the fact that actuals and targets have to be "from the same table," they actually don't; they could come from separate sources; you'd JOIN the two sources together for a load. Or you could put them into an ODS.

Future PMF will allow separate sourcing of actuals and targets, but this is many months away.


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


Copyright © 1996-2020 Information Builders