Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

System cube with datareader infos

Idea created by nicolasc on Jul 18, 2019

Comment • 5

Open for voting

Score14

+5 more

Currently when launching a datareader using a procedure and with a button in a screen, to my knowledge there no way to display directly in the screen the result to the end user in term of row rejected and integrated. Or even prompt a pop up with a "Do you want to continue?" message when a reject happen in order to prevent losing time on calculating wrong data.

For that reason, it would be a nice idea to have the possibility access technical/system cube(s) within our current database, in particular the total rows, and rejected rows. For example, with a cube having following entities :

Data Reader (automated populated entity with all the data reader name)
Informations (Row total, Row valid, Row rejected, time in sec)

5 Comments

sebastiangurt Jul 23, 2019 9:55 AM
Hi Nicolas CHIGROS,

you can access this information by loading the Board database log file immediately after running the data reader. It contains the number of rows (rejected, valid, time in sec). When you activate the decicated log file option for the data reader you will also receive a log file with the rejected records.

Hope this helps.

BR
Sebastian
Like • Show 2 Likes2
Actions
- nicolasc @ sebastiangurt on Jul 24, 2019 5:15 PM
  Hi Sebastian Gurt,
  
  Thank for taking the time to answer! I know I can do that and forgot to remove "workaround : None" from the previous idea I've posted. My bad
  
  However, the point of this idea is to improve quality of life for developer and end-user as the workaround you provide :
  require quite a noticeable amount of extra step for every project ever
  require maintenance of a custom "Data Reader" dimension.
  require you didn't name a Data Reader in SQL the same as let's say a ASCII file one
  
  All little things adds up, and I understand Board is a toolbox, but I think with 11.1 out, it's time to add more tool out of the box!
  
  Regards,
  Nicolas
  Like • Show 2 Likes2
  Actions
  - nicolasc @ nicolasc on Aug 2, 2019 4:30 PM
    The timestamp in the log filename is also very annoying to deal with using a data reader in a Board only environment.
    Like • Show 1 Like1
    Actions
- nstratton @ sebastiangurt on Jul 26, 2019 12:23 AM
  How do you do this? We have a cloud server and I can see the logs page in the Data Model but I'm not sure how to reference that data.
  Like • Show 0 Likes0
  Actions
sebastiangurt Jul 26, 2019 8:38 AM
Hi Nigel Stratton,

the logs are always in the same location, whether on premise or in the cloud. You can load them with a CSV data reader. For details regarding the logs check this: BOARD LOGs in detail .

Also you should have the standard log analysis application deployed on your cloud instance (if not ask Board Support to do so). When you check the data readers in that database you can find some inspiration on how to load the log files. Maybe the application itself already helps you.

BR

Sebastian
Like • Show 3 Likes3
Actions

System cube with datareader infos

Related Content

Recommended Content

Contact Board

Discover BoardVille

Follow us