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
copy consolidated element value to other cube
-
- 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
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.
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
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
-
- 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
okay... thank you ... the problem was solved