Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What do the ‘Consolidation’ entries represent whenever I run a query in the Data Warehouse (DW)?

April 26, 2017Data dw entries query run warehouse

0

0 Posted

What do the ‘Consolidation’ entries represent whenever I run a query in the Data Warehouse (DW)?

1 Answer

0

0 Posted

If you run a query in DW and either do not specify the set of books or include the Global Consolidated set of books, you are going to see the monthly consolidation entries. Consolidation is a process that Financial Reporting runs each month to post the monthly account balances from each set of books (Carnegie Mellon, Qatar, and Australia) to the global consolidated set of books. The consolidation entries are reporting only entries. To query on individual journal transactions, you need to run DW queries in the individual set of books.