Please use this tool as a reference before submitting a case to concur as these questions reflect many of the mostcommon questions that. Cognos 8 bis capabilities include reporting, analysis, dashboarding and scorecards, delivered through a webbased serviceoriented architecture. Weve spent 10 years developing 100s of reports in cognos. The basic difference between ibm cognos and other reporting solutions vendors is a possibility of using different reporting styles. Hello, im trying to create a new report in concur cognosanalysis to capture all the changes made to the different employee profiles, when they. Attendee details is stored in different table within concur warehouse however i do not see any primary key to be used as a join. Our drivers make integration a snap, providing an easytouse databaselike interface to concur data including attendees, entries, lists, items, and more. If your company uses intelligence and if you have a cognos role cognos consumer. Goodman masson hiring concur application analyst in london. This video demonstrates how to create a simple report with ibm cognos analytics. I am using cognos report studio to create a report with the following details, report id, employee id, name, approval status, amounts and the attendee details name and title. Discover how hightech giant ibm embraced sap concur solutions for its new, cloudbased travel and expense platform to track more than 400,000 users worldwide and provide them with the flexibility to manage expenses anytime, anywhere.
Attendee details is stored in different table within concur. With cognos analytics on cloud you can purchase any number of standard, plus and premium seats. The engaging experience provided by cognos analytics encourages business users to make andor configure dashboards and reports on their own while providing it with a proven and scalable platform that can be deployed either on premises or in cloud. I am building a report in cognos report studio which is to be extracted to a csv format. Browsers compatible with cognos analytics knowledgebase. Sap concur delivers security and confidence to include iso, pci dss, sarbanes oxley, fisma, fips 1402, and 508 compliance. Unearth hidden insights and act to remove bias from your data.
The software and accompanying materials are provided with restricted rights. You make the report interactive by adding a prompt. I am working with concurs ibm cognos integrated solution. Add the sap concur expense entries create expense entry. Improve visibility and find costsavings with sap concurs business intelligence tools. Curious on how the burstingid field was used in the employee import template we are investigating setting this up so we can burst reports to all users so they can see specfic report information for themselves rather then our ap team manually running these reports. You create a chart report in report studio to show the performance of returns over the last few years. Cognos is the leading strategic supplier of enterprise business intelligence solutions and the first company to announce the sale of one million seats of business intelligence software. As a senior concur functional analyst within a project team, this role involves configuring software to ensure the procure to pay processes are working efficiently. Intelligence gives you visibility into your company spend by consolidating travel, expense, invoice, and credit card data. Integrate with sap concur using ibm app connect ibm. Browsers treat excel report formats and pdf if it opens outside the browser as popups.
Cognos report studio concur reporting multiple rows into one. Concur intelligence is a business intelligence solution for expense, travel and invoice management. Define and build a series of reports within concur cognos to provide users, superuser and administrators the visibility and insight into purchase requisitions and invoices. Hays hiring senior concur analyst in london, england. One of the fields that is on the report stems from a free form text field in concur. In this role you will work closely with end users within finance and undertake hands on application configuration to ensure the concur. Intelligence and reporting from sap concur youtube. For more information on these and other useful reports, visit. However, ibm cognos is not well suited when being implemented with nondeltek software as this will lead to. The magnitude gateway concur adapter enables streamlined analytics and reporting on concur data. I am tasked with building reports using sap concur s implementation of ibm cognos report studio v10. You will create a report that looks like the report. But the concur system doesnt have sufficient flexibility of variables to allow for the generation of the complex account code system we use because of these conflicting reporting needs. Concurs consultative intelligence and analytics reporting services blend the indepth knowledge of your internal team, with the perspective of an outside expert, to help you better understand your travel, expense and invoice data.
When getting started with concur reporting, reference our recommended reports. Relational and dimensional reporting styles you can create reports in ibm cognos report studio using either a relational reporting style or a dimensional reporting style. You can use the cdata odbc driver for sap concur to integrate sap concur data with the draganddrop style of cognos report studio. We deliver the data and tools you need, to control spendingeven. Its like using impromptu or oracle reports or crystal reports or ireport. Concur has teamed with cognos to provide the best analytical and ad hoc reporting. Reporting uses the native microsoft internet explorer xml support, which is a component of the browser. The data i am working with is travel expense report data.
A community to help grow your business, find support and connect with sap users and peers. First stop on the journey is to ensure you have all the essentials in place. It contains business travel expense information including the travel itineraries, which are the main source of this report. I would rather have both as its now more difficult to get data out now. Ibm cognos is a set of smart selfservice capabilities that enable them to quickly and confidently determine and make decisions on insight. Im trying to create a new report in concur cognos analysis to capture all the changes made to the different employee profiles, when they were changed, and by whom.
Drive better business performance using the right data at the right time. Activex support must be enabled because microsoft implements xml using activex. Frequently asked questions concur travel and expense, concur. Our company is in the process of implementing cognos and the it project managers are issuing licences to other depts. How to pull expenses submitted by a particular vp organization employees report in concur cognos. See the right data so you can increase transparency and control your corporate spend.
You can use the cdata odbc driver for sap concur to integrate sap concur data with the draganddrop style of cognos report. The cognos 8 bi suite, which was first introduced in 2005, is ibms leading performance management software. Concur reporting training for travel and expense iprocon. Concur travel and expense vs ibm cognos trustradius. Aug 25, 2015 see how easily and quickly your employees can create and manage their expense reports using concur. Oct 24, 2012 previously the reporting tool was embedded in concur. Concur has teamed with cognos to provide the best analytical and ad hoc reporting solutions in the industry. This request will return a formfieldslist parent element with a formfield parent element for each configured form field. Concur expense is timesaving, costsaving expense report software. It takes another level of sophistication to be able to use. Accessing reporting in concur university of cincinnati.
Previously the reporting tool was embedded in concur. Bachelors degree in business, finance and accounting related field. Preferred knowledge of concur s expenseit pro mobile application and cognos intelligence reporting desired. November 2009 this document provides answers to the frequently asked questions received by concur s client support team. Concur contains a robust reporting function based on the cognos software. Authorization header with oauth token for valid sap concur user. Concur cognos is used to obtain information from concur by either running reports ondemand, or accessing customized reports that have been created by uc. See how your employees spend their travel and expense budgets. Access sap concur data from reporting tools, databases, and custom applications. Use vendor normalization to eliminate credit card data duplication and match every transaction to the relevant vendor so you can see exactly whats being spent with each airline, hotel.
In the new version, they are using a cognos data warehouse which is separately. See how easily and quickly your employees can create and manage their expense reports using concur. Add the sap concur reports retrieve reports action, which will retrieve additional information thats required for creating an expense entry. It also allows you to extract and share reports in. Concurs reporting uses ibms cognos reporting solution, a webbased tool that allows you to create queries, reports, and dashboards that can be run and. What our clients say we have been a client of neosystems since 2008, and i can say without reservation, i would highly recommend neosystems for managed accounting services.
Concur offers extensive reporting via the cognos based tools intelligence and. I thought this would be under the audit trail change log data section for expense, but when i run the report the information only pulls through june 4th, 2017. Subject cognos l professional vs business author level. Concur s reporting uses ibm s cognos reporting solution, a webbased tool that allows you to create queries, reports, and dashboards that can be run and viewed on desktops and mobile devices. Sap concur drivers sap concur connectors cdata software. Concur cognos report studio create report of travel. I thought this would be under the audit trail change log data section for expense, but when i run the report. Upload receipts, right to expense reports we make it easy to capture business travel expenses so you can reduce the amount of time. So if anyone ever comes out with an expense reporting software that takes those unique needs into account, i will jump in a second. This is cognos training video for both beginners and advanced learners that covers cognos desktop, tm1, architecture, dashboard and handson training in designing cognos reports.
Software product compatibility report for cognos analytics 11. Ibm cognos is well suited when you are implementing with compatible software like costpoint and other deltek products, this will lead to great integration and result in the wonderful presentation of data for your reporting requirement. However, ibm cognos is not well suited when being implemented with nondeltek software. Reporting licenses are distributed to financial managers and can be delegated to others by assigning the permission in the concur profile under adding delegates. That means the data model is defined by the concur people. Cognos analytics is a business intelligence solution that empowers users with aiinfused selfservice capabilities that accelerate data preparation, analysis, and report creation. Access sap concur like you would a database read, write, and update through a standard odbc driver interface. Has anyone utilized the burst reporting functionality within the cognos suite. Curious on how the burstingid field was used in the employee import template we are investigating setting this up so we can burst reports to all users so they can see specfic report information for themselves rather then our ap team manually running these reports and carving out the specifc user details to send. Create data visualizations in cognos bi with sap concur data access sap concur data as an odbc data source in cognos business intelligence and create data visualizations in cognos report studio. In the new version, they are using a cognos data warehouse which is separately accessed. Report studio 23 planning reports 23 working in report studio 23 the user interface 23 basic report structure 25 working with objects 27 set options 28 creating a report 29 specify the package 29 choose a report template 30 add data to a report 31 working with dimensional data 31 save a report 33 run a report 33 print a report. Concur travel and expense, concur invoice and concur cliqbook last revised. With a preconfigured bolton reporting business intelligence solution using powerplay and impromptu, concurs customers can access detailed analytical reporting.
Is sap concur the right expense report solution for your business. My goal for this report is to have a prompt page that allows the user to select the timeframe from which the report. Any approver in concur has been granted access to reporting. Uncover potential savings, and deliver valuable information via customized reports. Get opinions from real users about sap concur with capterra. For more information or a live demo on concur, contact us at iprocon on. Get ready for takeoff, your travel and expense software is about to have a new companion sap analytics cloud. The user interface the ibm cognos report studio user interface has two panes, an explorer bar, and a work area to help you create reports. Its come out that many departments across the organization have their own reporting preferences, therefore to agree them all the best would be a one tool offering many styles rather than many tools with one style. Gyansys assisted with software billofmaterials evaluation and roadmap. The sap concur odbc driver is a powerful tool that allows you to connect with live sap concur document databases, directly from any applications that support odbc connectivity.
Is daunting to think of starting from scratch, especially with no information on capabilities. Gain realtime, actionable insights into your concur travel, expense and invoice data. Gain realtime, actionable insights into your concur travel. How to create a report basic in ibm cognos analytics. Business intelligence bi reporting and analytics reporting tool. Cognos tutorial for beginners1 cognos training for. Create data visualizations in cognos bi with sap concur data. Intelligence lets you see a complete picture of your company spend by consolidating travel, expense, invoice, erp and credit card data. Use, duplication, or disclosure by the government is subject to the restrictions in subparagraph c1ii of the rights in technical data and comp uter software.
814 938 778 622 1337 974 1311 372 738 1379 250 505 1380 116 258 651 796 1439 971 616 835 1249 115 874 1311 1355 819 259 1466 1090 829 1484 1020 1191 820 135 642 1218 551 599