Thursday, February 7, 2008

MDX learning

I'm learning a lot in today's MDX section of class. . . It's the "Ah-ha" moment in realizing that it's just another query language similar to SQL and SAS but it's a way to query (and create calculations) aggregated data in a OLAP cube. Hmm. . .

In SAS terms it's reminding me of the Proc Tabulate command (cross-tab) and it runs quickly because the math has already been done within the cube measures. Granted, we can also use MDX to create more advanced calculated measures. Hmmm. . .

Very interesting. . .

No comments: