cancel
Showing results for 
Search instead for 
Did you mean: 
JanAelbrecht
Occasional Member - Level 2

Create accriual report - How to find the sources in teh datawarehouse

Hi,

 

Is there a document that shows were to find the fields as you can't search for them in cognos source

 

I am looking for the fields :

Journal Account Code

Allocation Custom 14

 

regards

Jan

 

2 Solutions
Solution
KevinD
Community Manager
Community Manager

@JanAelbrecht when you login to Cognos, click Launch in the upper right-hand corner. From the drop down list, click Help - Concur Model. This will open a webpage with some resources. At the bottom of this webpage you will see the areas of the Data Warehouse listed, starting with Expense. Go to the right and you'll see Doc-PDF. These are documents containing the data items of the data warehouse. Just do a CTRL + F to Find a keyword. You will find that the data item will be in a table. At the top of the table, you will see the path to take in the data warehouse to find the item. Give this a try.  For Custom 14, you may find that this appears several times in the document. Be sure when you look at each instance you check the path at the top of the table to make sure it is from Allocations. 

 

Let me know if you have any questions.


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

Solution
JanAelbrecht
Occasional Member - Level 2

Hi Kevin,

 

Thanks, this helps a lot.

 

regards

Jan

View solution in original post

2 REPLIES 2
Solution
KevinD
Community Manager
Community Manager

@JanAelbrecht when you login to Cognos, click Launch in the upper right-hand corner. From the drop down list, click Help - Concur Model. This will open a webpage with some resources. At the bottom of this webpage you will see the areas of the Data Warehouse listed, starting with Expense. Go to the right and you'll see Doc-PDF. These are documents containing the data items of the data warehouse. Just do a CTRL + F to Find a keyword. You will find that the data item will be in a table. At the top of the table, you will see the path to take in the data warehouse to find the item. Give this a try.  For Custom 14, you may find that this appears several times in the document. Be sure when you look at each instance you check the path at the top of the table to make sure it is from Allocations. 

 

Let me know if you have any questions.


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.
Solution
JanAelbrecht
Occasional Member - Level 2

Hi Kevin,

 

Thanks, this helps a lot.

 

regards

Jan