Essbase
Discussion List
-
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 …
-
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…
-
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…
-
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…
-
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…
-
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…
-
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
-
(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…
-
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…
-
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 …