Hi, There are a few functions not available in the 12 UI that can be executed using the XML API. One is updating an attribute driven hierarchy. I have written a Python script to do this, and it works fine. But I don't want to install Python at the customer site and I would like to be able to do it without any third party…
Hello Experts, I am facing issues at one customer, as they do some additional calculations in Microsoft Excel and finally copy & paste the results into an INFOR EPM Application Studio Dashboard in order to store the values in the OLAP database. This workfow accelerates the data entry process as Copy & paste is faster than…
Hello, I have a spreadsheet using the excel integration that I have been using for about 1 year. About a month ago all of my cells that use =INFOR.GET.ELEMENT or =INFOR.READ.VALUE formulas return a value of #VALUE!. If I click into the cell with the error and tab out of it, the cell recalculates and returns a valid result,…
Hello, I would like to know if there is any way to import a Trial balance, with YTD data, and EPM can automatically identify the differences/movements between the YTD values ??and the opennig balance values. And so the sum of the elements of dim Schedule Detail Movements and opennig balance is equal to the YTD value in…
We use the following codelines in an Application Engine process: SetCustomSetting(RepoCon, "cs_ImportYear", xYear); string sCS_ImportJahr=GetCustomSetting("cs_ImportJahr", "xxxx"); NotifyInformation("Import year:" +sCS_ImportYear); xYear is 2024, which is also written back and displayed in the administration. However, the…
I used the ad-hoc tool to create a table of data, and I want to add a bar chart widget from self-service to the dashboard and have it auto-populate based on the selections in my ad-hoc. Is that possible?
Hello, I'm wondering whether it is possible to change the number format of a chart axis depending on a data selection. Here is the use case: an AppStudio report returns values which can get rather big. So I've added the possibility to select a scale (absolute, thousand, million). In case the user selects "million", I want…
I've been playing with this function and I don't understand the support in AppStudio. I have a test cube with three dimensions -- Period, Measure and Channel. I filtered out the CHANNEL. I just use this formula in the spreadsheet. =NOTEGET("MYSample";"LOADTEST";D7;C8;ReportObjects.CHANNEL.Text) My expectation was either…
Hi all, Has anyone experienced and resolved the following error when using OLAPExportHierarchy: Executing the process failed with an error. The returned message was: An error has occurred: Calling function 'OLAPExportHierarchy' failed with this message: SQL error during export to SQL process.. Error code '372': SQL error…
Hi. I am transferring our v11 subsets to v12. These are mostly account subsets with a specific order which is not the order of the dimension structure. This seems to be a big issue, if there is no possibility to give an order id. I tried different ways: * Insert the accounts into…
It looks like you're new here. Sign in or register to get started.