Essbase
Discussion List
-
Can we customize the Essbase browser tab?Summary: Is it possible to customize the Essbase browser tab? Content (required): We have several Essbase instances. When we're in the UI and connect to multiple instanc… -
IF Statement syntax errorI am getting an syntax error on my IF statement for the script below: Error: 1200336 Error compiling formula for ["Market A"] (line 12): [(] without [)] FIX("Product A")… -
Essbase 21.3MP ORA-00907Summary: ORA-00907 error when triggering a drill from Smart View: missing right parenthesis Content (required): Hi having error ORA-00907 error when triggering a drill f… -
Essbase 21.3MP cannot change solve order in the outlineSummary: Cannot change solve order in Essbase 21.3 (patched from 21.2) Content (required): Before patching Essbase 21.2 to 21.3, we were able to change dimension and mem…
-
Hi , I am working in Oracle as a tax analyst and I need access to essbaseSummary:I need access to essbase , while using smart view in excel i am not able to login to essbase cluster 4 to pull out some reports. I am attaching the printsceen of…
-
Groovy and Essbase Cloud APIs (Blog, not a question)Hi, This is a quick tip on how to use Groovy to work with Essbase JAVA APIs for those who prefer Groovy over Java. Thanks, Omar -
Essbase certification and training material and pathContent Hi, after searching on Oracle University it appears that there are no more Essbase certification nor training content and training path. So following Essbase 21 …
-
ASO Calc Manager rules failing validation after upgrade from 11.1.2.4Summary: Content (required): Has anyone experienced an issue with ASO calc manager rules failing to validate (and run) after upgrading EPM to one of the newer releases (…
-
Service unavailable after deploying 21c MP stackSummary Service unavailable after deploying 21c MP stackContent Hi Folks, I'm trying deploy Essbase MP 21c which is meant to make it easy to deploy and run Essbase etc. …
-
Is it possible to import partitions in 21c?Content We are comparing EAS Lite vs the Web Interface and one of the differences we found was with partitions. It did not appear that you can import partitions in the W…
-
TRACE_REPORT is not working as documentedSummary Need to track user retrievals on cubeContent Hi All, As per https://docs.oracle.com/en/database/other-databases/essbase/19.3/escfg/trace_report.html, TRACE_REPOR…Karthikeyan Pasupathy-269581 11 views 9 comments 0 points Most recent by Karthikeyan Pasupathy-269581 Essbase
-
ASO Dynamic Agg issueSummary ASO Dynamic Agg issueContent Hi All, I have an ASO Essbase Application in which we have Entity dim which is Multi Hier enabled cuase it has shared members , now …
-
Essbase data load rule and SQL interface errorSummary Object not found when running a SQL interface based ruleContent Hello, We have the following error when executing both a SQL interfaced based Data Load Rule or D…
-
Essbase Substitution Variable not working after migrationSummary Essbase Substitution Variable not working after migrationContent Hi Experts - Greetings!! I am migrating older Essbase version to a newer version (11.1.2.2 to 11… -
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…
-
How to use CONCATENATE FunctionSummary How to use CONCATENATE FunctionContent I am trying to push a value of 200 into all my level zero accounts that have a naming convention of Parent name "A12345" p…
-
Essbase Cloud Report Script Validate buttonContent Essbase Cloud JET UI does not have a validation button for Report Scripts. It makes the development of new Report Scripts very complicated since the only way to …
-
Essbase 21c respository db schema passwordsSummary The Essbase schema passwords will expire in 360 daysContent I deployed Essbase 21c in OCI via the marketplace. I created an ATP instance in advance. The Essbase …
-
Dimension Build using CLI tool failing occasionally with "Concurrent requests on the same session arSummary Updating Dimensions in ASO cube with CLI using stream dimbuild command occasionally runs on error ()Content Hi, for several month, we face an occasional error wh…
-
Updating ASO Essbase Cloud Outline by deleting a Shared Member: Error Message: Failed to Save OutlinSummary I am able to make other changes in my outline. However, when I go to delete a specific set of shared members I am getting: Failed to Save OutlineContent I am abl… -
Unable to set up confidential application to register EssbaseContent This is my first time deploying Essbase 19c from the marketplace. One of the pre-deployment steps is to set up a confidential application to register Essbase and…
-
New 19c patch releasedSummary the latest patch for Essbase 19c in OCI was released last weekContent The latest patch for 19c on OCI was released last week To see the changes visit https://doc…
-
MDX to Export data from ASO cubeSummary Trying to export very large data set via MDX in ASO cubeContent Hi Experts, Not sure if this is best way, but I need to export data via MDX script. I'm trying th… -
Office 365 and Smart ViewContent I read that smart view is only working in desk version of microsoft office applications. But now Microsoft is trying to push customers towards Office 365. What i…
-
Oracle Analytics Desktop to Essbase on OCI Market PlaceSummary Unable to connectContent Has anyone been able to connect Oracle Analytics Desktop to Essbase on OCI Market Place ? We had issues with Oracle Analytics Cloud conn…
-
Idea Lab for essbase cloud 19C?Summary Is there a dedicated section for sharing knowledge on Essbase 19c/ Essbase cloud?Content Question: Essbase Cloud is not part of OAC anymore - is there a dedicate…
-
Calculate a sum across yearsContent I have a requirement where I need to determine it has been 20 months since an entity has seen it's first activity (net income #missing). If the threshold hasn't…
-
Smartview settings - Member name and AliasSummary Set report to show both member name and Alias but disappears when someone else refreshContent Hi, I am using smart view version 11.1.2.5.910 (build 172). Even si…
-
Smart View Options - no longer saved on a report?Content Hi I am currently using v910 of smart view and previously I was using v710. When I was using v710, I remember that I can set different smart view options in each…
-
Create a cloud Essbase SR?Summary How do we create an SR for Essbase deployed from the Marketplace in OCI2?Content Does anyone know how to open an SR for Essbase that has been deployed from the M…