Limiting Demensions

Hello,

while creating a demension, how can you limit data. For example, I have a product table that has products broke up by product lines, I would like to create a demension for each product line due to the large amount of products and the fact that we do not report off all of the product lines as much as others.

any hints?Howdy

Copy the specific data into some new tables then work on those.

Cheers

SG|||yeah, I figured that as a possible solution, but wanted to know if there was another way. Just because we are talking about some 20 plus tables and then would have to do the same for some other tables, so they are multipling quickly if I do that.

Thanks for the post|||Howdy,

Let sql do the grunt work by using **scripts**, thats why you have got it. You probably only use 50% of its capacity anyway....

The better you can separate stuff out through using a disciplined approach, it makes problem solving & management a whole lot easier.

Its from experience.....

Cheers,

SG