Hi Team,
could you please help me to find which log file has the details of data load happen in a a cube against on a selection of one its dimension.
Thank you for your support.
Hi Vanam, apologies for the late response on this.
What sort of data reader are you using here, ASCII?, SQL?
For an ASCII data reader if you have logging enabled the log file will appear in the same location as the file being loaded, for a SQL or SAP data reader it will appear in the Log section of the Admin Console under the Other group, see here https://help.board.com/docs/run-and-manage-data-reader-protocols#log
Hi @Robert Barkaway, Thank you for response.
Actually, we are running a SQL data reader to load data into cubes in schedule base using windows schedular. However for the SQL data reader you mentioned, there it saying "Other Logs" in cloud Administration portal. but we are in On-prem.
could you please help me to find the log for data loading in cube with a selection.
Hi Vanam, for an on-premise solution the log file should just appear under the Board\Dataset\Log\ folder on the server itself.
Hi @Robert Barkaway,
I am afraid that, I can't find any such log where i can have the details of dataflow into a cube with the "selections".
please help me where i can find such log file.
Hi Vanam, I thought you said it was a data reader? For data flows if you have data flow logging enabled they'll appear in the database log (HBMP_<Database name>_202610), however the log won't show the current selection when the data flow took place, the only way to capture that is to build something yourself - create a logging cube dimensioned appropriately of type Text and add a dataflow to your procedure which flows @Selection into that cube before the data flow you want to track, that will capture the full selection so you can then review it. Be careful as such cubes can get large very quickly in my experience, so should only normally be used for debugging and then disabled when not needed.
