-
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…
-
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…
-
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…
-
Importing Data from PowerBI Dataset
Hello, has someone an idea or experience in importing Data from a PowerBI Dataset as Data Source? Best regards
-
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…
-
Data reader failing with error "ReadGo4EseguiCUBESdo failed for ddv" in diagnostic log
I have a client where SQL data readers started failing to fully load data yesterday with the error below in the Diagnostic log. A trace in SQL shows the queries executed properly and the other Board logs show the correct number of records. No other functionality in Board appears to be impacted. The client is using 12.4.0.…
-
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…
-
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…
-
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…
-
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.
-
Algorithms admitted in Data Readers or dataflows
Hello, It would be very interesting to have lists 📑 of all the formulas, operations and algorithms that we can use in dataflows on the one hand, and in the ETL of datareaders on the other hand. Do these lists exist, and could you please provide them? Thank you very much.
-
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 →…
-
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,…
-
How to hide/ignore columns of an Excel data source when using the Smart Import Object
Is it possible to hide/ignore columns of an Excel data source if they are not relevant for the import when using the file upload of the Smart Import Object (e.g. descriptions or comments)? In the following table, columns A,B (entities) and D,E (values) have to be imported, columns C,F have to be ignored.