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
-
Groovy MDX script to get HTD valueHi Folks, Can you please help me writing MDX script in groovy to calculate HTD value or at least YTD value. Below script is throwing error: A method called by the script… -
Recording SmartView report's "Last Retrieved" timeSummary: I have a SmartView report (Version 23.200). The report has about 50 data pull sheets and one control sheet where I define parameters (such as Product and Entity…
-
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 …
-
How can I use HypUIConnect without a friendly name?Summary: I need to convert multiple Smart View reports to point to a different database. The "from" and "to" database have different number of dimensions; some dimension…
-
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 Essbase Error [1020098]: Duplicate name found in Grid, unable to resolve.Summary: I get the following Smartview error in report that used to work fine, adjusting the Account dimension values fails to resolve the issue, Essbase Error [1020098]… -
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 run MDX query with multiple Select statementsSummary: I'm running an MDX query that times out with the following error message: I'm trying to circumvent this limitation by breaking down the query into two smaller o…
-
Essbase Calculate Script: How to define the prompts in a specific orderSummary: As shown in the screenshot, the order of the prompt is not optimal - it is confusing to the users. I would like to know if it is possible to define the prompts …
-
Error trying to run MDX query via VBASummary: I'm trying to run MDX query using HypExecuteMDXEx function. Just took a sample from the book, put in my parameters and a database, and when I tried to run it, g…
-
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…
-
How to change the length of the subinventory, which currently only supports 10 bitsHow to change How to change the length of the subinventory, which currently only supports 10 bits
-
Journal Posting errorJournal Posting error : No sequence version is enabled or defined for sequences with an expiration date of 01/31/24.
-
Essbase Report Writer decommissioningSummary: Are there any plans to decommission Report Writer, and if "yes" - when? Thanks!
-
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…
-
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…
-
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…
-
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…
-
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… -
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… -
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), …