Facebook
Facebook
Twitter
Twitter
LinkedIn
LinkedIn
Email
Email
0 Comments
Comments
Pull your transaction table for whatever transactional database into MS Excel. Click on the data menu. Select Pivot Table Report. Now you're on your own to follow the Wizard and use Poor Roger's OLAP—PROLAP.
Pivot Points
In my web press database, I asked: "How long is it taking to makeready a press?" Zap. It searches 5,200 transaction records since October 1991 and shows me. I drill down in cross-examination. "How long does it take "fictitious press" to do that?" Zap again. "How long for each of their presses?" Bingo. "Hey, Ma, look at me. I'm OLAPping—no hands!"
0 Comments
View Comments
- Companies:
- Heidelberg
Related Content
Comments