-
Extract layout
Hi all, i want to know if it is possible to extract a date cube A (dimension: Entity) on premise: into something like this in a txt or csv file. sv0001 20241107 1 My final goal is to use this file for a data reader to populate a cube B with two dimensions (Entity and Month) with the same values as in the picture. P.S. I…
-
Board Tree Public API
In addition to the existing APIs, it would be useful to have a public schema for retrieving a specific hierarchy via API, similar to the one available for entities. Currently, if we want to extract a tree from the Board, we must create a custom API query that includes all the necessary fields from the layout section, which…
-
Procedure Step to 'Extract cubes by Entity' and 'Clear cubes by Entity'
A developer or a support analyst is frequently required to extract a large number of cubes while extending the max item number for a particular entity. This may be carried out through a Procedure step - the ‘Extract cubes by Entity’ option on the Live environment. Further, another action involved in extending the max item…
-
Export dataset - Remove the quotation marks
Hello everyone, I am facing a constraint with the export dataset feature. I would like to export a large amount of data with more than 4 entities on row without the header and the quotation marks. Currently, when I execute the export dataset, I get the following pattern : "XXX";"XXX";"XXX";"XXX" I would like to get the…
-
How to extract entities in code with cube extraction
Hello. I'm currently failing to reload the data because the input data in the cube is extracted with the description rather than the code. I think the problem could be solved if the data could be output in code. I would like some advice as I am currently facing this issue and don't know how to resolve it. I'm sorry that…
-
UBH Extract Dataset - Behavior of Parent Level Selection
Hi Team, Having spoken to people in product already, I wanted to put this idea out there. Business Ask : Being able to pull data for a parent level on a UBH out on an export dataset Issue : Currently, Board has no way of being able to select a parent level member on a UBH and extract the aggregated sum of all its…
-
Bulk Insert to SQL Table failed!
Hello, I tried running a basic procedure, with an initial selection and a bulk insert step. However, the procedure fails and gives this error: ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. Moreover, it does not recognize the fields in the SQL query. In the log file, all the fields are…
-
Delta Lake for read/write parquet files
What is Delta Lake? Delta Lake is an open-source storage layer that brings ACID (atomicity, consistency, isolation, and durability) transactions for big data workloads. Key features of Delta Lake Feature Description ACID Transactions Data lakes are typically populated through multiple processes and pipelines, some of which…
-
Enable "@[entityname]" for the file path/file name in Data Readers and Extract Steps
1. What is your idea? Enable "@[entityname]" for the file path in Data Readers and Extract Steps also. For the new REST API call step this is already possible. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? If a procedure is used for the export and subsequent…
-
Extract Cubes in Parquet-File
1. What is your idea? Board has multiple steps to extract data from cubes: Extract Cube Export Data View to file Export Dataset Extract all cubes All these steps save data as text or csv-files. We could save disk-space and increase performance by using parquet-files. Head-to-head comparison CSV Parquet Row-based storage…
-
extract all cubes > create log
Hi, when you execute an "extract all cubes" procedure action, no log is created. it would be really useful to have a detailed log about all the cubes extracted, in order to be able to check if everything worked as expected. consider that the "reload all cubes" already creates a detailed log on the reloaded cubes, so…