Hello,
Is there a simple way to see which global variables, server lists, etc are being referenced on a report? I am using BI 11.0. My end goal is to have a full inventory of variables, lists, and so on for each report.
I have tried stripping 10$PVAR# and ListID references from the XML in the repository's SQL tables, but this fails to find any variables directly referenced in formulas or any that are used in report actions.
My best proxy for finding this has been checking the coVarValue table for latest stamp times and comparing to the variable references I've extracted from the XML, but clearly this doesn't give a complete picture.
I'd also be keen to know if it's possible to decode the FileStream binary in the coReport table, and if the 10$RHPB# references are located in a central table somewhere.
Any help would be much appreciated.
Kind regards,
Carl
