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
-
View Exchange Rate in SmartviewBusiness user would like to view the PeriodEnd exchange rate in smartview. So that the user could able to see what rate has applied when they review the balance of that … -
Cannot Clear Partial Data. Essbase Error(1260046): Unknown Member [Periodo].[Q4].[OCT] used in queryI have a problem when executing a command in PCMCS from EPMAutomate, it shows the error Unknown Member [Period].[Q4].[OCT] used in query, this error appears even when yo…
-
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]… -
Create or update an associated UDA or Attribute using a calculation function or CDFHello guruz, is there any way to create or update an associated UDA or Attribute using a calculation function or CDF ? So far I did no found the function ! Is anyone doi… -
NonEmptyTUple syntax errorSummary: Hello, I have some ASO formulas but data retrieving is very slow on this members formulas. I'm trying to optimize this by usinf NonEmptyTuple but i git the erro…
-
Can we load custom excel data via rules files in Essbase 21c?Summary: Hi All, As per Essbase 21c documentation Microsoft excel is listed as one of the data source types supported. Apart from the standard dimension/data import ment…
-
Essbase Error 1020098Summary Essbase Error 1020098Content How do I troubleshoot and fix this error message?
-
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
-
API interface push create transaction processing error, AR moduleYou must enter a valid account classification. Valid account categories include: Accounts receivable, revenue, taxes, and freight. (AR-857782)
-
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…
-
Smartview retrieve file gets very large on saveSummary: Hello, We have one user, when he Smart View retrieves on 5 different template files, the retrieve works fine, but when he saves, the Excel file will grow to a v…
-
Execute Maxl commands and scripts from Essbase 21 consoleSummary: Content (required): Maxl statements or scripts cannot be executed from Essbase 21 console. Please add this feature as it currently exists in v11.x Version (incl…
-
Essbase Marketplace: best practice for log rotation and /tmp and /u01/tmp cleaningSummary: Hi, I am used to deploy Essbase 21 Independent Deployment and Marketplace version, and I am seeking best practices for the following points. I already searched …
-
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…
-
check if essbase database has any data load, or calculation running?Summary: Hi Team, Is there a way or maxl command to check if essbase database has any data load, or calculation running? Our requirement is to check if any Calculations …
-
JExport in Essbase21 CWe recently upgraded from Essbase 11.2.5 to 21C and are having trouble using some of the udf functions. Just wanted to check if anyone has used JExport with Essbase 21C?…
-
Rolling SumHi, I am trying to get the Rolling Sum of 24 months using ASO MDX query. Need help. Thanks, Nandakishore
-
FRS ReportHi, Is it possible to hide / unhide few columns in FRS report by adding new parameter (i.e. Detailed, Summary)? Please guide. Best Regards, Muhammad Haroon.
-
Is possible to use Smartview in Android?Hi All, Does anyone knows if there is a way to use SmartView in an Android smartphone? I really appreciate any help Regards,
-
(AP-810825)Fusion call exception: You cannot do this because there is no valid invoice with the information provided. (AP-810825)
-
User role access to application file systemHi, let me bring to your attention that users with User role are still able to access application files system and then download sensitive files such as data exports. We…
-
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…
-
Oracle Analytics Publisher Desktop installation failSummary: Good evening experts, I'm trying to install Oracle Analytics Publisher Desktop 7 on my workstation Before this attempt I made another one, but stopped it. Now w…
-
Migration of "Hyperion Financial Management Plus" from on-premise to OCISummary: IHAC running "Hyperion Financial Management Plus" at on-premise and planning to move to OCI. Few questions: Do they need to have "Exalytics In-Memory Software f… -
HS function Smart View Report (Essbase)Summary HS function Smart View Report (Essbase)Content Hi, We have reports that are using the hs-function in smart view because we need custom formula aggregation in the…
-
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…
-
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 …