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)    Question concerning Dimension Load(s)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Question concerning Dimension Load(s)
 Login/Join
 
Platinum Member
posted
Hi,

Customer has loaded dimension once in their production environment.
We know their are new dimension values that have been created by source systems.

What would be the best practice to load these new dimension values?

Load only the new records and make sure the "Delete if not new" check box is unchecked?

Is it better to reload dimensions entirely? Full refreshes?

I am trying to get a decision with the customer on best approaches when loading dimension data on a weekly basis.

Merci,

A plus tard.


-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
Unlike the Measure Loader, there is no such thing as a "Full Refresh" on a Dimension Load.

If you wanted to simulate a "Full Refresh" on a Dimension, you would have to delete the Dimension and then re-create and re-load it. Needless to say, this would not be a good thing to do, since the surrogate keys (which are the hidden database keys that link the Measures to the Dimension values) would all change, and any Measure records using that Dimension would be invalid in the PMF database. In fact, it is for this very reason that PMF does not allow you to delete a Dimension if there are any Measures using that Dimension.

So the only option available to you on a Dimension Load is "Delete if not in new". Before going into details, it should be noted that there is no harm done by leaving this box un-checked (in other words leave all previously loaded Dimension values in PMF even if they are no longer in the source data). The worst thing that can happen is that you will see obsolete Dimension values on the Dimension Trees and drop down list boxes

So now, the decision to do a "Delete if not in new" depends on the nature of your business requirements. What does it mean that a Dimension value in PMF from a previous Dimension Load is no longer in your source data? Was there some sort of re-organization or change in your source data? Are there any source Measure records that were using this Dimension value and if so what happened to them? Are there any records now in PMF that are using this Dimension value and, if so, what should happen to them?

Once you've gone through this analysis, the answer should be clear; but if not, don't hesitate to ask follow up questions!

EricH
 
Posts: 164 | 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)    Question concerning Dimension Load(s)

Copyright © 1996-2020 Information Builders