What does DB command do if several fields are blank?

[ioscat]

Good evening to all!

What does DB command do if several fields are blank?

DB ( 'CubeName', 'element of dim 1', 'element of dim 2', 'element of dim 2', , , , 'element of dim 6' );

[qml]

Depends where you use the DB() formula - in a rule, in a feeder statement or in TI. In the first two cases it fails silently, whereas TI would throw an error.

[ioscat]

Thank you, qml.

is there any difference between two strings:

Code: Select all

if ( condition statement , DB ( ...... el1 , el2,  ..... ) , continue );

and

Code: Select all

DB ( .... , if ( condition statement , el1 , '' ) , el2 , .....);

[declanr]

Thank you, qml.

is there any difference between two strings:

Code: Select all

if ( condition statement , DB ( ...... el1 , el2,  ..... ) , continue );

and

Code: Select all

DB ( .... , if ( condition statement , el1 , '' ) , el2 , .....);

ioscat,

I don't mean to insult with this one but the questions you are asking are quite straight forward to find the answers to... simply by putting them into a rule within a test cube... is this something you have considered?

[ioscat]

as for test there is nothing difference, but sometimes gurus can give an advice about how to do it right and gow not to it wrong.

[Steve Rowe]

In a rule sheet they are different.

The first statement with continue for the false condtion would allow you to write another rule against the area on the left of the rule.

The second statement the false condition evaluates to a DB that is incomplete which will always return 0.

In a feeder the first one won't compile and in a TI neither will compile since the function is different.
HTH

[ioscat]

Thaks for complete answer, Steve. Great!

[jameswebber]

Anyone else find it really annoying that nothing happens in the first case?..really hard to unpick issues in rules sometimes because of this