Exploring TM1 - a Chartertech Company
Search
Close this search box.

Cube Links – Avoiding Overlapping Links from Multiple Cubes

I have been trying to work out how to make rule driven links between two cubes work properly today.  One key thing that I have learnt from the Guru is to have separate elements in my Measures dimension for each source cube.  This is to avoid the situation where links from multiple cubes overlap the result in the target cube.

For example, I have a GP cube, an Opex cube and a Factory cube.  Guru’s recommendation was to have separate elements for each source that roll up to a common parent.  So in this example, having Amount – Opex, Amount GP and Amount – Factory all rolling up to Amount, means that each source cube has its own target measure and they then all rollup.

Also note that this solution was only recommended because there is no data entry into the target cube.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In