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