Look up table for SIC code

[Anonymous]

I have List of SIC code and Description - bussiness code and the catogery they fall in to 

Like  0139 -0161  - Vegetales and fruits

        0162 - 0500 - eating places  

How do i create a group or look up table ? I want to use this as filter so when i pick up SIC code i can see business clients falls

in that category?

[lbendlin]

Add this table to your data model as a dimension table, link it to your fact table via the business code. Then use the category for the filter/slicer.