Thanks, everyone!! Basically I need to create a subset (cube B) from a full set cube (cube A). Say cube A contains 10 years data of all regions, and cube B will contains only 3 years of 1 region. Since cube B is only a reference for the users, users will only read from it and no cell values will be ...
I am currently copying values from cube A to cube B by CellGetN and CellPutN. However, consolidated cells cannot be copied on cube B since the values are overwritten by the consolidation from the children's values. Is there any ways to bypass the automatic consolidation feature on cube B?