I have a customer that has a very large number of items with lot numbers.

Their products are lumber of various dimensions. 2 x 4 x 10 or 1 x 10 x 12 etc.

We want to add a UDF or possibly an alias that will allow a lookup of a all "2 x 4"'s  or all "1 x 10" 's and include any available lot numbers with associated lot data.

Is it possible to add the item lot table to a BI Explorer view?