TM1 Forum

Hi experts

I have a rule which I only want to apply at the C level. My rule calculates correctly on the C level element, however when I view the cube at a consolidated level there are no values.
Could you please review my code below and help me understand where I have gone wrong

['reporting_currency':'USD','RMUR','product':{'0700','0800','3001'},'measure_type':'Leak TV','attribute':'70','Raw_Data']= N: 0;

['reporting_currency':'USD','RMUR','product':{'0700','0800','3001'},'measure_type':'Leak TV','attribute':'70','Raw_Data']= C:

IF( ATTRS( 'trade', !trade, 'TRADE/POSITION') @= 'B',

+ ( ['reporting_currency':'TC','measure_type':'TV - EOD','attribute':'76','LTD']

- DB('product_control_analysis_detail','TC',!gaap_code,!functional_area,!iso_currency,!entity,!counterparty,!product,!instrument,'Sensitivity - EOD','55',ATTRS('reporting_date',!reporting_date,'Previous Day'),!curve,!tenor,!trade,'LTD'))

* DB('fx_rate',ATTRS('reporting_date',!reporting_date,'Previous Day'),'RMSRate',DB('fx_rate_type',!entity,ATTRS('trade',!trade,'COST_CENTER'),'string'),!iso_currency,'USD','numeric')

, consolidatechildren( 'trade' ) );


['reporting_currency':'USD','RMUR','measure_type':'TV - EOD','attribute':'76','LTD'] => [ 'Leak TV', '70', 'Raw Data' ];

['reporting_currency':'USD','RMUR','measure_type':'Sensitivity - EOD','attribute':'55','LTD'] =>
DB('product_control_analysis_detail',!reporting_currency,!gaap_code,!functional_area,!iso_currency,!entity,!counterparty,!product,!instrument,'Leak TV','70',ATTRS('reporting_date',!reporting_date,'Next Day'),!curve,!tenor,!trade,'Raw_Data');

Many thanks
John

Hi John, Just need to clarify this statement:

My rule calculates correctly on the C level element, however when I view the cube at a consolidated level there are no values.

Are there no values when you zero suppress but values for C levels when not suppressed?

yes correct

Possibly something I happened on yesterday ironically - As ALL N levels are Zero, C Levels are not shown in the cube viewer try this: If still not showing, I would check the feeders. I was not sure that any of the feeders you listed would end up feeding the above statement. Did not see mention of Product but tricky without understanding your model.

It doesn't matter how you derive the value from a C: level intersection, either allowing the natural consolidation to work or you are modifying it with a rule, if at least one of the leaf level cells underneath is not fed OR has a real value stored in it then when you zero suppress it will disappear. All you need to do is either feed one of the children or alternatively, store a value in one of them (I don't mean populate with a rule, I mean actually load a value).