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
-
How can you Dynamically copy multiple smart list members into single member in the same dimension?Summary: I need to copy allocated data into an unallocated member for two dimensions. Content (please ensure you mask any confidential information): I want to move data … -
SmartView - write operations are currently not allowed in cluster modeSummary SmartView - write operations are currently not allowed in cluster modeContent Hi guys, have you ever happened to get this error when you try to input/cancel and … -
LCM Using ESSC Not Bringing in All BlocksSummary: I recently exported an LCM with data and imported into a new environment. Viewing the logs, all data was loaded successfully and the same number of blocks were …
-
Smartview error: "Member **** is out of place" when refreshing ad-hoc formsWhen selecting Member name and alias in "Options", display them simultaneously. After improvising the form and refreshing it, it will prompt: Member **** is out of place…
-
Drill through on parent of shared membersSummary: We have an Essbase 21c drillthrough report defined with filters set up to allow us to pull level 0 members of any dimension and pass them to Essbase drill throu…
-
Calc Script for YTDSummary: I am trying to create a separate dimension in Planning called "View" using a member formula to calculate MTD, QTD or YTD values based on the selection made in t…
-
How to connect the oracle fusion Bi publisher with Oracle Analytics Cloud?Summary I would like to connect oracle Fusion(20A) with oracle analytics cloud.Content I not able to create the storage classic in the oracle cloud. So how to connect or…
-
Intelligent agg with ILANCESTORSRe-posting my question here because it might be more appropriate than the Planning forum I have a data form with two sparse dimensions on the row (CC, Product). Groovy d…
-
Error using summation in MDX querySummary: I'm trying to pull data from Essbase using a group of members that I need to sum up. To do it, I'm using WITH statement that looks something like that: With Mem…
-
Journal Posting errorJournal Posting error : No sequence version is enabled or defined for sequences with an expiration date of 01/31/24.
-
Essbase certificationsSummary: Hi, should we expect Essbase certifications to be back on Oracle University. And when ? Same question for Essbase etraining on Oracle University. Content (requi… -
Passing parameters to Report Writer scriptSummary: I'm trying to create a universal data extraction process that will utilize Report Writer. The idea is to have a standard extract layout (placement of dimensions…
-
Essbase Report Writer decommissioningSummary: Are there any plans to decommission Report Writer, and if "yes" - when? Thanks!
-
Looking for the easiest way to view an essbase outlineI'm trying to debug an issue with a current cloud planning and have the outline extracted from the essbase data artifact. I'm looking for the easiest way to view it. Are… -
Essbase Error (1270073) Failed to read data from file.Summary: In ERP, when posting a Journal, it ended in error 1270073.- Failed to read data from file .../temp/ess00001.dat, does someone know the reason? We must explain i…
-
Is there a way to facilitate loading over a billion records into a cube on Essbase 21c?Summary: I have a cube where I will need to load a billion records in a timely manner. Are there any efficiencies that I might gain by employing something like Cameron d…
-
Essbase Error (1270073) Failed to read data from file.Summary: Essbase Error (1270073) Failed to read data from file. What is the reason? or what does this error mean? Content (please ensure you mask any confidential inform…
-
C:\Program Files (x86)\Oracle\SmartView\bin\HsTbar.xlaSummary C:\Program Files (x86)\Oracle\SmartView\bin\HsTbar.xlaContent Hi, I am building Function report using the Smart view client version 710. In my report, I have to …
-
Line numbers don't match in audit files ATX & ALGSummary: The line numbers in both .atx and .atx don't match with each other Content (please ensure you mask any confidential information): Until lately, the line numbers… -
QR Code Scanning in Fusion BI ReportHello All, We have developed an invoice print report for one of our clients and embedded QR Code in it. Now our requirement is to get the report output along with QR Cod…
-
Oracle Analytics Publisher Desktop will not installSummary: When installing Publisher for our OPM it will not install. Content (please ensure you mask any confidential information): We get Can't Find the file C:\Program … -
Add a restructure job in Essbase 21 consoleSummary: Add a restructure job in Essbase 21 console. Thank you Content (required): Version (include the version you are using, if applicable): 21.4.3 Code Snippet (add …
-
Is there a way we can automate downloading the provision report for security?Summary: Other than going in to the UI manually to each application and database by database to the Permissions tab and clicking on the Provision Report. We'd like to ha… -
Essbase BSO outline formula with @AVGRANGESummary: I'm trying to create a dynamic formula in the outline for the average of the last 12 months in PBCS. Account and Period are denses. When I change to dense dimen…
-
Essbase Studio rule filesSummary: Hi Team, Is there anyway to check rule files without Essbase studio, which built using essbase studio ?? Content (required): Hyperion version upgraded to 11.2.x… -
Unable to perform formatting in Hyperion planning Task manager reportsSummary: I am able to create a task report but later user is looking forward to format it like if suppose the task is running on current date so green if the assigned ta…
-
Export data toward ADWSummary: Looking to export data from Essbase OCI/MP to Autonomous, however this is not possible to export anymore toward database using DATAEXPORT command. DATAEXPORT "D…
-
Smart View VBA Functions RoadmapSummary Smart View VBA Functions RoadmapContent Can someone tell me Oracle's road map for Smart View VBA functions? I've developed an Excel report that utilizes function…
-
Dynamic filters errorSummary: Hi we are experiencing error with dynamic filters in Essbase MP 21.4.3 when submiting data using Smart View. Content (required): Error message: Error(1200315), …
-
Upload a file using Essbase REST API Multipart endpointSummary: Essbase REST API Multipart Upload loads an empty file. Content (required): I'm trying to upload a file using multipart upload via rest api using this document. …