Read Log Files into a Capsule
Good morning
I have a personalized admin capsule where i do administrative jobs like load cubes data
and i would like to reads the logs file generate from the import into a screen.
do anyone has experience on that matter ?
A good example is the task manager screen where you can see e formated log with head columns
Answers
-
Hi Massimo. Navigate to C:\Board\Dataset\Log and you will find files like this - HBMP_Standard_BI_Demo_201802.txt, where 'Standard_BI_Demo is my Database and 201802 is the month and year. HBMP always appears at the beginning. This file, when opened in Excel looks like this:
So, in this file you can isolate the data reader executions and load this into a BOARD capsule screen using another Data Reader, with a little bit of ETL to capture just the rows you need. Does this help you?
1 -
Apologies - I missed column A from my screenshot above. So, in this case I am interested in those Action Codes marked 'FR'. I don't have a glossary of all Action Codes, but maybe somebody else here can provide this.
0 -
Hi Massimo Minato,
All log files can be imported into a Board application, for analysis and statistics.
Here you will find a list of log files available BOARD LOGs in detail.
In the support area, you can find a sample application: Log Analyzer Application
Fabio
8
