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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Essbase
Discussion List
-
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…
-
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…
-
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 …
-
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…
-
Oracle Autonomous Analytics Cloud ServiceSummary Regarding StorageContent Hi, In OAAC with Essbase edition,whether there is any default storage associated with the instance while provisioning?If so how much?If …
-
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…
-
User authentification needed.Sign onSummary User authentification needed.Sign onContent Hello, We receive 'User authentication needed' error in Smart View every time we refresh the data. Has anyone faced t…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
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…
-
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…
-
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 …
-
Assign attribute for a calculationContent Hello, I have change, i have an acount "TOTAL" with 2 attributes COMPARABLE and NONCOMPARABLE. I will create a account with only the data COMPARABLE. An example …
-
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…
-
OAC Essbase - Outline validation failed, but there's no error in the log file.Summary Made modification to outline and outline has errors. log file says to check error file, but how do I do this in the cloud.Content I made some outline changes and…
-
Connecting Desktop Visualization tool to OAC Essbase InstanceSummary I have been working on connecting DV tool to the Essbase on OAC. I have a difficulty finding DSN for the Essbase instance.Content I get "Failed to save the conne…
-
DATAEXPORT - level 0 with upper level sparse membersSummary Need assistance on extracting data with upper level sparse membersContent Hi all, Is it possible to extract data with DATAEXPORT and fixing on two dynamically ca…
-
Unable to Cascade smartview ad-hoc report/sheet - EssbaseSummary Unable to Cascade smartview ad-hoc report/sheet - EssbaseContent Hi, I have created smartview ad-hoc template/report connecting Essbase - OAAC. When I am trying …
-
Migrating from EIS to Essbase StudioSummary Issue migrating from EIS to Essbase Studio; can this be done with ONLY using 64-bit machines?Content Hello Essbase Community, We are migrating from EIS to Essbas…
-
Broadcast Message to Users in SmartviewSummary Broadcast Message to User in SmartviewContent Hi All, Has anyone successfully configured a utility to broadcast a message to users in Smartview similar to the Pl…
-
Essbase error(1260046) - Unknown member used in querySummary Essbase error(1260046) - Unknown member used in queryContent Hi, I am trying to build a SmartQuery connecting OAAC-Essbase. While trying to select Base members f…
-
Security Load in PBCSSummary Security Load in PBCSContent Hi Experts, Do we have any import security utility in PBCS like we have in On-Premises? As of now i am thinking to export the dummy …
-
Building Dimension and Data Load Rules in Essbase CloudContent All, I have noticed that the interface for building rules in the "Rules Editor" is quite different than on-prem with EAS. I have yet to find any helpful document…
-
Create Intercompany Reconciliation Report on SmartView 11.1.2.5.720Summary Create Intercompany Reconciliation Report on SmartView 11.1.2.5.720Content Hello, my customer wants to create a report that shows intercompany transaction balanc…
-
Metadata is not getting updated automatically in SmartView existing adhoc sheetsSummary Metadata is not getting updated automatically in SmartView existing adhoc sheetsContent Hi, In Smartview report template, say A is Parent member having B and C a…
-
Essbase Administration - General QuestionsContent On-premise EPM admin here, but just got my first OAC to administer. I don't have access to the admin console via the webpage just yet, but had some general quest…