I wanted to know if anyone has experience related to following scenario; I have recently joined a group of companies as BI Manager; we have 8 different companies with diversified business and process as well all companies are running SAP with different SCOA. As per my knowledge of BI and Qlikview i can consolidate the data at the BI layer in data modelling. But SAP consultants are recommending to install BPC module (Business Planning and Consolidation) on top of all the 8 SAP than use any BI tool.
My question is what is the right or lets say recommended method based on experience. If option 2 that is implementation of BPC than can Qlikview will connect on BPC effectively?