Missing Variable in DB function but still work?

[macsir]

I just came across one case for missing variable in DB function but it looks like there is no error when compiling and it is successful.
e.g.

The complete one

Code: Select all

['LY_Progress'] = C:
DB('Reporting',STR(NUMBR(SUBST(!Scenario,1,4)) - 1,4,0) | SUBST(!Scenario,5,2),!Category,!Location,!Program,'E_1');

Missing category in the rule sheet

Code: Select all

['LY_Progress'] = C:
DB('Reporting',STR(NUMBR(SUBST(!Scenario,1,4)) - 1,4,0) | SUBST(!Scenario,5,2),!Location,!Program,'E_1');

I missed !Category but it is still successful for compiling and calculation is right?

[asj105]

As far as the syntax is correct TM1 rule editor wont give error , This is the case with your example, But it wont pull any value from your source cube . Check in your Target cube, if there is any value which has got pulled from your Source cube then it will be a confusing. let me know if you got any data got pulled from your source cube to target cube using incomplete DB statement which might be syntax wise correct.

[macsir]

Yes, as you said. The value is not in the target cube but the rule sheet would not tell you any error if you miss the variables. Unless you put something it can recognize with the target cube, it will give you the error.