Is anyone else using OLAP?
-
Hey folks....I just wanted to get an idea if anyone else is using the OLAP services. I've been working with it for about a month, and its pretty amazing stuff, but I don't get the feeling that anyone is using it outside of some report generation programs like Crystal and Excel via Pivot Tables.
-
Hey folks....I just wanted to get an idea if anyone else is using the OLAP services. I've been working with it for about a month, and its pretty amazing stuff, but I don't get the feeling that anyone is using it outside of some report generation programs like Crystal and Excel via Pivot Tables.
olap uses are generally driven by non-programmers,, power corporate users who need heavy analysis of database info i work in the it department at the headquarters of one of the largest grocery chains in the US, and the mainframers are in the process of implementing ibm's high end olap solution for db2,,, it's a pretty amazing product -John
-
olap uses are generally driven by non-programmers,, power corporate users who need heavy analysis of database info i work in the it department at the headquarters of one of the largest grocery chains in the US, and the mainframers are in the process of implementing ibm's high end olap solution for db2,,, it's a pretty amazing product -John
I agree, but that doesn't mean that it can be left to the same sort of people who want a Mauve SQL database because it has more RAM (I'm citing a Dilbert cartoon). The OLAP queries appear to be rather complex...and only useful if the Cubes are properly constructed....and while the query maybe generated by a DBA somewhere, I feel like in some applications, storing the query and hiding the magic is a good idea.....just like a good application hides the database behind it.
-
I agree, but that doesn't mean that it can be left to the same sort of people who want a Mauve SQL database because it has more RAM (I'm citing a Dilbert cartoon). The OLAP queries appear to be rather complex...and only useful if the Cubes are properly constructed....and while the query maybe generated by a DBA somewhere, I feel like in some applications, storing the query and hiding the magic is a good idea.....just like a good application hides the database behind it.
right, my point was that the business push came from a direction that was slightly off of the normal tech push. the case for olap was made by the middle management, heavy iron, business analysts it's another of the interesting technologies that i don't have time to learn... :eek: -John
-
right, my point was that the business push came from a direction that was slightly off of the normal tech push. the case for olap was made by the middle management, heavy iron, business analysts it's another of the interesting technologies that i don't have time to learn... :eek: -John
Wellllllll......while it seems to be something that managers & business analysts want, its a nice solution to lots of the reports I've been asked to write for such users....using traditional SQL database's to generate these reports tends to mean that it'll take a fair amount of code to do what they want, and even then it'll be nowhere near as nice as what I've been able to pull out of an OLAP database...and when I create such a report using OLAP/MDX I'm able to create a query in a few minutes (if I have to create a dimension or cube, it might be an hour, but still a very short period of time). From the developers perspective, I think its a huge benefit due to the quicker turnaround and depth of information.