I am looking to write a query to find out how many users have reports where they have saved the parameters. Unfortunately, the tech ref manual is a bit vague on this and I do not have the time to go digging. So if anyone has the information it would be greatly appreciated.
Thanks!
select * from cmn_attribute_value_sets where name = 'SavedParamName'
Other tables that you can use are -- cmn_attribute_values, cmn_attributes,cmn_business_objects