@AbhishekC1725 aggregated properties, page/pagelist and pagegroup will be stored in blob as it will not be having dedicated columns in DB. We can expose page property and create index table for page list/group for creating report definition using those properties in pega(way of optimizing aggregated properties in pega).

But if the aggregated data is exponential (huge) and customer already has a dedicated team to manage DB and reporting using there own reporting tool, then they would want us to just move data from pega blob to there DB periodically, rest of the things they will take care. This is where BIX comes into picture.