I am struggling with an issue in BOARD BI version 14.4 related to writing data from a ROLAP cube into a Data Warehouse table using a procedure, and I hope someone can point me in the right direction.
I have a standard (non-ROLAP) measure cube that is correctly populated via a procedure. The value is calculated correctly (for example 6.17) and displayed properly in the front end. The cube uses a single dimension Department, which is an entity with a numeric code (e.g. 9).
In addition, I created a ROLAP cube mapped to a SQL table in the Data Warehouse, using the same dimension. My goal is to persist the calculated values into the DWH, either directly through the ROLAP cube or by exporting the data via a procedure.
- The SQL connection is correct and the table exists.
- Exporting the data to CSV shows the expected result (e.g. Department = 9, Value = 6).
- Dataflows between cubes work correctly.
- When I change the Cube manually - it workes
However I can't get the Data into the DWH:
Writing to the ROLAP cube via procedure does not populate the SQL table.
Using Bulk insert to SQL Table / SQL Export works either.
My question is, how could I do it in a right way ?
Thanks a lot in advance.
