-
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…
-
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…
-
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…