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…
Hi, we are trying to create a string element in a dimension thru OLAP Modeling with no success, we have created a column in the source table called 'Type' and put a 'S' for the element: This table is linked to the dimension in OLAP Modeling definition: Once executed OLAP Modeling the element is created as numeric: Is it…
Eine Frage zu MIS Office Integration: Kann man diese per VBA ansprechen? Leider funktionieren einige Makros nicht mehr so richtig, da MIS noch die Daten aus der Datenbank kalkuliert, das Makro dies aber nicht berücksichtigt und vor Ende der Datenabfrage das VBA-Coding weiter läuft. Gibt es hierfür eine Lösung? Vielen Dank…
It looks like you're new here. Sign in or register to get started.