We are looking into building a cube(s) to house purchasing data such as commodities, vendors, unit costs, etc. Need to know information on what we buy, who we buy from, how much we pay as well as lower level detail. What applications should I be looking at?


Joyce Bischoff's Answer: First, contact the prospective users of the application to determine their needs. You will need to understand their data and usage requirements to build a usable set of tables for the application. It sounds like you need a purchasing application. Chuck Kelley's Answer: Most of the products that build cubes will be able to deal with these questions. In fact, you could use a star schema (flat representation of the cube) and use just about any report generating tool to do this.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access