The Essbase Excel Add In is about to be de-continued (see Doc ID 1466700.1 ) in January '13. The (already out) version 11.1.2.2.x of the Excel Add In must be considered the last release of this particular program. 11.1.2 11.1.2 Planning 11.1.2.3 11.1.2.4 API ASO Awesomeness Batches Calc Manager CDF Customization DataForm EAS EPMA Essbase EXCEL Excel Add-in Financial Reporting Groovy Hacks LCM Maxl MDX Member Operation Util New Features Notepad NUMSys OTN OutlineLoad PBCS Planning Quick Tips Security API Shared Services Show Usage Smart View SQL Surprises.
Path Conflict Issue Oracle 11.2.0.1 ODBC Client and 11.1.2.1 Essbase Excel Add-In (Doc ID 1498710.1) Last updated on MAY 25, 2018 Applies to: Hyperion Essbase - Version 11.1.2.1.000 and later Information in this document applies to any platform. Combined KM 1349417.1 with this article and then deleted it.Checked for relevance on 18-Mar-2014. Symptoms When the following are installed on the same Windows 7/Office 2010 32 bit client machine:.
Essbase Excel Add-In version 11.1.2.1 and. the Oracle ODBC 11g driver 11.2.0.1 There may occur PATH conflicts, due to identically named DLL ( oraclient11.dll). As result of this:. The Excel Add-In may not start.
When ODBC client path is specified first in PATH system variable it works and Essbase Excel Add-In does not work. When Essbase Excel Add-In path is specified first, it works but the ODBC client does not work. Cause To view full details, sign in with your My Oracle Support account. Don't have a My Oracle Support account? Click to get started!
In this Document My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit.
Certification Matrix Information about system requirements for EPM System products is now available in a spreadsheet format in the Oracle Hyperion Enterprise Performance Management System Certification Matrix. This matrix is posted at. System requirements are no longer part of the Oracle Hyperion Enterprise Performance Management System Installation Start Here, which contains information about release compatibility, prerequisites, default ports, and other information needed to plan a successful installation. Supported Languages This release supports non-English languages. The list of supported languages for all EPM System products is included in the Oracle Hyperion Enterprise Performance Management System Certification Matrix. Visual Explorer If you use Visual Explorer, noteworthy new features of Visual Explorer are as follows (see the Visual Explorer documentation for details).
Perspectives (varying attributes). Generate historical summaries to answer questions about data that changes over time. You can calculate based on a given perspective on the data or a given point in time, and use member perspectives to selectively drill down on specific members. Use Visual Explorer to build a data mining model and evaluate whether it is a good fit to use for predictions. Select from several types of models including clustering, naive bayes, and regression. You can define advanced MDX expressions to build the model.
New Workspace Capabilities. The sheet sorter, a page that shows thumbnail images for all sheets in the workbook in one consolidated view, enables you to navigate and organize the sheets in your workbook.
The mini film strip displays thumbnail images along the bottom of the workbook. The new start page lets you quickly open recent workbooks and data connections. Additional small changes help streamline your daily tasks. Dashboard Enhancements.
Add images, custom text areas, and blank spaces to the layout of your dashboard. Add web pages to your dashboards to display your views with content from other applications on the same screen. For constructing guided analysis paths, sheet links can now point to dashboards as their destinations. Other features include new mark options, filtering enhancements, and improvements to printing and PDF output.
The following defects are fixed in Essbase release 11.1.1.2. The defect number follows the description of the defect.
Error Messaging. Error code 1200664 is defined twice in the message.properties file with two different error messages: 1200664 Varying attributes is NOT enabled for this outline. 1200664 Date Formatting/Conversion Failure with Code 7630032 Calculation. Use of an aggregate function in a Y-T-D formula causes Essbase to terminate abnormally.
7628404, 7434008 Calculation. Calculations on a database do not return values because Calc is unable to create the block 7628395, 7356930 Calculation.
Some calculations take much longer to run in Essbase 9.3.1.2 compared to Essbase 7.1.3 on HP-UX 11.11 PA-RISC. 8230484, 7661212 API. A problem in the SSO token handling in Grid API may result in Drill Through failing to work with clients connecting using SSO token & grid API. 8230446, 7705535 Data Extraction. Execution of incorrect asymmetric report by user with filter access causes Essbase to terminate abnormally. 8259803, 8247194 Data Extraction.
When a user with filter access runs a report against an aggregate storage database, the database may terminate abnormally. 8230474, 7694568 Aggregate Storage. A partial data clear of two or more stored level zero members from a shared hierarchy in an aggregate storage database may cause Essbase to terminate abnormally. 7698699 Aggregate Storage.
In the following scenarios, Essbase terminates abnormally when clearing data from specific regions of aggregate storage databases: When logically removing a region of the database that only has zero values. When running multiple clear operations (either physical or logical) at the same time. 7642972 Data Export. In rare instances, 2GB or larger exports from aggregate storage databases cause Essbase to terminate abnormally. 7693504 Data Extraction.
The query governor does not stop a query when two queries are run simultaneously, causing memory leaks and the Essbase Agent to abnormally terminate. 7638748, 7451985 Shared Services Security. Refreshing security between Shared Services and Essbase may fail when a large number of users belong to a large number of groups. In general, the problem occurs when the number of combinations of users and groups exceeds 32,000. (For example, 700 users. 100 groups per @ user = 70,000 user/group combinations.) 7638744, 7530514 Currency.
Adding a currency partition to the main database when other currency partitions are already present may cause Essbase to terminate abnormally during restructure. 6551266 Server Administration. If a hostname is longer than 30 characters, creating a new application will succeed; however, creating a new database may cause Essbase to terminate abnormally. 7638778, 7342573 Server Administration.
If you define more than one volume to span the PAG and IND files on a database that is linked to a currency database, when you stop and start the application, the application terminates abnormally. 7638737, 6661605, 7417042 Essbase Studio. When SQL Server is running on a non-default port (default port is 1433), Essbase fails to connect to SQL Server, causing Essbase Studio cube deployment to fail. 7506781 MaxL.
The MaxL option to remove zeros when merging incremental data slices on an aggregate storage database does not work. The zeros are not removed. 7715137 MDX. Essbase server terminates abnormally on the Windows AMD 64-bit platform while running an MDX query that has a calculated member on the slicer (the WHERE clause within the SELECT statement) with a solve order of AGGREGATIONSOLVEORDER. 7690162 MDX. Essbase terminates abnormally while running an MDX query containing a FILTER@ function with a large conditional expression. 7686896 MDX.
MDX queries with a large number of substitution variables may cause Essbase to terminate abnormally. 7690153 Metadata.
Unexpected database restructuring occurs when a dynamic calc member is added to a dense dimension. 7527166, 7444075 Aggregate Storage. Retrievals on aggregate storage databases with time balance may fail with out of memory errors. 8251394, 8206514 Aggregate Storage.
Essbase may terminate abnormally when you kill a data load request on an aggregate storage database. 7628423 Aggregate Storage. Some errors occurring at the beginning of a data load to an aggregate storage database result in the load buffer being inaccessible. If you try to use or destroy the load buffer, it will result in the error message 'Cannot proceed while the cube is being loaded.' If you stop the application, it will terminate abnormally. 7628412 Spreadsheet Add-in.
With Spreadsheet Add-in enabled, performing the following series of actions may result in an error: 1. Disconnect your network cable 2. Log off the system 3. Log back on 4. Open Excel The error is “UniquifyForUser failed to get unique name size, code 1355.” Once you receive this error, to close Excel, you have to terminate it from the Task Manager. 8214299 Visual Explorer.
Executing a Visual Explorer generated MDX query may cause Essbase to terminate abnormally. 7257120 Partitioning. When partitioned outlines are synchronized, aliases are added to target members even though the source members do not have aliases. 8219336, 6941133 Aggregate Storage. Scripts that rename Aggregate Storage databases containing Integration Services data cause the Essbase applications to terminate abnormally.
7536114, 7390924 Data load. An incorrectly defined data load may cause the following error to be created. Also, Essbase may have to be shut down forcefully. 7612398 Essbase Error (1003062) The Dimension Information not found for column No Dimensional Modifier. Cannot load data. If a Dynamic Calc member has a formula containing a cross-reference to another database, changing the order of months and years causes incorrect results. 7628455, 7319366 Essbase Studio.
On UNIX and Linux platforms, Essbase may terminate abnormally when Essbase Studio is redeployed. 7558821 Hybrid Analysis. Certain models built by Hybrid Analysis cause Essbase to terminate abnormally when querying in Web Analysis. 7483261 Server Administration.
The Administration Server call back URL is not set properly in the.instance files when Administration Server is configured on SSL port. Instead of pointing to https, it points to http. 8223884 Security. If an administrator user exists in Administration Services Console and does not exist in Shared Services, the “set role” process fails and, subsequently, the cube deployment fails. 7459242 Time Balance. Aggregate storage databases with shared members, time balance tags, and hierarchies enabled in the Time dimension can produce validation errors in certain instances.
For example, when the main hierarchy is broken into months and the alternate hierarchy is broken into weeks, and part of a week falls in one month and another part of that week falls in another month, this can cause a validation error even though the outline is correct. 7638759, 7450127 Aggregate Storage. Aggregate storage target databases in transparent partitions may terminate abnormally if the partition is defined on level zero members. 7688025 Agent. Essbase may terminate abnormally when using an 11.
X client with a pre-11. X block storage duplicate member outline and modifying the date format. 7461895 Agent. Essbase may terminate abnormally when an 11.x client is used with a 9.3.1.3 server and the implied share setting is on. 7461917 Localization. In Russian language Essbase only, Essbase shortcut keys are not working as expected. 6552242 Data Export.
Using a calc script to perform data export operations against members of a sparse dimension causes incorrect data to be exported. 7628490, 7538188 Essbase Agent. An optimization to ensure that logins do not block applications takes an excessive amount of time to start up. 7638755, 7411505 Linked Reporting Objects. If a grid contains two consecutive cells returning multiple LROs with objects of different types, the returned LRO types are not correct. This happens only if the cell value is either zero or #missing. 7656220 Server Administration.
A shared memory optimization does not work if the location alias is defined with AGT:PORT. 7432891 Aggregate Storage.
If an aggregate storage outline is built using an ESSCMD dimension build, the outline is created with short attribute names, which is incorrect. The outline should be created with long attribute names. 6548878 Spreadsheet Add-in. The Essbase menu item on the Excel View Toolbars menu still says Hyperion Essbase.
It should say Oracle Essbase. 7623901 MaxL. When IFERROR is used with ALTER SYSTEM SHUTDOWN, errors are not captured. 7628497 Installation.
Installations of Essbase create an invalid MIGRATIONUTILITY folder. This is from the old Migration Utility, which is no longer used. The following defects are fixed in Essbase release 11.1.1.1. The defect number follows the description of the defect.
Spreadsheet Add-in. Performing multiple zoom in operations, whether manually or by using a macro, results in not enough memory or out of stack space errors. 6972577 Spreadsheet Add-in. When the Formula Fill option is selected, zooming in on a member (whether using mouse actions or menu items) may result in slow retrieval performance and an error message indicating that the maximum number of rows has been exceeded.
When the Retain on Zoom option is selected, zooming out on a member (whether using mouse actions or menu items) may result in slow retrieval performance. The Formula Fill and Retain on Zoom options are on the Mode tab of the Essbase Options dialog box.
6695282, 7019501 Spreadsheet Add-in. On Windows Vista, launching Query Designer from Spreadsheet Add-in causes Excel to terminate abnormally. 6775410 Spreadsheet Add-in.
Exporting reports to Microsoft Excel from (OFA) results in a MS VC program error when Oracle Essbase Spreadsheet Add-in is installed and registered on the same computer as OFA. 7111076 Spreadsheet Add-in. When an Excel spreadsheet contains multiple generation- or level-based members per retrieval, the Essbase application terminates abnormally.
7135200 Calculation. Formulas executed out of sequence return incorrect values in certain cases. 7268175, 7158413 Calculation.
Unable to successfully run a calculation script in which the EXCLUDE calculation command references shared members. 7376914, 7358669 Agent. Unable to synchronize Shared Services group security with Essbase due to token timeout issue.
7385229, 7339400 Aggregate Storage. For aggregate storage databases, creating a report that does not have at least one column causes the database to terminate abnormally, if the user running the report has filtered access (data filter is set for the user). 7380455, 7364327 Data Extraction. Extracting data from dynamic calc members using the sparse data extraction method (using the. The following issues are the noteworthy known issues of this release. The defect number follows the description of the issue. Essbase Query Designer.
EQD is translated into the following languages: French, German, Spanish, Japanese, Korean, Simplified Chinese, Traditional Chinese, and Russian. EQD for the following languages will be in English: Swedish, Danish, Italian, Turkish, and Brazilian Portuguese.
8303089, 7346082 Migration. Migrating aggregate storage outlines from 32 bit Essbase Release 9.3.1.2 to 64 bit Essbase Release 11.1.1. X when the host name is longer than 30 characters does not work. Workaround: Add to the essbase.cfg file a NODENAME entry with the value set to a short logical name. 8264400 Turkish Language Calculation Function Names.
When the ESSLANG variable is set to certain non-English languages, Essbase returns a syntax error when validating some calculation function names that were entered in lower case, instead of upper case. By default, when validating calculation scripts, Essbase converts lower-case characters to upper-case characters. The validation error occurs when the language being used, such as Turkish, has different case rules than English for mapping upper- and lower-case characters.
For example, in English, there are two versions of the letter “I”: a lower-case, dotted “i” and an upper-case, dotless “I.” In Turkish, there are four versions of the letter “I”: an upper-case dotted ' İ ' (Latin capital letter with a dot above), a lower-case dotted ' i ' (same as English), an upper-case dotless ' I ' (same as English), and a lower-case dotless ' ı ' (Latin lower-case letter without a dot above. Therefore, when using Turkish, calculation function names that are entered using the lower-case character “i” in the first three characters that follow the “@” sign, such as @ichildren and @idescendants, are not properly validated. Workaround: Enter calculation function names in all upper case. 8240203 User and Group Names. In Essbase, user and group names must be unique, regardless of whether Essbase is in native security mode or Hyperion Shared Services mode. If using Hyperion Shared Services mode, the user and group names must be unique regardless of whether the names are within the same user directory provider or in different user directory providers. For example, Essbase does not support having a user and a group with the same name within the same OpenLDAP provider.
Similarly, Essbase does not support having a user named user1 in an OpenLDAP provider and a user named user1 in an MSAD provider. 7497485 Security. When you delete a user (in Shared Services) that is provisioned as an administrator user for Shared Services, Essbase, and Essbase Studio, you must be sure to refresh security (in Administration Services Console) between Essbase and Shared Services. Failure to refresh security will result in a 'Failed to deploy Essbase cube.' Error when attempting to deploy a cube from Essbase Studio. For procedural information on refreshing users, see “Refreshing Security from Shared Services” in the Essbase Administration Services Online Help. Alternatively, see the Essbase Technical Reference to use MaxL to refresh security (alter system resync sss).
7459242 Red Hat Linux AS 4.0. When running Essbase on Red Hat Linux AS 4.0 and starting or creating Essbase applications, the following error message is encountered if Essbase cannot find the shared library named libcomerr.so.3: 'Error while loading shared libraries: libcomerr.so.3: cannot open shared object file: no such file or directory' Verify that libcomerr.so.3 exists on the computer on which you are running Essbase and that the library environment is set up correctly. If libcomerr.so.3 does not exist, you can create the library by creating a soft link in the directory where libcomerr.so. X is located.
To create a soft link, you must have the appropriate permissions in the directory where you are creating the link. If the installation program hangs while installing Oracle and Oracle Hyperion products, turn off the automount daemon for file systems that have a large hierarchy.
(1-155495984) If the installation program hangs while installing Oracle and Oracle Hyperion products and automount is on, verify the version of Linux you are running. Essbase 11.1.1 requires Red Hat Linux AS 4.0 Update 2 with glibc-2.3.4-2.13 or later. (1-171301321) Aggregate Storage Databases. Restructuring an aggregate storage database may result in all data slices being merged into one slice.
In order for the aggregate storage cache to have enough memory to restructure an aggregate storage database, all existing data load buffers are destroyed. Character Sets. The JISX0213 Japanese character set, which replaces the JISX0208 and JISX0212 Japanese character sets, is supported on Windows Vista.
The Essbase family of products does not support the JISX0213 Japanese character set. 6576813, 8-563756229 MaxL Shell. Prior to release 11.1.1, MaxL Shell sent the login statement to Essbase Server twice, affecting the Hyperion Shared Services password policy that is introduced in 11.1.1. Upon password expiration, Shared Services allows a configurable number of successful logins, but the MaxL Shell double login reduced the allowed number by half. To rectify the issue, release 11.1.1 MaxL Shell does not issue the login statement twice when a user attempts to log in.
However, if an earlier version of MaxL Shell is used with Essbase Server release 11.1.1, the configured number of login attempts allowed by Shared Services is still reduced by half. Therefore, Oracle recommends using release 11.1.1 MaxL Shell with release 11.1.1 Essbase Server.
The release 11.1.1 MaxL Shell is not supported with Essbase Server releases prior to release 7.0. When using Oracle Essbase Administration Services client to perform data loads or dimension builds on an Essbase Administration Server located on a different computer, if the generated error file is larger than 2 GB, the error file will not be created on the server; an empty error file will be created on the client, and the load will complete with an incorrect “Success” status rather than “Warning.” 6589657, 8-651709938 VB API. You cannot use the VB API to populate partitions because esb32.bas is missing required structures. As a result, these VB APIs are not fully functional and should not be used 6629996: EsbPartitionReplaceDefFile EsbPartitionValidateDefinition EsbPartitionValidateLocal EsbPartitionNewDefFile EsbPartitionOpenDefFile EsbPartitionFreeDefCtx EsbPartitionReadDefFile EsbPartitionWriteDefFile EsbPartitionFreeOtlChanges EsbPartitionCloseDefFile Administration Services Console. When Essbase Administration Services is deployed on Oracle Application Server (OAS) in a clustered topology, (with Essbase Administration Server and OAS HTTP Server on different computers), and Essbase Administration Services Console is installed on the same computer as Essbase Administration Server, you may be unable to fully expand Essbase Server nodes in Essbase Administration Services Console. If you encounter this issue, install Essbase Administration Services Console on a different computer than the computer on which Essbase Administration Server is installed. 7184916 Data Export.
64-bit Essbase does not support using the DATAEXPORT calculation script command to export data in batch export mode directly into a SQL data source. 6668535 Aggregate Storage Databases. Loading #Missing values to aggregate storage databases with typed measures (text or date) is not supported using Send operations or using incremental data loads. Oracle Hyperion Smart View for Office, Fusion Edition and Spreadsheet Add-in display a warning message if you attempt to load #Missing to text- or date-typed cells using a Send operation. Workaround: To load #Missing values to aggregate storage text or date typed measures, perform a full data load using “overwrite” mode.
![Essbase Excel Add In 11.1 2.2 Essbase Excel Add In 11.1 2.2](/uploads/1/2/5/6/125627466/273103232.png)
6973834 EsbLROPurgeObjects. In the VB Main API, running the EsbLROPurgeObjects function does not delete any linked objects. 6589153, 8-651484045 MDX. Running the MDX Parent function does not return the member’s parent. 6589847, 8-648458764 Spreadsheet Add-in. In the Drill-Through Wizard, table or column names that are longer than 80 characters are truncated to 80 characters.
When selecting, ordering, and filtering columns in the wizard, only the first 80 characters of the table or column name are displayed. Spreadsheet Add-in. If, after viewing an unprotected worksheet's Essbase Aliases options, you then view a protected worksheet's options, the protected worksheet seems to inherit the unprotected worksheet's Aliases option settings. 6542214, 1-243469667 Spreadsheet Add-in. With Excel 2007 on Windows XP or Windows Vista, running a VB script to log into a spreadsheet results in slow connection times. 7035038 Varying Attributes.
Dimension builds using rules files do not support varying attributes. Instead, use Essbase Studio to deploy dimensions with varying attributes, or use Outline Editor in Administration Services to add varying attributes. 7257317 MaxL. When Shared Services security mode is in effect, the following MaxL password management clauses are not supported: Alter user USER-NAME set passwordresetdays Alter system set passwordresetdays 7198014.