Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jivechops

    Best practices for implementation of Oracle grouping/rollup functions

    Thanks Robynne- I'm well aware of manipulating logical table sizes to handle aggregate awareness. However, the issue I was trying to resolve dealt with one single table that contained all aggregate levels. In other words, using a time aggregate example, my single table had aggregate values...
  2. Jivechops

    Best practices for implementation of Oracle grouping/rollup functions

    Thanks Z3- I did in fact end up creating multiple views to accommodate the table structure, and it worked fine. It was pretty simple with only three dimensions for the first aggregate. the second aggregate was a nightmare- 11 dimensions. I created views for them as well and it worked, but it...
  3. Jivechops

    Best practices for implementation of Oracle grouping/rollup functions

    First off, forgive me if this is a naive question, but I've been at this for over a week and have made no progress, I am hoping that someone out there has been through this and can point me in the right direction. Does anybody have a recommendation on approach/best practices for aggregate...

Part and Inventory Search

Back
Top