Single Dimension fails to consolidate

[RSK]

Hi,

I currently have an issue where I have a sales cube where data needs to be split out into Management Centres and Costs centres in a P&L cube. To tackle this I have placed two attributes on each of the products, one for the Management Centre and one for the Cost Centre.

In the P&L my rule looks like the following. This correctly places the values into appropriate Management Centre and Cost Centre.

Code: Select all

['Sales','Input','UK GBP']=N:IF (ATTRS('Brand', !PL_Brand Hierarchy, 'ManCentre')@= !PL_Management_Centre,
					 IF(ATTRS('Brand', !PL_Brand Hierarchy, 'Cost Centre')@= !PL_Cost_Centre,
					DB('SC Sales Summary',!PL_Brand Hierarchy,!Years,!Months,!Versions -  P&L Analysis,'UK GBP','Sales'),
					0),0);

The Sales cube feeder is the following

Code: Select all

['UK GBP','Sales']=>DB('PL Product P&L','Sales',!PL_Brand Hierarchy,ATTRS('PL_Brand Hierarchy',!PL_Brand Hierarchy, 'ManCentre'),ATTRS('PL_Brand Hierarchy',!PL_Brand Hierarchy, 'Cost Centre),!Months,!Years,'Input',!Versions,'UK GBP');

In the P&L cube the dimensions consolidated in all but one dimension - the Cost Centre dimension where any consolidations are zero. I thinking there must be a feeder issue somewhere but none of the cells are coming back as unfed....

In addition to this when surpress zeros is turned on the consolidation line does not disappear.

Any ideas? Thank you in advance.

[tomok]

Here's the deal. It's impossible to diagnose your problem with just a snippet of the rules in your cube. You do have other rules in there, correct? Could they be possibly having in impact on the issue? Likely. Here's a clue: If ANY of your dimensions are consolidating properly for this calculation then it CANNOT be a feeder issue. If the cells weren't fed then none of the consolidations would work, which brings me back to my original statement.

[RSK]

I did think it could be other rules affecting it therefore I completely stripped any others out.

All that is left is the following, cubes have been recreated also.

P&L

Code: Select all

SKIPCHECK;
['Catalogue turnover','Input','UK GBP']=N:IF (ATTRS('PL_Brand Hierarchy', !PL_Brand Hierarchy, 'UK ManCentre')@= !PL_Management_Centre,
               				IF(ATTRS('PL_Brand Hierarchy', !PL_Brand Hierarchy, 'UK SCS')@= !PL_Entity Hierarchy,
             				 DB('SC Sales Warehouse Brand Summary',!Years,!Months,!PL_Brand Hierarchy,'Ex-Factory Sales',!Versions - P&L Analysis,'UK GBP'),
              				0),0);

FEEDERS;

Source Cube

Code: Select all

SKIPCHECK;

[]=N:DB('SC Sales_Warehouse',!Years,!Months,!PL_Brand Hierarchy,!Sales Warehouse Calcs,!Versions,!Currency Calc);


FEEDERS;

['UK GBP','Sales']=>DB('PL Product P&L','Sales',!PL_Brand Hierarchy,ATTRS('PL_Brand Hierarchy',!PL_Brand Hierarchy, 'UK ManCentre'),ATTRS('PL_Brand Hierarchy',!PL_Brand Hierarchy, 'UK SCS'),!Months,!Years,'Input',!Versions,'UK GBP');

[RSK]

I have managed to drill down a bit more on this.

I think it is possibly something to do with one of the elements contained within either the Management Centre or Entity Hierarchy. I created a new Management centre and Entity hierarchy with a single consolidation and N level element in each, then I recreated the cube, the result was the dimension which failed to consolidate previously now works. After this I copied and pasted the previous hierarchies into the new dimension and now the problem resurfaced.

Could it be a name of one of the elements maybe?

[declanr]

I have managed to drill down a bit more on this.

I think it is possibly something to do with one of the elements contained within either the Management Centre or Entity Hierarchy. I created a new Management centre and Entity hierarchy with a single consolidation and N level element in each, then I recreated the cube, the result was the dimension which failed to consolidate previously now works. After this I copied and pasted the previous hierarchies into the new dimension and now the problem resurfaced.

Could it be a name of one of the elements maybe?

I am assuming by "not consolidating correctly" you just mean that a consolidation wasn't the total of its children?
I will admit I haven't actually read your rule statement but if it worked when the dimension was replaced my first port of call would be to check element weightings.

It may seem obvious and you've probably already checked it but is best to eliminate the obvious first. TM1 can sometimes go a bit barmy with unusual element names but remember when you hear hoof prints to think horses not zebras.

[RSK]

I have managed to drill down a bit more on this.

I think it is possibly something to do with one of the elements contained within either the Management Centre or Entity Hierarchy. I created a new Management centre and Entity hierarchy with a single consolidation and N level element in each, then I recreated the cube, the result was the dimension which failed to consolidate previously now works. After this I copied and pasted the previous hierarchies into the new dimension and now the problem resurfaced.

Could it be a name of one of the elements maybe?

I am assuming by "not consolidating correctly" you just mean that a consolidation wasn't the total of its children?
I will admit I haven't actually read your rule statement but if it worked when the dimension was replaced my first port of call would be to check element weightings.

It may seem obvious and you've probably already checked it but is best to eliminate the obvious first. TM1 can sometimes go a bit barmy with unusual element names but remember when you hear hoof prints to think horses not zebras.

You beauty! I hadn't checked the weighting and somehow they were all set to zero.... The dimension was loaded by one of our new TM1 people so I will need to check back to the TI to see why.

I can't believe I hadn't spotted this but thanks for mentioning it, really appreciated.

[Duncan P]

BTW zero weighting also affects feeding of rule calculated C level cells for the purposes of surviving suppression.

Basically if you feed a child then the ancestor is also fed only if all the intervening weights are non-zero.