How to add email address on intelligence report

[Bhullar916]

Hello, I am trying to add email address field on a report that pulls list of active employees reimbursed and don't have bank accounts in Concur. I added above referenced field and execute the report and it throwing following error;

Cross joins (between query subjects: Final, Employee Reimbursements, [Report Tables].[FCT_REPORT Dim_Employee]) are not permitted for the user who has the identity '*'.

[MelanieT]

@Bhullar916 Hi!  Here are steps to schedule a Cognos report:

To schedule a Cognos report :

1. Login to Concur Travel & Expense
2. Reporting > Intelligence
3. Copy Standard/Custom report to My Folders or the company folder
4. Under Actions column select Scheduling Icon
5. Select the Start Date
6. Select No end date
7. Select Frequency
8. Use my credentials under Credentials
9. Check Override the default values under Options
10. Select report format
11. Check Send the report by email
12. Edit the options
13. Enter email address
14. check Attach the report
15. Click OK
16. Click OK

Remember to tag me if you respond or feel free to mark this post as Solved if you don't have further questions or comments. To tag me on your response, you click the Reply button, first thing to type is @. This should bring up the username of the person you are replying to.

[KevinD]

@Bhullar916 the message about cross joins means you are pulling data items from two different areas of the data warehouse. Could you tell me the data items you have on your report and what folders you pulled them from please?

Also, you may have noticed your signature no longer appears. As the site moderator, I removed it since it contained too much personal information. This community is public and can be seen by anyone, so we do not recommend posting any personal information. I've sent you a private message with your signature and the formatting, that way if you want to change it, but not have to worry about the HTML, you can just update the text between the HTML.

[BOARTA_MADALINA]

Hello, we are looking to bring all taxi expenses with the employee email address

[KevinD]

@BOARTA_MADALINA I don't mean this to sound flippant, but why do you want this? It is a bit of an odd combination of data items. 

Can you tell me the purpose of needing email addresses for taxi expenses and not for all expenses, please?

[BOARTA_MADALINA]

Hello,

i want to bring all taxi expenses to see all vendors used by employees. there are cases when employees use apps to request a taxi and we need to see the email address they used for those apps

thank you,

Madalina

[Karthikhemadri]

@BOARTA_MADALINA try to add the Email Address data item from Additional Employee Details under Report Header Information but not from the any other folder like Entry or Lists which might giving you the cross joins error.

Expression: [Expense].[Report Header Information].[Employee E-mail Address]

if you still getting the same error then the issue is not with email address rather with different field. so follow the steps below to enable cross jions.

1. open the Cognos Report

2. go to Report and Queries

3. Select the Query1, you get to see the properties of the query toward the right. if not click on show properties right side corner.

4. Set Cross Product Allowed  settings to Allow

Repeat the same for all queries and try to run the report.

If this answers your query, then please mark solution as accepted.

[BOARTA_MADALINA]

Hello, thank you for the solution! much appreciated!

Unfortunately, this will bring only the company employee email address, and not the one used when requesting taxi using an app (eg uber).

if Uber is integrated and the expenses appear in the employee profile, what keys could be used to see the email address they used when requesting taxi? - the personal email address or the company address.

Thank you!

Madalina

[Karthikhemadri]

@BOARTA_MADALINA  you need to rely on  multiple fields. lets say you need a report for Taxi expenses and see what is vendor mostly used for claiming Taxi. 

First question is, do you have the Vendor field in your entry form to capture for Taxi. If yes, ass fields like Employee, Employee ID, Report Name, Report ID, Report Number, Approval Status, Payment Status, Entry Key, Transaction Date, Expense Type, Vendor, Transaction Currency, Expense Amount in Transaction Currency.

Then place your filter on Expense Type to get only Taxi details and other filter if you would like to place for Approval Status or Payment Status. 

this way you get only employees who claimed their Taxi expenses. I'm not sure if we can create a Cognos report to get only expenses created through Uber App integration.