Hi,
What is the actual use of BIX in Pega? I think it is not only for reporting purpose, can someone give some real-time usecases of BIX.
Thanks.
@AbhishekC1725 The main purpose to is extract the work case blob column data into the flat table so that it can used for reporting.
@gasharma So for reporting we need to use other reporting tools like Power BI and Tableau? Why cannot we use the report definition rules and report browser for reporting purposes?
@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.
@Anoop Krishna Thanks for clear explanation.