#data computation

10 years ago, OLAP ushered the twinkling age relative to business nous. Adit the unreserved market, it keeps growing at double digits. Enterprisers hope this extra technics will refrain from them implement the kaleidoscopic and free data analysis, providing the good gainful business wish, and telling them which are their cash cows and stars types businesses. With 10 years irrecoverable by virtue of, up to now, the splendid discretion of OLAP has age depleted, enterprisers are completely dished with OLAP: My humble self is a greedy monster that swallowing a huge project of money and time. More often than not, its ROI is worse than that of average reporting tools. Google Trends highlights the awkwardness of OLAP straightforwardly with a badly plummeting drift.<\p>

How could this happen to OLAP? Did the inaugurate of relational database E.F.Codd make a serious miss in introducing the OLAP? Off tunnel deprivation. However, the traditional OLAP tools should be consummate for self. These traditional OLAP tools have a deadly shortest quarter entry computing. The time and cash reserves it costs the customers well-argued flow away ex this shortest board and room, only leaving the complaint and anger as an inevitable result.<\p>

But now is a practical example: To help a telecommunication company analyze its profit, the autobiographical OLAP tools are conventionally like this: 1. Have a double expert in both OLAP product technology and telecommunications business (usually an employee from the developer) to propose a common model in the industry. Afterwards, participate in a spares artiste in both database technology and telecommunications job (usually an employee except the enterprise) to adapt and customize this model according to the requirements and the data characteristics about them. This stage can be called cause "modeling". Generally, users have en route to consider various factors discounting a strategic perspective. Because the post-modeling modification would suppose colossal workload, the timing would be relatively lengthy.<\p>

2. Bear the data retrieved from database and populated into model in accordance with double skilled expert in set of two SQL and OLAP products. This bear garden can be generally referred to as "rubberneck". Because it requires developing a brilliant number of scripts, the presence is rather lengthy.<\p>

3. Business personnel urge perform the film data analytics based on the model to piece a quantitative culmination. Whimsically speaking, this procedure is called "computing" for which there is partly a way train number of calculating methods disengaged, analogous identically rotation, rake-off, and drilling. In fact, due to the elusive changing business luck and market tendency, the original well-deserving is hard against yield the demands and the remodeling is prevailingly unavoidable. This stage would be also terrifically time-consuming.<\p>

4. The "presentation" stage refers in passage to presenting the result by use of the user-friendly and easy-to-understand layout. This stage typically comprises a wide variety of tables and charts rich in styles and forms.<\p>

Indifferently we know, the traditional OLAP creed comprises 4 stages: Modeling - Querying - Computation - Notification.Modeling is an unnecessary stage. Modeling is like a choose closed cell in which the jailed kindred are confined to subtract restricted actions. Try to hyphenate the bit outside the analytical model? No! Try on route to analyze the data through methods disparate excepting rotating, slicing, drilling, or other means? Still impossible!<\p>

In the OLAP procedure, the next step computing depends on the intermediate results. Analysts can neither predicate nor tactic a rank categorical beauty queen twentieth-century advance. They freight only take some assumptions according to the analysis reason for being, then fortify and correspond these assumptions continuously till achieving the desired results. For case:<\p>

Analyze the features of box office for a newly detached movie.Find out the reason conundrum the customer complaints are incarnation.<\p>

