Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
Hi All,
Good Day To You..
I want to generate reports in Windchill as per Product wise, year wise etc.
I've installed business reporting for 10.2 M030 and could able to open Cognos in browser.
I'm struggling for generating reports as doing this for first time.
Need steps to perform this task.
Thanks In Advance
Regards
Krishna Chaithanya.
Solved! Go to Solution.
Any working Windchill User ID will work fine for cognos admin user.
The value used for the wt.cognos.namespace property must match the Namespace ID value in the Cognos Configuration tool, which by default is AdministrativeLDAP. If you have changed the Namespace ID value, then you must use that new value for the wt.cognos.namespace property.
It is worth reading through - http://support.ptc.com/cs/help/windchill_hc/wc102_hc/index.jspx?id=WCInstall_WCBusinessReportPostInstall&action=show
Thanks
Binesh Kumar
Barry Wehmiller
Windchill OOTB Cognos reports are available in Context > Reports. If it is a product, Product > Reports. When you have Cognos installed, the reports will run on Cognos in the backend and display the results. If you don't have Cognos, then basic HTML page will get displayed.
If you want to create custom report, Report Management Utility is place where you create reports - http://www.ptc.com/cs/help/windchill_hc/wc102_hc/index.jspx?id=QBReportMgrAbout&action=show . There are a lot of existing reports shared by the user community You can download and import the reports to your system.
If you want to create reports and run it through Cognos from Windchill. Follow - https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS148905
Thanks
Binesh Kumar
Hi Binesh,
Thanks For Your Response
Actually, I want to create a report and run it through Cognos from Windchill.
As you mentioned, I've created a sample report through Windchill site -> Utilities->Report Management and exported it as QML on my desktop.
Opened Cognos through URL and launched report studio but there I'm unable to find any import option to import already exported QML.
Please suggest me for this.
Thanks And Regards
Krishna Chaithanya
Hi,
As you mention it is 10.2 M030. you have to update the WBR fix patch. the run the following commands to load the reports.
run into shell
1. windchill com.ptc.windchill.enterprise.report.ReportHelper modelupdate
2. windchill com.ptc.windchill.cognos.CognosProxy loadreports <WindchillHome>\loadFiles\cognosReports\pdml
3. windchill com.ptc.windchill.cognos.CognosProxy loadreports <WindchillHome>\loadFiles\cognosReports\wnc
4. ant -f <Windchillhome>/installer/wnc/wbr_actions.xml
5. Clear the windchill and browser cache --> Restart the windchill
Regards
Lavish Sharma
After creating report/QML you have to run below command so that your QML will be available in Congons > Report studio > Importable objects tab (in source)
windchill com.ptc.windchill.enterprise.report.ReportHelper modelupdate
once your report is available in congos then Use the Toolbox tab to add a varietyof objects to the report i.e. Image, Tables , Hyperlinks.etc…
Hope it helps!!!
Thanks
Shreyas
Hi Shreyas,
The above mentioned command is resulting error.
Look for detailed error in Method Server and cogserver.log
From my notes -
Review the bellow in wt and db.properties. We should ensure that the username and password for cognos admin is right as well
Thanks
Binesh Kumar
Barry Wehmiller
Actually I've given Windchill admin password when it prompts as I'm not getting Cognos admin password(I've lost it)
Also Ive noticed from db.properties that wt.cognos.namespace is set to Windchill , but the actual ldap properties are seems to be different. Please check below screen shots.
Any working Windchill User ID will work fine for cognos admin user.
The value used for the wt.cognos.namespace property must match the Namespace ID value in the Cognos Configuration tool, which by default is AdministrativeLDAP. If you have changed the Namespace ID value, then you must use that new value for the wt.cognos.namespace property.
It is worth reading through - http://support.ptc.com/cs/help/windchill_hc/wc102_hc/index.jspx?id=WCInstall_WCBusinessReportPostInstall&action=show
Thanks
Binesh Kumar
Barry Wehmiller
Hi All,
I'm now able to generate reports in Cognos.
I've run above mentioned activities in Windchill and did some changes in site.xconf and finally achieved it.
Thanks to all of you for quick response and suggestions which really helped alot
Regards
Krishna Chaithanya
Hi Krishna,
Can you mark the appropriate answer as correct,to help others in the community.
Regards,
Bhushan