Like to Like Comparison Dimension -
01-10-2006
, 02:26 PM
I am using AS2000 and my company wants a like to like dimension added to our
sales cube. The way it works in traditional reports is by filtering out
store locations that we not open for the full time period selected i.e. if
store 2 opened in the middle of the year it would not be a like to like store
for a full year comparison of company sales. So this store’s total dollars
would be omitted from the like to like report. Does anyone know how to set
up something to accomplish this type of behavior in AS2000? |