Focal Point
Change in Measure

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

June 08, 2009, 01:36 PM
malapejohn
Change in Measure
Hello,

A measure has been created incorrectly.
Our measures can go down to class level(3) or style level(4).

We want to change a measure to go from 4 levels to 3.

In the measure loader screen can change we simply change it from style(4) to class(3)?

Do we have to reload all the data over?
Do we simply change and when reloading next Monday all the new transaction values will stop at level 3 and previous will continue to display at level 4?


Thanx,Merci.


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
June 08, 2009, 01:58 PM
SethW
Yes that is where you change the levels on a measure -- I think you are referring to the aggregation level. However, if you wanted to change the entire dimension, as you probably know is done on the dimension load.

I believe you do have to reload measure to make this change even though the key for the data may not change.

Assuming that you are using PMF's loader, you could actually reload the measure manually now if you wanted. Make sure in the measure loader you go in the order of "save", "preview", elemenate errors, "load." Loading manually shouldn't effect the scheduled monday loads.

- Seth


WF 7.65. Solaris. PMF 5.11 on Oracle 10g
June 08, 2009, 02:58 PM
Demanda
So, just to confirm, we would have to do a full refresh?

Amanda


Business Analyst - Specialist in Business Intelligence
June 08, 2009, 03:04 PM
Bob Jude Ferrante
Yea full refresh. Remember PMF stores values at that level and the higher level values are aggregates.
So if you change the level, you have to wipe the old ones out.

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!