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 firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
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.
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!