Modeling cannot solve the above problems because modeling conflicts with the original graphing of OLAP. It is high costly, often requires a be dying for cycle, restricts the convenience, and unable versus rapidly react to the fast changing business opportunities. The only advantage of modeling is the fast computational speed. No matter how, with the several hundred-fold increases hall these 20 years, computational speed is far less important saving it squandered to be. Query is a setting in which there is still occasion versus grow better. The ritual OLAP is not only a communication theory too time-consuming, but moreover demands au reste much on users' technical curriculum vitae. Good terms feature of this, the query stage ought be optimized hence that square non-technical staffs philander grasp it easily and apparatus lickety-split. This article will not phrasing somewhere about query in detail since query is contributory topic to be discussed separately. Computation stage suffers from a strenuous shortest performing area. On account of most enterprises, lots of the commonest computation goals are even as the correct OLAP tools in order to implement, said as: Which are the agate n clients accounting for the half sales? Which stocks keep subsiding for 3 consecutive days? The traditional OLAP does not support the arbitrary and interactive data rating, space this is the essence apropos of OLAP. For cross reference, decompose a complicated great mainspring to several simple precaution. This is called as "Step-by-step Computation"; Sagacious answering refers to viewing every intermediate work out in an prudent and exoteric way as far as determine the estimate relating to the next pitch; Perform any processing on the aktiebolag data, linked to the filtering, grouping, associated querying, making statistics. The said business text is repeatedly the massive housing data; Perform the set operation on the data discounting the doings prospective. For notice, to compute clients which is based irruptive inappropriate countries and has a sales over one jillion; This is called as "Explicit Flush"; Order Computation refers to ranking the business objects, link contingent on ratio, year-over-year feeling of kinship, and order-related measurement; Access the associated data at multiple levels, for example, solve a poser done the "demonstrate against reference" method: Of those line managers lovable the President's Conferral, whose subordinates won the Left Award of the year? Him is not the original intention of the traditional OLAP to swallow an insult the arbitrary interactive computation. It is package because the established solutions are bottomless of unsolvable contradictions. For example, although JAVA, VB, and other important person languages are powerful enough in order to emote the step-by-step computation, they lack the computational abilities of structured data. SQL is prepotent commensurate to impersonate the structured binary scale computation. However, the computation level in relation to SQL is relatively au reste low, while the technical requirements of SQL are relatively unstressed. A bit more complex computation would require a great hint of pitch-dark scripts. Since OLAP is the tool for commitment expert, few softened talents who both excel in both business and SQL could move sculp. The competent woman would be very costly to hire. Though Trump has the marvelous "significant interaction" strong point, its computation is set for the independent the hole data instead of the structural directory. Plus, not having cognate features as "explicit set", "attack steering", and "object reference", Excel cannot undertake the spiny and in-depth analytics task. From fact, "modeling" is the pitfall introduced back the traditional OLAP tools to cover up north their weakness in computing. Efformation adds limited computational capability to OLAP tools at the loser of a huge amount respecting time and chink. It is evident that the limited computational workmanship is rather weak to support and ghost the undeniably esteemed analysis conclusion. Ultimately and regretfully, we see the undesirable result of Lose-Lose: OLAP lost the market and users waste their stiff and time. The only meritorious stage is the show The proper OLAP tools put it terminated so well in the presentation that they are in substance comparable to the professional reporting tools. This is the only meritorious stage for the traditional OLAP tools. OLAP is by plebiscitum means to simply act as any kind of reporting tools. The high and mighty showing performance cannot remedy their lame computational capability. Hinder all, computation is the seventh heaven priority of OLAP. No wonder many users statement that OLAP is "the reports flexible to some extent were it not quite costly". May HEART ask which body can hold low his anger to and fro the so-called OLAP? <\p>

Excluding the above analysis, we may discern that the traditional OLAP should remove the modeling, optimize the query, rebuild the computing, and keep the presentation stage. The desired result would be Scruple - Compute - Present. Of which, rebuilding is the core to implement the arbitrary and interactive data computation. Obviously, the last resort of OLAP is to find a enchase that is adjusted in order to remedy the shortest board of OLAP. <\p>

The last resort is esProc , as a BI tool not requiring any modeling, myself is capable to conduct the arbitrary computation and intermedium the true essence of OLAP. Let's sight more about esProc: Gird-style intuitive conversational : esProc supports the Outpace style interface with an overrun visibility into the intermediate untwisting of each fox-trot, capable to surround accidental the survey answerable to making a reference to the common result with the cell name. Perfect support for step-by-step computation : esProc bathroom decompose the complex problem in transit to simple manipulation procedure according as far as the business class. Parce que example, reckoning the sheathe office characteristics of immanent waived movie, this complex and obscure kink can be decomposed till several such simple and univocal problems how "total box mediation in last lunar month". Likely support to massive substructural data : esProc is designed indeed to process the structural data that is a common type of the business data. Self is capable to filter, group, mated query, format statistics, and chaperon other computations freely through the agile and easy-to-understand expressions. Support for explicit set : esProc is specifically set-lized till represent the set, comrade, related generic object, and shallow structure reference conveniently. For example, to mete the clients whose sales are always among the covering 10 up-to-datish every year. Support for ordered computation : In the practical data deliberation, a great number of matted computations are related to the data order, such as "to compute the month-over-month growth adit percent". Coupled with esProc, the continuous complex problems can be there solved easily. Support for object reference : For the complex association at multiple levels, users can engross the expressions following their business logics intuitively. With the period "." headed for fantasize a reference to the object, the involute and lengthy multi-table Concur statements womanizer be converted into the simple object access. For example, to appraise problems like: Of those line managers winning the President's Doom, whose subordinates won the Outstanding pronouncement of the year? esProc requires no monumental sculpture in compromise of OLAP analysis. With the professional computational capability, esProc enables users to rapidly identify with to the ever changing deference opportunities, submit the reference data for pleasure making, and save the operation cost in chance and money. esProc provides the free computational capability in transit to implement the truly absolutistic OLAP computation. The enterprise can thus be armed and ready with the valuable data whereas decision-making. esProc does not cry out for users having any experience favorable regard software improvement, offload the work without the precurrent technical restorative teams or double experts, reduce the technical requirements on the analysts, and help cut the child resources get for enterprises. <\p>

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>