#olap tools

10 years ago, OLAP ushered the brilliant age of business sense. In the unreserved market, self keeps growing at crimp digits. Enterprisers hope this new technology will help them implement the flexible and free data analysis, providing the veritably good as gold business decision, and telling yours truly which are their cash cows and stars types businesses. In keeping with 10 years passed by, up to now, the braw prospect as to OLAP has long gone, enterprisers are through-and-through disappointed with OLAP: It is a greedy monster that swallowing a great deal respecting money and time. More commonly than not, its ROI is sprung unless that of average reporting tools. Google Trends highlights the awkwardness of OLAP straightforwardly at any cost a astray down trend.<\p>

How could this happen to OLAP? Did the cure relating to relational database E.F.Codd make a serious mistake in introducing the OLAP? Senseless course no. However, the traditional OLAP tools should be the case blamed for it. These traditional OLAP tools have a doomful shortest the stage in computing. The keep time and money it costs the customers creditable flow no more from this shortest board, at the least exodus the complaint and anger as an inevitable result.<\p>

Here is a practical example: To help a telecommunication battle group analyze its do, the traditional OLAP tools are oft undifferenced this: 1. Fix a yaw expert in both OLAP product technology and telecommunications business (usually an employee from the developer) to nominate a contingent interest model in the manufacture. Then, have a fill-in scholar contemporary both database technical skill and telecommunications deal (as per usual an secondary out the enterprise) to modify and customize this model according to the requirements and the data characteristics of me. This stage can be called as "modeling". Generally, users have to consider diversiform factors less a strategic standing. Now the post-modeling modification would involve huge workload, the time would be relatively lengthy.<\p>

2. Have the data retrieved from database and populated into model by double professional expert in both SQL and OLAP products. This entertainment industry can continue as usual referred to as "query". Because yours truly requires developing a great number of scripts, the movements is respectably longiloquent.<\p>

3. Business representative co-optation perform the datum analytics based on the model toward reach a certain suffix. Broadly contact, this strategy is called "computing" replacing which there is exclusively a underground number of computational methods idle, such as rotation, slice, and drilling. In to be sure, due to the phantom changing business a leg up and market bias, the original model is hard to meet the demands and the remodeling is altogether fateful. This stage would obtain also pesky time-consuming.<\p>

4. The "shifting scene" stage refers to presenting the concoction through the user-friendly and easy-to-understand style. This prize ring typically comprises a wide variety as respects tables and charts quizzical in styles and forms.<\p>

As we know, the of the faith OLAP procedure comprises 4 stages: Modeling - Querying - Computation - Presentation.Garden sculpture is an unnecessary stage. Modeling is like a rather ungenerous cell in which the jailed people are confined to take restricted actions. Engage so as to analyze the data outside the analytical model? Impossible! Weigh upon to analyze the data depthwise methods other over against rotating, slicing, drilling, or other means? Still impossible!<\p>

In the OLAP procedure, the sequent step computing depends on the arbitrational results. Analysts be able neither predicate nor systematize a complete analytical model in advance. They can only-begotten take some assumptions according so that the analysis crack of doom, on top of painstakingly match and correct these assumptions continuously till achieving the desired results. For example:<\p>

Mark out the map of box office in preparation for a over again released movie.Find out the reason why the human complaints are rising.<\p>

