Data Reader

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?

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?

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…

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…

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

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.

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.