Export of report dependencies

Sylvana Neydek

Hello,

Today I came over an Enhancement Request asking for a dependency analysis of Application Studio reports to used cubes, dimensions etc as an extension or similar function as "Report dependencies".
This is something we are highly interested in as well. How would we use it?
1) To analyse the impact of cube and dimension changes to reports. You then know where to take a closer look at afterwards.
2) We have a lot of Import Master and some AppEngine Jobs running in the background filling cubes with data, filling settings cubes, setting rules etc. At the moment we have a manual list which cubes are used in which AppStudio report and which job uses which cubes and dimensions. From that we generate warning messages when opening an AppStudio report, e. g. "Be careful, job XYZ is running and could influence the current data. This should be finished at XX:XX."
=> This could be done in a more automatic and therefore better and error less (missing entries in manual list etc.) way then currently.
Do you have similar use cases? How do you solve it?

Please vote for:
106580 - Export list of reports where a defined cube is used

Regarding the current function to export "Report dependencies" named in this ERS. I really like it and it will definitely help to handle the mass of global variables, lists, ...
If you export this information, you get a csv-file. Is there any table in the background, I can refer to directly? Then I would integrate it in an AppStudio admin report to filter in real time for specific objects.

lindenbauer-michael

Hello Sylvana,

thanks for promoting my ER, I really appriciate that. 
I'm glad that this feature could also be useful for other users.

For us, especially point number 1 is interesting. At the moment we want to destroy a cube and all references to it in Application Studio. We have 500+ reports and it was one of the first cubes in our system. So there are thousands references in various reports in ROA formulas, local list definitions,... It is really hard to find all of them, without an automatic support.

Additionally point number 2 would be quite interesting as well. The topic is nearly the same one, it is only, that in Import Master it is easier to find references, as it is possible to search of a string in all scripts. But I don't think it is possible to search within Mappings.

Kind regards,
Michael