Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
It sounds that your fact-table with the transactions contained not all materials which are listed within the linked dimension-table. It's not uncommon because the facts are usually limited to last n years but the dimensions contain all ever existing items. To overcome it you could filter the dimension-loads on the existing items (requires that they are loaded afterwards of the fact-tables), maybe in this way:
fact: load * from transactions; dim: load * from dimension where exists([Material Number]);
No, not really. You could easily exclude them with set analysis within the expressions but the dimension-values exists further within the field and therefore within the search. You may create a calculated dimension within the list-box or the charts but such an approach has several disadvantages by aggr(), totals, displaying selections ... and is therefore rather not a general solution.
Therefore I suggest to do it within the script - it's simple and quite probably there are more dimensions which may be filtered in a similar way, like: stores, staff, regions/channels ....
