Page 1 of 1

copy consolidated element value to other cube

Posted: Thu Feb 09, 2017 1:25 am
by emma
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

Re: copy consolidated element value to other cube

Posted: Thu Feb 09, 2017 7:03 am
by Wim Gielis
That's not a good line of reasoning I'm afraid.
If a rule applies to all stores then just leave it out of the left hand side of your rule.l and the rule applies to all elements.

Re: copy consolidated element value to other cube

Posted: Fri Feb 10, 2017 3:39 am
by emma
okay... thank you ... the problem was solved