OLAP Is Simple, Once You Understand It
May 9, 2012 Hey, Ted
I have a problem that I solved with a simple RPG program, but I know it can be done with SQL as well. I needed to generate a simple table of employee ID, name, and average of the last five weeks paychecks. Is this simple or complicated to do with SQL?
You are correct that SQL can do the calculation, Barry. However, you’ll have to decide for yourself if it’s simple or complicated.
First, let’s get some data to work with. I’m going to simplify your question slightly by using a name only, without an ID, to identify an