Good day Community. We are trying to copy data using the OLAPCopyDataArea function. This works for loaded or captured data but doesn't copy calculated data (data created by a business rule). A business case example would be copying a calculated version of data into a storage version that doesn't have rules applied to it.…
Hi, We plan to set up mobile devices for EPM. We have an on prem Infor platform (IFS) with an InforOS Server. The InforOS server stands in the DMZ and a reverse proxy server handels the external url pointing to a Webserver in the DMZ. Has anyone setup the mobile devices already and has some pointers on how to get…
In v11 Designer, you were able to import the current rules for any cube. This is an essential feature for OLAP modelling. I have just had to update a series of rules because of index number changes in Edit OLAP in one model and I am trying to remove the accelerators from another model. Both of these processes have involved…
Hi, we have a Hyperblock pointing to a relational table thru a SQL Statement with parameters pointing to report variables in the clausule 'WHERE' working successfully. Problem is when putting another report variable in the 'ORDER BY' clausule getting an error but if we put the value manually in the SQL sentence…
Hi all, I wonder if there is a way to open and read native Excel-files (XLSX) in APE, like it is already possible in Importmaster. In the APE-documentation I only find how to handle CSV-Files. Very often users are maintaining data in Excel-files, because it’s easy, everybody knows how to do. You know, they just use the…
Hi everyone, I have two cubes with the exact same dimensions. Cube one is the out of the box cube that retrieves general ledger total data and cube two is used for user inputs. From reporting standpoint, we can create reports in Application Studio that pull and stitch together data from both cubes by calling on same…
Can I use SQL syntax in the source column filter? That is, can I filter the data so that only values starting with A are imported by writing A% in the Source column filter field for that dimension?
Hello, in an Application Engine script we are using the SQLBulkInsertData function to write ~100.000 rows to SAP HANA. This process takes around 10 minutes and it seems like the inserts are executed row by row instead of being inserted in larger bulks. Do you have any ideas of how to speed this up? Thanks and best regards…
Hello, we will need an OLAP model transferred back to the standard tables of Relational Modeling. Since we have more than 100 dimensions, we'll not do this by hand. We already have some code that creates the tables with the meta data (cubes, dimensions, attributes, rules). But in order to publish the model, we'll also need…
Hi, We try to build a report, that allows the user to change some values via Application Engine Script (Mode: Edited Cell). The script is needed, as many values have to be changed at once. As the report is quite big, it takes some seconds to re-compute. We able to identify the changed cells and tried to change the refresh…
It looks like you're new here. Sign in or register to get started.