To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Essbase
Discussion List
-
ASO MDX Data copySummary ASO MDX data copy script is taking hrsContent Hi All, I have an MDX script which will copy data from one member to other member it is taking 3 hours to complete … -
Possible to retrieve a numeric value and refer it it as a member name?Summary Investigating the possiblity of storing and retrieving a numeric value, and having a calc scrpt pull the number and then reference it as a member name.Content Th…
-
OAC Essbase Google Sheets add-onSummary You can now access your OAC data from Google Sheets exactly like you do in Excel using Smart View.Content We're happy to announce the availability of our "OAC Es…User_2025-02-04-20-31-44-581 97 views 2 comments 0 points Most recent by User_2025-02-04-20-31-44-581 -
Report ScriptContent Hi All, Do we have any command to convert the report script extract negative number . I am getting it as (54) but i want it as -54 . I tried to look for the comm…
-
Load backup .txt data into Essbase CloudContent Hi There, We are in the process testing on essbase cloud version, I am able to migrate application and cubes into OAC using utility provided. However is there an…
-
Capture Data in Unlocked Cell in Protected Workbook Smart View ErrorSummary Capture Data in Unlocked Cell in Protected Workbook Smart View ErrorContent Hi I've created an ad-hoc grid to enable users to load data into an OAC Essbase cube.…
-
Submit Text Label (Typed Measures) with HSSet Smart View FunctionSummary Submit Text Label (Typed Measures) with HSSet Smart View FunctionContent Hi Can you use an HSSet Smart View Function to submit a text label (Typed Measures)? If …
-
ASO copy then load additive issueContent ASO cube that is copying data into a current month then loading additively on top of this data to create a total. The problem is the load file might have a minim…
-
How to give permission to execute calculation command in Essbase cloudContent We tried to execute the sequence of scripts using the execute calculation command but it throws an error. Can someone let us know how to grant access to execute …
-
Syntax to login to the essbase Maxl clientSummary Here im trying to execute a maxl script for first time in the Essbase Maxl Client .Can some one provide the login syntax for the essbase maxl client and followin…
-
Having issues enabling DTS for Y-T-DSummary Having issues enabling DTS for Y-T-DContent Hi Having issues enabling DTS for Y-T-D. The value gets updated on the working sheet but fails to be updated on cube …
-
Managing Text List (aka SmartList) in OAC Essbase UI is Yet to Be ImplementedSummary In my version of OAC Essbase Cloud UI (version: 12.2.1.1.110) support for managing Text List is only supported in Cube DesignerContent To begin with, the OAC Ess…
-
Does Essbase replace numbers with #0 or #Missing during data loadsSummary Question about data update while performing a Level -0 data restoreContent We have the need to restore our Level 0 data from a particular day's ( 4 days prior) b…User_2025-01-31-15-11-16-462 34 views 3 comments 0 points Most recent by User_2025-03-07-21-45-06-805
-
How can i build the dimensions using the .xml file in OAC EssbaseSummary Hi, i have .xml file which contains the dimensions and members (which was exported from other ASO cube). How can i import the dimesnions(,.xml file) into the new…
-
How can i copy the .otl file in ASO cube to other cubeSummary I need to copy the .otl from shell ASO to Stg ASO application. How can i access the .otl file.Content I have a shell application, I need to copy the .otl file (A…
-
HypRetrieveRange() return error 4 when executed in loopSummary HypRetrieveRange() return error 4 when executed in loopContent Hi everyone, I have a small macro where I use the function HypRetrieveRange() on a selected range …
-
ASO Time Balance QTD YTDContent Hello, Using Version 11.1.2.3, and some of the Account members tagged as TB Last and rest are None. Now we need to have the QTD and YTD functionality without add…
-
Execute Hyperion Report via VBASummary How to run a predefined report via VBAContent Good Morning, I just started learning about Smartview automation via VBA. I got the developer guide, and when it co…
-
Alternate ViewSummary Need to have a 15 month view in ASOContent Hello, We are trying to create a 15 month view (i.e. March 2019 will be Jan-Dec 2018 + Jan-Mar 2019) in an ASO applica…
-
Smart View version 800 and 710Summary Adaptation Issues?Content Hi, most of our users are using smart view version 710 and our report layouts (both standard smart view and function reports) are also …User_2025-01-22-19-46-04-749 21 views 2 comments 0 points Most recent by User_2025-01-22-19-46-04-749
-
large macro time out with Smart ViewSummary SmartView macro timed outContent Hi all, I use macros to generate a lot of report each month (something around 4000 excel files) The macro is quite simple: it pu…
-
Target Application and Import Format details in FDMEEContent We have sample outline and data file for a cube which we have been able to load through a Rules file. Now we are trying to load the data through FDMEE. We requir…User_2025-01-31-15-40-07-333 20 views 3 comments 0 points Most recent by User_2025-01-31-15-11-16-462
-
Has anyone tried applying OAC patch 18.3.3-122?Summary OAC patch 18.3.3-122 failsContent Heads up to anyone planning to apply the latest OAC patch 18.3.3-122. I tried applying the patch today and it failed. Has anyon… -
Require help to build data file for the outlineContent We have attached the outline of one cube. We are having to design a rules file and hence our own data file. Can you please help us design data file for the outli…User_2025-01-31-15-40-07-333 16 views 2 comments 0 points Most recent by User_2025-01-31-15-40-07-333
-
Essbase formula are going missing after the DBRefreshContent Hi, The essbase formula are going missing after the DB_refresh. Running the refresh 2nd time bring back the formula in Essbase. Is it a kind of bug? Version 11.1…
-
Unable to load data using Rule fileContent I am new to Essbase. In EAS Console, In my outline, I have only one parent object called Products and two children namely Honda and Toyota. I myself have created…User_2025-01-31-15-40-07-333 19 views 5 comments 0 points Most recent by User_2025-01-31-15-40-07-333
-
Data Copy in OAC Essbase ASO CubeContent G'day,I am wondering if anyone has had success running a data copy calc on an OAC-Essbase ASO cube using MaxL. The error I keep running into is ERROR - 1241109 -… -
trying to run batch script from Calc script(Using MAXL) on prem 11.1.2.3.500Content Hi All, I'm on EPM 11.1.2.3.500 on windows 7. I'm trying to execute a maxl script from Calc script using RUN java...But need help to call a batch script(to run a…
-
Zoom in on "TB Last" via Essbase spreadsheet Add-inSummary Zoom in on TB Last via Essbase spreadsheet Add-inContent All my level zero balance sheet accounts should have a Time Balance Last (TB Last) tag. I have recently …
-
OAC 5 Essbase - Partial Data Load and the Clear Combination option in Data Load RuleSummary What is the syntax for defining a combination of members to implement a partial clear?Content When I'm defining a data load rule in OAC 5 - Essbase, I think I sh…