I don't think you can do an exception or show a pop-up message in transformation rules, you can write to the log, so maybe that is what you can do. I've used BRs in EXCEL load, never tried complex expressions.
Could you please let me know how can i use a business rule for an excel load, where do you put the BR, in the excel template? because in the data source it doesn"t work 😕 what's the syntax please ?
Other question, what type of BR do you create ? a Parser one or an XFBR String ?
Thanks a lot for your help 🙂
You reference a BR from any particular dimension, in Logical Operator functional area.
You can do the following, create a parser rule and then use it like the following.
SI#::[GetUserName]
Amazing i will try this 🙂
Thanks a lot
Keep in mind that it does not work on the Amt column, even though the documentation shows an example of that.
