cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Occasional Member - Level 2

Cognos Report - Adding attendee to the report

Hello All,

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). Attendee details is stored in different table within Concur Warehouse however I do not see any primary key to be used as a Join. Without Join while creating the report, Cognos is automatically applying cross join and creating duplicate records. For Example, if my expense report has one attendee, Cognos is creating two records one with attendee name in it, one without. I am really not able to understand how to create a report without duplicate entries.

Any help will be appreciated.

Thank You

 

1 Solution

Accepted Solutions
Highlighted
Solution
SAP Concur Employee
SAP Concur Employee

Re: Cognos Report - Adding attendee to the report

@mamehta There are two solutions to this:

1. Create a repeater table report. I'm not sure how to do this, but I've seen people on our Reporting team do it. 

2. Create a Master/Detail report. This one to me is much easier. 

 

Have you attended our free Intelligence reporting training? One of the examples we go over is building a report with attendees. You can't beat the price of this class, right? 

 

The class also provides a good foundation of using our reporting tools. You can find a list of our upcoming Intelligence Webinars here: https://www.concurtraining.com/pr/reporting/intelligence.

 

Now, I know you might be saying, "I don't want to wait a couple weeks to know how to do this", which it totally understandable. 

 

You can download our training manual and go to page 174 to see the example and the steps of how to create such a report. 

 

The manual is found here using the link I provided above under the Download the Manuals section. 

 

Kevin


Thanks,
Kevin Dorsey
SAP Concur Sr. Training Consultant

Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.

View solution in original post

1 Reply
Highlighted
Solution
SAP Concur Employee
SAP Concur Employee

Re: Cognos Report - Adding attendee to the report

@mamehta There are two solutions to this:

1. Create a repeater table report. I'm not sure how to do this, but I've seen people on our Reporting team do it. 

2. Create a Master/Detail report. This one to me is much easier. 

 

Have you attended our free Intelligence reporting training? One of the examples we go over is building a report with attendees. You can't beat the price of this class, right? 

 

The class also provides a good foundation of using our reporting tools. You can find a list of our upcoming Intelligence Webinars here: https://www.concurtraining.com/pr/reporting/intelligence.

 

Now, I know you might be saying, "I don't want to wait a couple weeks to know how to do this", which it totally understandable. 

 

You can download our training manual and go to page 174 to see the example and the steps of how to create such a report. 

 

The manual is found here using the link I provided above under the Download the Manuals section. 

 

Kevin


Thanks,
Kevin Dorsey
SAP Concur Sr. Training Consultant

Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.

View solution in original post