-
Skipped rows of Cube value of 0
Hi guys, I have some issues that have skipped rows of Cube value of 0 but in Data Reader ETL is displayed well. I have unchecked Hide zeros and checked differentiate zero and null. Anyone have some ideas or solutions about this one? Thanks previously
-
Run an SqL data reader on the current selection
Hello, I'm running a data reader from a procedure with the YEAR (called Année) selection. I would like to scope the data based on the current year (selected when the data reader is run). Below the SqL command. I guess I should write something in the "Where" section. I tried with @Année which did not work. Thank you very…
-
Cleaning data in Data Reader with exclusion rules
Hi everyone, I'm currently working with the Data Reader in the Board Platform and I need some help with cleansing rules. I would like to exclude certain rows from being loaded into the entity based on specific conditions. For example, I want to prevent any record where a value starts with "5HR014" from being loaded into…
-
Expand datareader edit window in Board 14
The edit window for datareader in Board 14 is way too narrow. Currently it is nearly impossible to fully identify cubes, SQL table names or column names on a regular screen. The edit window for datareader should be just as wide as the pop up which opens when creating a new datareader:
-
Importing Data from PowerBI Dataset
Hello, has someone an idea or experience in importing Data from a PowerBI Dataset as Data Source? Best regards
-
Preview SQL statement should also work with final data reader process
We are using B12 cloud version and are connected to several SQL databases (our data warehouse). I know, best idea and work is that the SQL database has tables and views organised, that fit the need of board - without the need to implement ETL etc. However, life is not alway such easy and to get this, I always need support…
-
Datareader logs files header
The datareader logs files do not contain headers. They should have the same headers as the imported files.
-
Cubes
Let's suppose I have a cube with dimensions month, scenario, version, competency and another cube with dimensions month, scenario, version, los, location. The end cube in which I am storing the value also has location at it's dimension. LOS and competency entities are in relation LOS being the parent and competency being…
-
Datareader - Option to Log row where validation condition isn't satisfy
The idea Add an option to have the discarded line from the data source saved in a log file when the validation condition isn't satisfy Use case : Sometime, you now the row is in error and discard it as to not mess up the entity but it would be preferable to have a simple way to show the error to the end-user to ensure the…
-
Enable direct entry of the row number in the ETL Data Reader
Hello, Would it be possible to enable direct entry of the row number in the ETL Data Reader? This feature would provide a quick way to check our data and formulas, especially for large data sources (e.g., in my case, I have 200,000 rows).
-
Sap Analytic Cloud data import suggestion
hi, client migrated old bw database into a new sac platform. wondering if is possible in board14 to read data from SAC using other interface instead of the old theobald sap connector. any similar experience/suggestion to share? API? thanks
-
Allow the use of Temporary Cubes on Smart Import objects
The idea is simple: Allow the use of Temporary Cubes on Smart Import objects as we do for Data Readers. It should be possible to type the Temporary Cube name and load data into it. The Temporary Cube should be configured in the Trigger Procedure launched after a Data entry action. Today, for the Smart Import object, we…
-
Directly load unbalenced hierarchy (UBH) datareader via datasphere (DSP) connection
Dear all, the last months we have a big project to switch from SQL to Datasphere (DSP) as a data source for our transactional and master data. At this point there is only a workaround available to load unbalanced hierarchies (UBH) via datasphere (DSP) connections. As we have many unbalanced hierarchies (UBH) in use, we…
-
ADD NEW ITEM in datareader (transaction)
We use "add new item" in a data reader on an entity when we import transactions. When there is a new member in the entity, it is populated into the entity, which is as expected. The problem is that no data is loaded on this member, even though it is in the source we are reading from. Disc rec doesn't show anything…
-
Level 300, Module 304: How do I upload the data into the data reader? #Level300: Building a Planning
Loaded From txt Files, it's critical important to make sure we are integrating all rows.
-
Best practice data import and update CSV
Hello, I'm new to the board world and am having a bit of a hard time finding the right way to import weekly updated data from a .csv file. What would be the correct/best procedure to import the data and update it weekly. I'm really missing the common thread, where should I start? First create the entities or cubes or data…
-
Copy/Paste Tool for Data Reader's ETL
This proposal introduces a copy and paste functionality for ETL configurations within Data Reader objects in Board. Currently, when working with multiple Data Readers, developers often face the tedious task of manually configuring each ETL setting individually, which in some cases, is common for some Data Readers. This…
-
Data Reader limits ?
Hi, I would like to know if there are any Text File Data Reader limits in terms of size of the data loaded. I'll explain : I have this DR which loads only the highlighted cubes without any error message. If I delete this 2 cubes, keeping the others, it only loads the 2 cubes highlighted following. The file I am trying to…
-
Handling of .cfg Files in Text File Data Reader
In Board 12 & 14, the Text File Data Reader has a limitation in how it handles .cfg files when a pattern filter is used in the "Connection" tab. This impacts the automatic mapping of fields and the correct configuration of the file settings, such as delimiters, headers, and other parameters stored in the .cfg file. Issue…
-
How can I flag all periods between 2 dates?
Hi, I need to load some discount values from a table in SQL but the table does not have a month column. Instead, we have 2 separate columns; for Start Date and End Date. In normal circumstances, I would just take the last value from each of these dates and subtract the two lists, leaving me with the period between being…
-
Filename substitution formula in Data Readers
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: A new substitution formula @filename that returns the name of the file being loaded in the Data Reader. This formula could then be used in the ETL. Usage example: The client's cubes have the dimension "Month of…
-
Unable to load unbalanced hierarchy throught datareader
Hi, I have followed the steps mentioned in attached article on how to create unbalanced hierarchy. I have successfully loaded the entity members. Now as I try to define their relationship I am unable to do so. I want to assign AC2 as parent of AC3. Kindly help!
-
Improve SQL error log
Hi all, Board has SQL error log like "SQLError_YYYYMMDD.log". We cannot easy to load this log into cube. However, in many cases, customer would like to know what kind of error they have in daily batch. Could you improve to data format of the log as normalized? I have tested it on B14.1. However, it is still same format as…
-
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…
-
Massive replace of Data Reader source
Hello everyone, It would be really useful to have the following functionality implemented in Board, as we would be able to have more flexibility and easily maintain the data models. Massively replace the source of non-text Data Readers. Why? The connection between a Data Reader and its Source is currently based on the name…
-
Substitution formulas in Data Reader path
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Have already existing substitution formulas recognized on the path field of Data Readers. Usage example: By using @database on the Data Reader's path, when duplicating a database, and renaming it, we wouldn't have to…
-
ASCII Data Reader - Load first/last rows
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Add a new setting on the Data Reader "properties" tab that allows developers to specify a certain numer of rows to be loaded, and choosing wether to load the first or last X rows of the file, and ignore the rest of…
-
Improve formatting capabilities for Unbalanced Hierarchies in Row Templates
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
Maintain Row Templates for Unbalanced Hierarchies Automatically
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
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…