Who Me Too'd this topic

Who Me Too'd this topic

Saikat1
Occasional Member - Level 2

Calculating age of CC transactions in cognos report 'Unsubmitted or unassigned CC transaction'

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). 

Who Me Too'd this topic