i have following fileds in the cube, Product group, fiscal year (2007 actual vaues) , branch, quarters, value type(10=actual, 20 = planned).
i am trying for a copy function to copy the actual values of 2007 to 2008. my settings are fileds to be changed are fiscal year from 2007 to 2008, value type 10 to 20. but i am not able to get this ...when i copy it is copied as year 2007 only with value type 20. it should be 2008 and valu type 20....
in my layout i am using the comparison colomn for actuals 2007 and input enable for 2008. iam using var for 2007 and with an offset +1 for 2008
so please suggest me what kind of settings do i need to make.?.apart from existing?