Hyperion Performance Suite 8.5 - Finding All BQYS that Use a Certain Table
My client is using Hyperion Performance Suite 8.5 (Yes. Still... But upgrading in another 6 months) and using Hyperion Intelligence 8.5 to develop reports. There is a need to find all the reports (BQY files) that use a certain table in their query sections. Is there a way to do it? Any tool available? There are 600 BQY files and it would be nice if there is a way to search it through a utility or a script or in the repository table?
After finding these reports the data models need to be changed using new tables.
Any help or tips will be greatly appreciated.