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…
Hi, We'd like to know what is the maximum length of a comment that can be entered in a standard financial planning step data entry form (workbook main data entry, tab comment). For example, how many characters are allowed, and if there is not only a technical limit but also a critical value that may lead to errors. Thanks…
Hello, we have a v12 multitenant environment, where we are trying to use the WBC("#COPY ",....) function in the action of a cell in Application Studio. We are doing a simple example, on a crossing of cube base elements. These functions work correctly:…
Hello, I need to model some formulas in EPM. These are particularly complex formulas that involve for example positional calculations and built-in functions like IRR. The input data for these formulas will be directly entered into Application Studio (there is no externally acquired data). The formulas are dynamic…
It looks like you're new here. Sign in or register to get started.