A method and apparatus for a dimensional pyramid reporting tool. In one embodiment, the method includes identifying dimensions associated with one or more databases, and receiving user input specifying the number of reporting levels. The method further includes receiving user input linking the dimensions with corresponding reporting levels, and creating a table for each of the reporting levels to store dimensions linked to a corresponding reporting level.