Data Reader

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…
SVG-Icons for Entities
I suggest the possibility to add own SVG icons to entities. This makes it possible to display them instead of or in addition to code/description in selectors, diagrams and dataviews. This option is particularly interesting for grouping entities, workflow entities or other static entities. It is important that these can be…
Matrix relationship SQL not working 🤔
Hello dear community, I want to do a matrix relationship via SQL datareader (same as explained in the resources below) : Here is a screen of the ETL : The result is an empty cube with no discard and "1" as a validated record Thank you in advance for your help
Ability to type in Row number to view in Data Reader ETL
Hi, I was creating a Data Reader with an ETL in the Validation Condition and wanted to scan across the file to view another row that had a different "Stock Source" to confirm that my formula was working correctly, but I had to manually flick between the rows. It'd be nice to, e.g., input row "200" as a text field in the…
ASCII Data Reader Option to choose the text qualifier
it would be helpful have the option to choose the text qualifier when reading a csv files. Looking at a similar function in excel to convert / split cells format, options could be " ' none. In this way the presence of question marks in some strings can be properly managed
Data Reader Upload files
Hello I would like create a Data Reader and use my own files to try some use cases. Would you mind tell me how to upload my files in the Board local storage so I can use them in the data reader Best regards, Anis
New Datasource: SAP Data Lake
Customers in DACH-Region are mainly driven by SAP. SAP Cloud is increasingly being used by customers. SAP data and non-SAP data is stored there. It is necessary to read and write data from SAP Data Lake. Connect to Data Lake Relational Engine Using the .NET Driver
SQL LOG 👀
Hello Dear community ! 👋 Where can i find the Log after running an SQL DataReader? (the log box is cheked) Thank you in advance 😉
How to set parametric WHERE clause for SAP
1. Abstract With the Theobald Board Connector, a SAP-certified middleware is available to load data from SAP systems (ERP/BW) to Board if the database of the system cannot or may not be addressed directly (e.g. HANA via ODBC). More information can be found here: In the simplest case, data is read from SAP tables, i.e. the…
Probably The Best Alternative to CSV Storage: Parquet Data
1. What is your idea? Board support a lot of datasources. Probably the most used are csv files. However, with ever increasing amounts of data, working with csv files becomes a pain. Parquet files can be an alternative. Head-to-head comparison CSV Parquet Row-based storage format. A hybrid of Row-based and column-based…
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…
Dynamic Filter Parameter in Sap Connector
the idea is to make more parametrical the theobald sap connector. right know is not possible to link a selection made at screen level (example with a selector) to the data reader allowing to reduce the dataset to be loaded. so for example if we are loading large dataset the loading process will take a lot. the parameter…
Add option to set all 'Modes' in a Data Reader to 'Add New Item' automatically
Hi, I think it'd be useful and efficient a have a button to switch all the modes automatically from 'Discard New Item'/'Read' to 'Add New Item'/'Replace'. This would be very useful in new data models or when loading a new entity/hierarchy as you do not have to manually change the mode for each field area in the data…
Add pop up button that directs to data reader steps in procedures
Hi, I was wondering if we could please add a button similar to the "call procedure" step which links to and directs the user to the procedure that is being called for the data reader steps. The proposed button would look something like this and would open a new page that links directly to the data reader that is being read…
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…
Temporary DataReader in Procedures
Hello together, to reduce the number of DataReaders, it would be helpful if DataReaders can be created temporarily in a procedure. This would also significantly increase flexibility in combination with temporary cubes. Best regards Christoph S.
Quickly adding/dragging of Entities or Cubes within the Mapping page of DataReader
Just to make life easy, we should have a checkbox beside each entity/cube which should allow the developer to select multiple entities or cubes with the help of ☑ or [Ctrl + select], and then drag it at once. This should be applicable for all versions including Board 14.
ASCII Flat File DataReader - Move data file after reading
Dear all, I really appreciated the new "Delete file after reading" checkbox in procedures. I guess that, like most of you, our customer(s) require to move the flat file from its folder to another folder after its data was integrated into Board. However, most of the time, keeping the file in order to control the data loaded…
Transferring data directly from one database to another
Situation: Assume that planning takes place in different databases for various reasons. Now the results of the planning are to be merged into one database. One possibility is to extract the data from the planning databases into a CSV and read it back into the reporting database. Request: It would be nice to have a function…
Convert varying to Text
Hi All, I want to import values from a postgre database using Data Reader. However, some values are in varying format. How can I convert them to text in the Data Reader?
L200 - Module 204 : Data are not upload in Data view
I have mapped data in Data reader for units and sales Cubes, but the size of cubes are still 0kb and the data object view is empty. Where can be the issue?
Resize Columns in ETL Tab of Data Readers
Maybe we are unique in having a field that is very long, but having the ability to manually change the width of columns in the ETL would be fantastic. We have different combinations of materials that can go into our goods, all depending on what has been ordered. In order to make this happen and price things appropriately,…
More flexibility regarding format of import file
At the moment Board is quite limited regarding the format of import files, as one column per entity and just one column containing values are required → Table on the left side of the screenshot. It would be much more comfortable to be able to import more than one column containing values, for example values per year →…
Procedure Visibility in Security
Just like Cube Visibility in Database Security, it would be meaningful to have the same security functionality for Procedures, where you can have Cubes that control Procedures that are possible to run. It could also be applied to Data Reader (Visibility).
Enhance SAP DataReader procedure step with substitution formulae
It is possible to set additional parameters in the procedure step referring to an SAP DataReader Unfortunately, it is not possible to use any substitution formula here where the values to be used could be directly derived from a selection. The parameter is directly transferred to the connector as plain text. It would be…
Rest API Integration into a cube in Board directly.
Hi, We have set up a Rest API call that bypasses the pipeline and pulls data from a different model in our Board instance. Is it possible to take the payload(source data) that we get from the Rest API and push it directly to a cube in our datamodel? We do not want the payload to be exported into an output file that is…
Is there a way to extract a file name in the data reader ETL?
Hi Board Community! I am working on creating an ETL logic to dynamically extract months to a correct fiscal year. The complication comes in because there are some of the future years that need to roll up to the year end of the particular (past) year. I know that there is the formula in excel that allows you to extract the…

Data Reader

Discussion List