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 to update Data Storage when loading metadata via Essbase cloud UI?I have a metadata file with 3 columns (Parent | Child | Alias). I want to updated the Data Storage type of the existing metadata (same metadata as in the file) from "Sto… -
connect to essbase via webversion of excelSummary: connect to essbase via web based excel office 365 I have installed the chrome addin for smartview, opened excel 365 in chrome, i dont see smartview add in to co…
-
Essbase21 - unable to open outline in web interfaceI am trying to edit the Essbase outline in the web interface. When I open the cube and click "Outline", another Applications window opens. I tried stopping and restartin…
-
FRS: Show only GL description, hide account number.In Financial Reporting Studio (FRS), I am creating a financial report where I want the GL Account column to display only the GL account description, without showing the …
-
OAC - Essbase report script limitation/queriesSummary: Hi All, With Essbase Report Scripts wanted to check if these limitations still exists? I don’t think there are any new features on these but wanted to confirm. …
-
How can I copy an Essbase on-prem application from production to test environment?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to delete the dimension in ePBCSSummary How to delete the dimension in ePBCSContent Hi All, The below screen shot accidently create dimension TECOCTH9000 , How to delete the dimension in EPBCS? Please … -
How to avoid the parameters in the BIP report output which is a .cvs file?I am creating a BIP report. Expected output is in .csv format. I tried both RTF and the direct report builder, but still in the output I am getting the parameters as the…
-
How to delete multiple members using the Essbase 21c REST API?Summary: I'm using the rest api to delete members from the Essbase outline using the mbrDelete command. It works when I specify only one member but fails with this error…
-
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,