Consolidation of sage intelligence

Dear Support, 

Kindly assist with an article to create sage consolidation report. I have tried the system help, followed the procedures but still I seem to be missing something.