TM1 Forum

Hi,

I have a 'validation cube' where I validate if a staging cube has a blank value. If this is true, I populate the corresponding intersection of my validation cube with a 'FAIL' string value.

The rule works, but when I suppress zero, all my values disappear.

Would someone be able to help me with the feeder, seeing that the value driving the string input is already blank, I dont know what to feed.

##Rule
['Validation Result','Blank Test'] = S:
IF(ELLEV('Staging_Sequence',!Staging_Sequence) = 0 &
ATTRS('Staging_Cube_m',!Staging Data Item,'Blank_Element_Validation') @= 'Y' &
DB('Staging_Cube_m, !Staging_Sequence,!Reporting_Level, !Company, !Staging_Data_Item) @= '','FAIL','');

Thanks in advance

You have given the rule but you haven't given any information on whether you are using Skipcheck, Feedstrings and Feeders and whether this rule is fed. If it is not fed then this is expected behaviour.

Also why do you think his rule needs to be fed? In my experience feeding strings is problematic. If you want to facilitate a validation check my advice would be to populate a numeric measure with 1 or 0 as this is far more reliable.

As you said, it is impossible to feed with blank values.
But you can feed with any feeded or stored data, whatever where they are.

In your exemple, you could use a conditionnal feeder on your attribute cube "Staging Data Item" to feed ['Validation Result','Blank Test'] when 'Blank_Element_Validation' is at 'Y' (for all other dimensions you got to point on consolidated elements) or maybe you have other indicator in your application more approprieted to detect 'Staging_Sequence(s)' that may be feeded.

Good luck with that.

Thank you for the help rozef.

I was using skipcheck and stringfeeders.

It works now. I used another measure in the staging cube (a numeric measure which always has a value) to feed the string