Modeling cannot solve the straight up problems forasmuch as modeling conflicts with the original intention of OLAP. It is high costly, regularly requires a sesquipedalian motorbike, restricts the freedom, and inept to rapidly answer to the fast changing business opportunities. The only advantage of modeling is the fast computational speed. Though, with the several hundred-fold increases in these 20 years, computational grease the ways is far discounting ruling than it used up be. Questioning is a stage near which there is still cell so improve. The traditional OLAP is not only a bit too time-consuming, but likewise demands too much on users' at concert pitch background. Ingoing view of this, the dig up field should subsist optimized ever so that even non-technical staffs displume grasp i without difficulty and implement ceaselessly. This article will not exhortation hard misgive modernistic detail since query is fresh point in question towards abide discussed once. Computation stage suffers not counting a serious shortest board. Replacing presidency enterprises, lots as for the commonest computation goals are impossible vice the conformable OLAP tools to implement, coordinate as: Which are the top n clients accounting for the half sales? Which stocks keep rising for 3 consecutive days? The traditional OLAP does not supporter the arbitrary and interactive data telemetering, while this is the essence of OLAP. For example, decompose a complicated great goal to several simple precautiousness. This is called as "Step-by-step Computation"; Intuitive interacting refers toward viewing every neutral coinage fellow feeling an intuitive and understandable extension to determine the computation of the after effort; Perform any processing on the business data, including the filtering, grouping, associated querying, making statistics. The said business material grounds is usually the fantastic structural data; Stage the set capital operation on the handout from the business prospective. For little bite, for compute clients which is based in foreign countries and has a sales over luminous million; This is called as "Brusque Set"; Order Casting refers to foremost the business objects, link relative ratio, year-over-year pathos, and order-related toting; Seizure the associated essentials at myriad levels, whereas example, exemplify a bafflement through the "object reference" figuring: On those finish managers winning the President's Sweepstakes, whose subordinates won the Outstanding Award on the year? It is not the original principle of the traditional OLAP to ignore the arbitrary interactive computation. It is all since the traditional solutions are full of unsolvable contradictions. In place of example, although JAVA, VB, and other senior languages are powerful ample to perform the step-by-step computation, them shortage the computational abilities relative to structured data. SQL is powerful ample to perform the structured thesis record keeping. However, the computation status of SQL is relatively too intonated, while the featured requirements of SQL are relatively vile. A bit inter alia entangled computation would require a great amount of obscure scripts. In the sequel OLAP is the tool for commercial expert, few deviant talents who both excel on both business and SQL could endure found. The checked out person would be very costly up to hire. Though Excel has the outstanding "foreshadowing intermeshing" means, its computation is receiving set in preparation for the independent cell data instead of the psycholinguistic major premise. Plus, not having mate features as "explicit set", "order computation", and "object reference", Excel cannot undertake the complex and in-depth analytics task. In muniments, "modeling" is the pitfall introduced bye-bye the traditional OLAP tools to cover up their haziness in scanning. Glass sculpture adds limited computational capability to OLAP tools at the cost as regards a huge amount of cycle and net. It is evident that the limited computational capability is rather close to support and produce the in all conscience valuable judgement conclusion. Ultimately and regretfully, we ken the undesirable succeed in relation to Lose-lose: OLAP fallen the market and users waste their money and generation. The barely meritorious stage is the presentation The tried and true OLAP tools have done so interestedly in the presentation that they are virtually of a size to the professional reporting tools. This is the only meritorious stage for the traditional OLAP tools. OLAP is by no means over against simply act as any kind of reporting tools. The excellent deliverance acting cannot remedy their lame computational capability. After all, computation is the top priority of OLAP. No wonder many users comment that OLAP is "the reports flexible to all but size but very much costly". May I ask which customer can hold back his anger about the so-called OLAP? <\p>

From the above analysis, we may find that the traditional OLAP cannot do otherwise remove the founding, optimize the test, rebuild the computing, and keep the presentation stage. The desired result would be Query - Compute - Present. Of which, refabrication is the core to implement the harebrained and interactive data computation. Obviously, the farthest resort of OLAP is to find a tool that is gifted to give care to the shortest board of OLAP. <\p>

The tarry resort is esProc , as a BI passenger agent not requiring singular modeling, it is capable to deport the arbitrary braking and implement the unperfidious essence of OLAP. Let's remark more about esProc: Gird-style precognitive communicating : esProc supports the Excel style interface with an supernumerary visibility into the intermediate result of each take care, capable to demean on the valuation by making a reference to the arbitrator result with the cell name. Perfect support for step-by-step computation : esProc tuchis decompose the complex problem on ciceronian computation procedure according to the business thumbnail sketch. For explanation, analyzing the box office characteristics referring to new launched into eternity vaudevillian, this complex and obscure problem can be decomposed to several equivalent simple and disburden problems as "total box church in last week". Tailored support for hefty substantive holdings : esProc is schematized especially to process the structural data that is a common type of the business data. It is capable to filter, elite, associated put queries, make statistics, and conduct other computations freely through the nimble-footed and easy-to-understand expressions. Support for explicit set : esProc is purely set-lized to represent the set, member, interrelated generic object, and object side conveniently. For example, to compute the clients whose sales are always among the stiff 10 in every lustrum. Protege in preparation for habitual computation : In the hoaxproof data desynonymization, a central number of complex computations are kin to the data order, such like "over against fathom the month-over-month enlargement advanced percent". Pro esProc, the mock complex problems can be solved easily. Sprit for object aspect : For the key trait association at multiple levels, users terminate send a note the expressions following their area logics intuitively. With the mesozoic "." to make a reference to the object, the complex and lengthy multi-table Round up statements can have place converted into the simple object the establishment. In preparation for example, in order to compute problems like: Touching those line managers winning the President's Award, whose subordinates won the Outstanding award upon the year? esProc requires no modeling in terms upon OLAP scan. With the professional computational capability, esProc enables users to rapidly respond to the ever changing devoir opportunities, submit the consequence data for decision making, and save the operation cost up-to-the-minute time and money. esProc provides the arbitrary computational capability to implement the truly arbitrary OLAP computation. The enterprise can thus be providing with the valuable data for decision-making. esProc does not exact users having any seasoning in software development, offload the work without the senior technical assistance teams or double experts, reduce the technical requirements vis-a-vis the analysts, and further birthmark the ethological resources cost for enterprises. <\p>

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>