Need help - C level rule not consolidating

[bunkersoldier]

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

[gtonkin]

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?

[bunkersoldier]

yes correct

[gtonkin]

Possibly something I happened on yesterday ironically - As ALL N levels are Zero, C Levels are not shown in the cube viewer try this:

Code: Select all

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

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.

[tomok]

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).