cancel
Showing results for 
Search instead for 
Did you mean: 
tombr
New Member - Level 1

User profile details - creation, termination and "by whom"

Hello,

 

I'm trying to create a custom report which would show the following informtion for any user account:

- date when the account was created

- date when account was terminated (if applicable)

- who created the account.

 

Can anybody advise which data fields should I insert into the custom report to obtain this information? 

Thank you

Tom

1 Solution
Solution
KevinD
Community Manager
Community Manager

I did a quick look in Cognos and was able to find the Start date and Termination date items. I did not see a data item showing who created the account. 


You can find these items here: Expense>Lists>Employee Information>Additional Details.

 

I hope this helps. 

 

Kevin


Thank you,
Kevin Dorsey
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.

View solution in original post

5 REPLIES 5
Solution
KevinD
Community Manager
Community Manager

I did a quick look in Cognos and was able to find the Start date and Termination date items. I did not see a data item showing who created the account. 


You can find these items here: Expense>Lists>Employee Information>Additional Details.

 

I hope this helps. 

 

Kevin


Thank you,
Kevin Dorsey
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.
Adriana
Occasional Member - Level 3

You cannot add who created/terminated the account because this is not visible in Employee profile in Concur. 

 

My question...if I add start/end date what could be the reason for which these fields remain blank. Even though I have employees whi have been terminated and most definitely I should see when the employees have been created.  

 

Many thanks!

JLovasz
Occasional Member - Level 2

I am trying to run an employee listing, but I need to see all employees who were active for the past three years.  I thought I could filter out those with an Account Termination Date prior to three years ago, but when I pull the Termination Date filed into my report it is blank.  Even when I add the Active field and it clearly shows a "N".  What are my other options?  What am I missing?

Thanks in advance for your help with this!

viv_prabha
Occasional Member - Level 1

Hi Kevin,

 

I have similar problem. I followed the suggested steps to get the Start date and Termination date but when i run the report i did not get the value in these fields. These fields are completely blank. Could you please suggest how to get value of employee account activation date and termination date in Cognos report. 

 

Regards

Vivek 

KevinD
Community Manager
Community Manager

@viv_prabha can you please provide me the name of the company you work for? I would like to look at your site and permissions for Cognos. If you do not want to post your company name privately, send me a private message. To send a private message, click on my username. Select View Profile. You will see an option to send a message. 


Thank you,
Kevin Dorsey
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.