Hi,
Does someone know how i can get the used definitions from different reports in cognos 10
gr.
bart
Quote from: bartburg on 15 Apr 2014 08:39:14 AM
Hi,
Does someone know how i can get the used definitions from different reports in cognos 10
gr.
bart
Hi,
I'm not really sure what you are asking for here? Are you referring to the report XML specifications?
If so, open a report in Report Studio, select Tools > copy report to clipboard
Cheers!
MF.
tnx for the anwser
i will try to explain a bit more maybe the question becomes more clear.
i have 100+ reports for instance
for 10 reports i use table user.table to collect users now my database is changing and i need to use
user1.table to collect the users
what i would like is to make a report that shows me where i used user.table in wich report!
so u can say i want to search in the sql statement that cognos report generates.
i hope this explains it a bit more
This may help
http://pic.dhe.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_fm.10.1.1.doc%2Ft_find_report_dependencies.html
I'm also trying to find something similar but most of the reports that are in use, use relational data and the SQL is in each report rather than using packages.
Trying to find out if there is a way to search for tables in the SQL without having to go into each individual report and check if the table is used.
Update:
Ok, if I'd just taken 2minutes to look. I've found the easiest way is to export all reports and then use the XML file and do a full text search. This has yielded the results I need.
It can be done in SDK. I have a java application that can seek out any object in the content store. It's home-built, skeletal code that I created mostly to repoint drill throughs without losing the parameter mapping. In spite of having built this application, I still end up using using Notepad++ for 90% of my 'scriptable' changes.
Some things are just easier when they are less complicated. What's wrong with brute force? Everyone always wants to finesse.