copy consolidated element value to other cube
Posted: Thu Feb 09, 2017 1:25 am
hi... i have two cube 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
-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