TM1 cube different values with dimension (re)arrangment
Posted: Fri Dec 12, 2014 3:24 am
Hi folks,
We have TM1 10.1.1 server deployed in our environment that users access from Architect (power users and dev), TM1 Web and Excel. Off late we have come across this strange issue when viewing a cube's data in cube viewer in Architect. The cube has 10 dimensions and contains data from an underlying Oracle database, and has no rules to it. All dimensions, except for the measures, have a 2 to 3 level hierarchies with an 'All' master parent in each dimension. Amount is the only measure within the cube.
Dimensions: Version, Years, Months, Company, Cost Centres, Locations, Line of Business, Identifiers, Accounts and Measures.
The issue is that the amount measure gets a new value every time you slice the data depending upon how the dimensions have been arranged, you get a different value. For instance, say, you select All Companies, All Accounts. You keep the Company on title, and place Accounts on rows with Months on columns, and all other dimensions on title. You'll get a value of say, 100,000.
Swap Company with Account so Company is on row and Account on title, (both still at All level) and Months on columns. You get a value of say, 85,000.
If I keep both Company and Account on row, it gives me 100,000 again.
I am looking for ideas to how to go about this cracking this one, including debugging the problem and then resolving it. Given the number of elements in dimensions, I am getting nowhere with debugging itself as I am maxing out memory with a view getting to large to be loaded.
We have TM1 10.1.1 server deployed in our environment that users access from Architect (power users and dev), TM1 Web and Excel. Off late we have come across this strange issue when viewing a cube's data in cube viewer in Architect. The cube has 10 dimensions and contains data from an underlying Oracle database, and has no rules to it. All dimensions, except for the measures, have a 2 to 3 level hierarchies with an 'All' master parent in each dimension. Amount is the only measure within the cube.
Dimensions: Version, Years, Months, Company, Cost Centres, Locations, Line of Business, Identifiers, Accounts and Measures.
The issue is that the amount measure gets a new value every time you slice the data depending upon how the dimensions have been arranged, you get a different value. For instance, say, you select All Companies, All Accounts. You keep the Company on title, and place Accounts on rows with Months on columns, and all other dimensions on title. You'll get a value of say, 100,000.
Swap Company with Account so Company is on row and Account on title, (both still at All level) and Months on columns. You get a value of say, 85,000.
If I keep both Company and Account on row, it gives me 100,000 again.
I am looking for ideas to how to go about this cracking this one, including debugging the problem and then resolving it. Given the number of elements in dimensions, I am getting nowhere with debugging itself as I am maxing out memory with a view getting to large to be loaded.