The following is a listing of defects and enhancements addressed in the MicroStrategy 9. Product Suite. This list completes the list of known issues. Backup-Options-in-SQL-Server-and-Oracle.png' alt='How To Import .Bak File In Oracle' title='How To Import .Bak File In Oracle' />Top SQL Server blogs from MSSQLWIKI Year 2013 was a wonderful year for MSQLWIKI. Essbase Business Intelligence Oracle. Oracle Essbase is an OLAP Online Analytical Processing Server that provides an environment for deploying pre packaged applications or developing custom analytic and enterprise performance management applications. Oracle Essbase, along with Oracle BI Suite Enterprise Edition Plus, is part of the Oracle BI Foundation. With a rapid application development environment, Oracle Essbase enables business users to quickly model complex business scenarios. Aside from its high scalability, a key strength of Oracle Essbase lies in its ability to allow users to write back to an applications data repository under security. This makes it ideal for developing forward looking applications such as forecasting, scenario modeling, and what if type analysis. With Oracle Essbase, organizations define a dimensional view of their businessand provide business users with new levels of self sufficiency to access, navigate, and gain actionable insight into critical business issues. All of this through the various end user tools for Oracle Essbase. For example, Oracle Hyperion Smart View for Office Excel, Power. Point, Word, and Outlook, and Oracle BI Suite Enterprise Edition Plus, including Dashboards, Answers, Hyperion Interactive Reporting, Hyperion Web Analysis, Hyperion Financial Reporting, are some of the various Oracle tools that enable users to interact with an Oracle Essbase application. Oracle Essbase provides adaptable data storage mechanisms for specific types of analytic and performance management applications, thereby ensuring sub second response times regardless of the complexity of the analytics. For example, Block data storage option BSO enables driver based scenario modeling, forecasting, and predictive analytic applications. Aggregate data storage option ASO is optimized for massive sparse data sets, supporting thousands of concurrent business users performing sophisticated analyses at the speed of thought. With the release of Oracle Essbase 1. Oracle Fusion Middleware technologies as well as Oracle Database 1. Whats New. Oracle Essbase 1. Release Highlights. Thread Pool for Parallel Operations. Beginning this release, the following parallel operations do not dynamically create threads, but instead use a set number of threads from a pre created pool of threads set through the new WORKERTHREADS configuration setting. Parallel calculation, with CALCPARALLEL or FIXPARALLELParallel data load, for aggregate storage and block storage databases. Parallel export, for block storage databases. Parallel restructuring. XML Outline Editing. XML outline editing enables you to use an XML file to make basic changes to the database outline. This method is a streamlined way to make outline edits without needing to use a rules file nor invoke the Outline API. For more information, see Ess. Build. Dim. XML in the Oracle Essbase API Reference. Enhancements to Hybrid Aggregation. In this release, Time balance tagged members and Dynamic Time Series members can also be calculated in hybrid aggregation mode. Additionally, many more calculation functions are included in the list for member formulas that can be calculated in hybrid aggregation mode. Optimizations for Oracle Exalytics In Memory machine. Enhancements have been introduced for Essbase Server running on Oracle Exalytics In Memory machine. Supporting POV and Pivot Enhancements for Smart View 1. Essbase and Oracle Hyperion Provider Services are enhanced to support the Oracle Smart View for Office Point of View POV toolbar and pivoting behavior as follows Multiple members can be pivoted from the grid to the POV toolbar. Multiple members can be pivoted from the POV toolbar to the grid. A single dimension can remain on the POV toolbar. New Calculation FunctionsRELXRANGEGenerates a cross dimensional list based on the relative position of the cell that is currently being calculated and the offsets. Calculation Function Changes. Support for the Xrange. List parameter is added to a number of functions. Xrange. List is a range of members from one or more dimensions, and can help you incorporate time continuum navigation. The functions that support Xrange. List are COMPOUNDCOMPOUNDGROWTHCORRELATIONCOUNTDECLINEDISCOUNTGROWTHINTERESTIRRIRREXMEDIANMODENEXTNEXTSNPVPRIORPRIORSPTDRANKRELXRANGE new functionSHIFTSHIFTMINUSSHIFTPLUSSLNSYDVARIANCEVARIANCEPNew Configuration Settings essbase. WORKERTHREADSSee Thread Pool for Parallel Operations. CRASHDUMPLOCATIONSets the location where Essbase saves a core dump file when an abnormal termination occurs. Ericsson Rbs Software. CONNECTIONTIMEOUTSpecifies the maximum time that Essbase should wait for a SQL connection before timing out. QUERYTIMEOUTSpecifies the maximum time that Oracle Essbase should wait for a SQL query to execute before timing out. Max. L Grammar Changes. The Max. L export data statement includes grammar you can use to make exported data anonymous, wherein real data is replaced with generated values. This removes the risk of sensitive data disclosure, and can be used in case a model needs to be provided to technical support for reproduction of certain issues. New C Main API Function. Ess. Build. Dim. XMLSee XML Outline Editing. New C Outline API Function. Ess. Otl. Verify. Outline. Ex. 3A new API function for verifying outlines. This function differs from Ess. Otl. Verify. Outline. Ex in that it provides both member warnings and formula errors. Changed API Functions and Structures. ESSPERFCUSTCALCT and ESSPERFALLOCT have an additional field, dataload. Option. Generated calculation or allocation values can be added to existing values, instead of overwriting them. Oracle Essbase 1. PSU Patchset Highlights. Hybrid Aggregation Mode in Block Storage Databases. A new Essbase configuration setting, ASODYNAMICAGGINBSO, controls whether block storage databases use hybrid aggregation mode. Hybrid aggregation for block storage databases means that wherever possible, block storage data calculation executes with efficiency similar to that of aggregate storage databases. FIXPARALLEL Parallel Calculation. Although parallel calculation can be performed using the CALCPARALLEL configuration setting, in certain cases it might be beneficial to use the FIXPARALLEL command block method. In a FIXPARALLEL command block, you input some commands to be executed, along with a number of threads num. Threads and a member list mbr. List specifying the database regions slices to be calculated. Essbase creates a list of tasks from the combinations in the member list, and divides the tasks across the threads. Enabling CALCPARALLEL Parallel Calculation with XREF and XWRITEIn previous releases, Essbase would not attempt parallel calculation in scripts where XREF or XWRITE were present, or in cases of complex formula dependencies. However, in some cases for example, with currency conversion, or read only XREF, you might be certain that dependencies precluding parallel calculation do not exist. For such cases, you can force CALCPARALLEL parallel calculation using the calculation command SET FORCEPARALLELCALC. Enabling In Place Data Writing with Exalytics. The INPLACEDATAWRITE setting in essbase. In place data writing can help reduce data fragmentation and lower the need for frequent restructuring of database. It also reduces the need for frequent index updates, resulting in improved performance. Oracle Essbase 1. Release Highlights. Using Runtime Substitution Variables in Calculation Scripts. Similar to substitution variables, a runtime substitution variable can be included in a calculation script wherever substitution variables are allowed. Optimizing Name Lookup and Insertion During Dimension Build and Outline Editing. A new hashtable implementation optimizes the performance of name lookup and insertion when building dimensions and editing outlines. To configure the hashtable, use the ESTIMATEDHASHSIZE configuration setting. Unique Names for Shared Members.