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
Hi Team,
I am trying to modify standard report 'Unsubmitted or unassigned CC transaction' . I want to calculate how much aged that transaction is (i.e. days between current date and posted date). I applied this condition add added a data item :
_days_between (current_date,[Expense].[Credit Card Transactions].[Posted Date])
This one not getting added in sub queries unsubmitted or unassigned. So I added in main query, it is added without error. But when I am trying to add in in main page its giving an error like below :
Cross joins (between query subjects: Union1, [Credit Card Transaction Tables].[FCT_CCARD_TRANS Posted Dim_Date]) are not permitted for the user who has the identity '*'.
Can you please suggest any solution to this how I can calculate aging of transaction here and add in this report(modified unsubmitted or unassigned cc report).