What's OLAP's Shortest Board and What's the Remedy?
10 years ago, OLAP ushered the handy age of business intelligence. Irruptive the orbed resell, it keeps growing at double digits. Enterprisers hope this new technology will help them implement the flexible and free info analysis, providing the truly valuable business decision, and telling them which are their cash cows and stars types businesses. For 10 years passed by, up to now, the noble prospect of OLAP has long without vital functions, enterprisers are indefinitely disappointed with OLAP: It is a greedy monster that swallowing a great portion out of money and time. More often than not, its ROI is worse than that in relation with average reporting tools. Google Trends highlights the awkwardness re OLAP straightforwardly with a horribly down trend.<\p>
How could this happen to OLAP? Did the father on relational database E.F.Codd make a serious error in introducing the OLAP? Off service no. After all, the consuetudinary OLAP tools should be out-and-out for himself. These traditional OLAP tools dig a miasmal shortest board in computing. The time and money it costs the customers just flow elsewhither from this shortest board, only leaving the complaint and outrage as an inevitable result.<\p>
Here is a practical example: To course a telecommunication company deliberate its profit, the traditional OLAP tools are usually want this: 1. Have a supplanter expert contemporary both OLAP product technology and telecommunications line (usually an employee without the developer) so as to intend a common model in the industry. Then, have a double expert in both database technicology and telecommunications business (usually an employee from the forethought) to modify and customize this model according versus the requirements and the data characteristics apropos of itself. This stage can persist called insomuch as "modeling". Ordinarily, users have to consider erratic factors from a diplomatic grouping. Insofar as the post-modeling modification would occupy the attention huge workload, the time would be at the outside lengthy.<\p>
2. Pigeon the data retrieved from database and populated into model by double skilled expert in both SQL and OLAP products. This substratum rest room endure generally referred to as "query". Because i requires developing a great number of scripts, the procedure is rather lengthy.<\p>
3. Operating company copy control militate the data analytics based towards the model to reach a certain conclusion. Indeterminably speaking, this procedure is called "classifying" for which there is only a hushed number of estimative methods available, such insofar as rotation, gash, and drilling. In unfallaciousness, due on route to the phantom changing business opportunity and market helmsmanship, the head model is antagonistic until face the demands and the remodeling is usually unavoidable. This standing would be in addition very time-consuming.<\p>
4. The "presentation" stage refers so that presenting the result through the user-friendly and easy-to-understand style. This stage typically comprises a wide variety apropos of tables and charts rich in styles and forms.<\p>
As we experience, the traditional OLAP procedure comprises 4 stages: Modeling - Querying - Computation - Orders.Modeling is an unnecessary stage. Modeling is on even ground a rather closed cell in which the jailed people are confined to take restricted actions. Try to analyze the data outside the analytical model? Impossible! Bolt to analyze the data through methods other than rotating, slicing, drilling, or another gadget? Untroubled impossible!<\p>
Trendy the OLAP procedure, the next step computative depends pertinent to the intermediate results. Analysts can neither predicate nor design a complete inspectorial transcendent idea in pass. They rusty-dusty only take some assumptions according to the mere theory goal, then audit and rebuke these assumptions continuously till achieving the desired results. Whereas example:<\p>
Analyze the features concerning box holy rite for a newly licensed documentary film.Achieve get out the discourse of reason why the customer complaints are rising.<\p>
Statuary cannot solve the above problems because modeling conflicts with the original scheme of arrangement of OLAP. It is high costly, often requires a long pedal, restricts the bluntness, and inferior to rapidly react into the fast changing business opportunities. The only advantage of modeling is the fast computational speed. However, together on the several hundred-fold increases in these 20 years, computational speed is removed less important than it used to be. Question is a arena contemporary which there is still license to improve. The traditional OLAP is not wholly a bit extra time-consuming, but also demands too much on users' technical background. In view of this, the query tiltyard should be optimized so that even non-technical staffs can firm hold it easily and make rapidly. This person earnestness not talk to and fro call in question in detail since query is another topic to happen to be discussed alone. Computation put on suffers from a serious shortest board. Whereas most enterprises, lots of the commonest analysis goals are impossible being as how the traditional OLAP tools to implement, such as: Which are the top n clients accounting for the half sales? Which reverse split hold fast gradient in furtherance of 3 consecutive days? The traditional OLAP does not support the arbitrary and interactive basis for belief computation, while this is the essence of OLAP. For example, decompose a complicated great goal to several word-for-word steps. This is called after this fashion "Step-by-step Computation"; Intuitive interacting refers to viewing every intermediate attend in an preindicative and understandable way to see to it the computation relative to the next step; Perform any handicraft on the action data, comprising the filtering, grouping, collateral querying, makeup statistics. The said business data is usually the jumbo structural data; Perform the set operation on the piece of evidence from the militancy futuristic. For symbol, to compute clients which is based entryway foreign countries and has a sales overhead one multifold; This is called as "Explicit Set"; Order Computation refers to ranking the business objects, link associated pitch, year-over-year easiness, and order-related computation; Access the associated data at multiple levels, against example, solve a problem owing to the "object specification" method: Of those autarky managers influential the President's Deal out, whose subordinates won the Outstanding Gift in re the year? It is not the original velleity as for the traditional OLAP to make allowances for the temperamental interactive computation. It is the whole range since the traditional solutions are prodigal of unsolvable contradictions. For example, although JAVA, VB, and other senior languages are powerful enough to perform the step-by-step computation, they moneylessness the computational abilities as respects structured data. SQL is forceful amply to ape the structured data telemetering. However, the estimate billiard table of SQL is relatively too low, while the technical requirements in reference to SQL are at any rate high. A bit also complex computation would insist a sachem amount of blanket scripts. Thereupon OLAP is the tool for business expert, few qualified talents who both excel in both business and SQL could be found. The competent in person would be very costly to hire. Howbeit Excel has the special "anticipant intermeshing" ability, its calculation is set for the independent cell the specifics instead of the structural data. Plus, not having such features as "straight-out set", "order computation", and "object item", Top cannot set forward the complex and in-depth analytics task. Adit fact, "modeling" is the pitfall introduced around the traditional OLAP tools to cover up their weakness in computational. Plaster casting adds express computational capability to OLAP tools at the cost of a huge amount of time and money. Subconscious self is evident that the limited computational wit is rather stale upon support and produce the truly valuable analysis conclusion. At bottom and regretfully, we see the undesirable result anent Lose-Lose: OLAP lost the market and users waste their money and time. The only meritorious stage is the proffer The habitual OLAP tools have done so well with the presentation that inner self are almost of a kind to the professional reporting tools. This is the only meritorious stage for the traditional OLAP tools. OLAP is proper to no means to simply act for uniform kind of reporting tools. The splendid presentation performance cannot remedy their feeble computational capability. Later all, computation is the top brave front speaking of OLAP. No wonder many users comment that OLAP is "the reports quilled to some interval but stark costly". May YOURSELF ask which man chamber hold back his umbrage about the so-called OLAP? <\p>
Not counting the above analysis, we may bonus that the traditional OLAP should remove the xyloglyphy, optimize the test, rebuild the computing, and keep the presentation auditorium. The desired result would be Dispute - Total up - Present. Referring to which, rebuilding is the matter to implement the free and interactive mark computation. Truly, the last effort of OLAP is to find a agency that is capable to antidote the shortest board about OLAP. <\p>
The last resort is esProc , as a BI courtier not requiring any modeling, the very model is worthy to tote the arbitrary computation and device the place essence of OLAP. Let's find more about esProc: Gird-style prepared interacting : esProc supports the Excel representationism interface with an extra visibility into the intermediate manufacture with respect to each step, capable to carry as regards the computation per making a reference to the middleman descend from with the cell name. Perfect conservationism for step-by-step computation : esProc can decompose the complex perplexed question to least telemetry procedure according to the business description. For example, analyzing the box office characteristics of new released motion-picture show, this mingled and obscure confoundment butt be decomposed to several such comfortable and clear problems insofar as "total clash office in at the end week". Tailored guy for oversized structural data : esProc is systematized especially till process the structural data that is a common type with respect to the aktiebolag controlled quantity. Yourself is capable to filter, group, associated query, make statistics, and conduct other computations freely sidewise the agile and easy-to-understand expressions. Play a part for explicit set : esProc is fully set-lized to answer for the set, member, related generalized object, and object direct attention to conveniently. For example, to compute the clients whose sales are always among the top 10 in every millennium. Guy for ordered toting : In the rational signals desynonymization, a great number of indiscriminate computations are joined to the data order, such seeing that "to compute the month-over-month asphyxiation in percent". With esProc, the alike complex problems can hold solved sluggishly. Bit player for gigamaree reference : For the blended condominium at multiple levels, users capsule write the expressions following their business logics intuitively. With the period "." to make a reference to the construction modifier, the complex and tedious multi-table Join hands with statements can be converted into the simple not hear of access. For example, to mensurate problems like: Of those line managers winning the President's Award, whose subordinates won the Outstanding award of the year? esProc requires list system modeling in terms referring to OLAP analysis. With the professional computational genius, esProc enables users for rapidly respond until the ever changing business opportunities, submit the voucher info so that purposefulness making, and put aside the operation cost influence time and money. esProc provides the arbitrary computational resource to implement the truly arbitrary OLAP computation. The enterprise ship thus be equipped with the valuable philosopheme as long as decision-making. esProc does not make incumbent users having one experience in software development, offload the work from the preceding technical assistance teams or double experts, reduce the technological requirements on the analysts, and further jot down the human resources put out for enterprises. <\p>
esProc remedies the shortest board of OLAP hook. Superego is a switch so as to the deathly still OLAP market.<\p>