-
sql data reader step is not working in procedure whereas it is running manually
There are bunch of data readers which i have ported along with some cubes and procedures , so everything is fine except the calling sql data reader step in procedure , it is throwing an error and going to error group whereas manually it is running perfectly, can any body help with this. please find the error from the logs.
-
procedure step > text file datareader > changing filenames: how to manage this
Hello, I want to track manual data-entries done by the users of an application. Therefore i: parse (through Text file data reader and Board ETL) the appropriate file trigger this datareader in a procedure run by the user BUT the procedure step needs a fixed filename whose name is not changing over time. — Details: The…
-
Monthly Customer News Update - September
Stay up to date and rewire your brains with the latest contentand trainings to lay the foundation for a successful H2 and beyond. We wouldalso like to highlight the G2 review campaign which includes a donation to a charitable cause: Product: Board 14.4 is here with an updated data reader, plus: SOC 1 Type II Report How to…
-
Charge unbalanced entity with datareader
Hi community When i want to charge an unbanlanced entity with my datareader , i always have one rejet for the parent code not found and in the relationship part i find that the parent code is missing , do you know where comes from the problem?
-
FileRead ERROR:File Missing what is the causes of Datareader file missing?
Hi all, I want to know the causes why when I tried to run Datareader manually, FileRead ERROR:File Missing always be shown? I have checked the path is ok. Any ideas about this issue? Thanks.
-
Data Reader Configuration From Local System
Hi Team, I attempted to configure the data reader to load a CSV file from my local system. However when i specify the file path, no files appear to be available or recognized by the system. Please advise if there are any prerequisite configuration or settings that needs to completed before this step? Thanks for your…
-
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…
-
Importing Data from PowerBI Dataset
Hello, has someone an idea or experience in importing Data from a PowerBI Dataset as Data Source? Best regards
-
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…
-
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
-
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…
-
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…