This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
- Mute
- Subscribe
- Bookmark
- Report Inappropriate Content
How to add email address on intelligence report
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 '*'.
- Labels:
-
Reporting
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
- Mute
- Subscribe
- Bookmark
- Report Inappropriate Content
@Bhullar916 Hi! Here are steps to schedule a Cognos report:
To schedule a Cognos report :
- Login to Concur Travel & Expense
- Reporting > Intelligence
- Copy Standard/Custom report to My Folders or the company folder
- Under Actions column select Scheduling Icon
- Select the Start Date
- Select No end date
- Select Frequency
- Use my credentials under Credentials
- Check Override the default values under Options
- Select report format
- Check Send the report by email
- Edit the options
- Enter email address
- check Attach the report
- Click OK
- 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.
Thank you,
Melanie Taufen
SAP Concur Community Moderator
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.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
- Mute
- Subscribe
- Bookmark
- Report Inappropriate Content
@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.
Thank you,
Kevin
SAP Concur Community Manager
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.