Hi, I am in the process of upgrading a customer from V11 to V12, and I am running through the OLAP to Relational Modelling process built by Kai Reischl. I am on the stage "Fill Staging tables" and am getting the following error across every dimension: Notify (Error) -> Calling function 'OLAPExportHierarchy' failed with…
The domain cubes are used to filter the perspectives based on a context. As far as I can see, there is no checking as to whether the perspective is appropriate to the context. This is left to the modeler. Is that correct? Also I would be curious to hear a use case for context dimensions not included in the base cube. I…
We would like to load an Excel as an attechment via a report and then import this into a staging table. i know that it works with CSV files. But how do you do it with an excel file?
Hi everybody, I want to make information from SQL query executions available to my users. So far, I have not found any way to display them the way NotifyInformation lets me insert messages to the execution dialog. Is there any way to achieve this? Best regards, Jan
Has anyone had any experience with creating an ODBC connection to the FSM Cubes, such as GLTOT?
Hi, we need to make a little update on the Consolidation Cash Flow module which is to change the version of data closing period (previous year) as currently the system use the same version you are working on and the customer want to use another one for an specific epigraph (Cash Flow Parametrization) If we could have…
Hi, i'd like to format an hyperblock where element code and description are showed only for base elements. Consolidated should only have description and i'd like to do it using Special Format String option in Display Value to mantains drillable column. When I try something like:…
Hello, In V12, in Consolidation, would it be possible to create a new element as a parent of anothers elements? For example, in the screenshot I have created 2 new elements: "SAP" and "Manual IFRS", and I would want to create a parent of these 2 ones with title "SAP+Manual IFRS" Thanks a lot and best regards.
Hi, do you know if with Consolidation it's possible to use the excel template to load data in transaction currency? We have this use case for an M3 customer: standard query provided by Infor fill the BudgetingMain integration table in local currency and the FactsTransactionCurrency integration table (only for intercompany…
Good day i am trying to configure my Financial Reporting Reports (Summary Trial Balance) by department Where only Department A can see department A's reports only. Only one department should have access to all department reports. I begun by creating the relevant user and application roles, I beleive that my problem comes…
It looks like you're new here. Sign in or register to get started.