Focal Point
Q: Changing product dim over time

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/158103332

September 08, 2009, 09:35 AM
Demanda
Q: Changing product dim over time
How in PMF is a dimension linked to time? Example: I have a hierarchal product dimension that is structured as Department, Class, and Style. Style ‘X’ was in class ‘B’, but as of July 2009 it is now in class ‘A’. In the product dimension loads I don’t see any reference to time, so how does PMF know the time of this switch? Is it recorded on the day the data is loaded into PMF?


Business Analyst - Specialist in Business Intelligence
September 08, 2009, 02:12 PM
Bob Jude Ferrante
Dimensions are not interlinked. Measures are linked to the dimensions. If a dim changes, you can make several choices. Have a look at other answers to similar questions about this on the forum.

If there is measure data for a particular dimension intersection - e.g., say you have Location with a hierarchy Country \ Region \ State \ Office and you have a City called Central that's in Illinois. Then the central office moves to Michigan in Sept 2009. What do you want? Do you want metrics for the central office to show up in Michigan for past history until the future, or do you want them split so they appear in Illinois until Sept 2009 then they appear in Michigan? You can choose either option.

thanks
bjf


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!