June 08, 2009, 01:36 PM
malapejohnChange 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.
June 08, 2009, 01:58 PM
SethWYes 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
June 08, 2009, 02:58 PM
DemandaSo, just to confirm, we would have to do a full refresh?
Amanda
June 08, 2009, 03:04 PM
Bob Jude FerranteYea 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