copy consolidated element value to other cube

Post Reply
emma
Posts: 14
Joined: Thu Jan 26, 2017 9:57 am
OLAP Product: 11.2.0.3.0
Version: 10.2.20400.80
Excel Version: 2007

copy consolidated element value to other cube

Post 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
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: copy consolidated element value to other cube

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
emma
Posts: 14
Joined: Thu Jan 26, 2017 9:57 am
OLAP Product: 11.2.0.3.0
Version: 10.2.20400.80
Excel Version: 2007

Re: copy consolidated element value to other cube

Post by emma »

okay... thank you ... the problem was solved
Post Reply