Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    Unanswered: 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???

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

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

    Cheers

    SG

  3. #3
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    ...

    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

  4. #4
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •