I have two cubes here, first cube that have a dimension STORE WHICH HAVE ELEMENTS SUCH AS
-branch(CONSOLIDATED)
-regency(CONSOLIDATED)
-Subdistrict(CONSOLIDATED)
-village(CONSOLIDATED)
-store(LEAF ELEMENT),
also have a measure value ( amount ), period (month and year)
and the second cube have a dimension subdistrict that consist of branch(consolidated) and subdistrict(element)
... and the problem is..
I want to copy consolidated amount of subdistrict from first cube and put it to dimension subdistrict in second cube....
Why not use rule? because STORE elements and SUBDISTRICT element are dynamic dimension so i can't mention all of store data and subdistrict data in rule.
thank you