Hi All,
We are facing an issue wherein if the BIA index of a reporting cube is built the data for a particular evaluation date in not visible on report in portal. Whereas we can view the expected data in RSRT by switching off the BIA and Cache.
We tried doing the below :
1. Deleting Query cache using RSRCACHE on all application servers.
2. Switching off the BIA for that particular query using program "ZRBI_QUERY_BIA_SWITCH" , but still it did not work.
3. We tried doing RSRV checks of BI Accelarator consistency checks for master and transactional data,nothing substantial was found.
Kindly suggest if anyone has faced similar issue and steps to resolve it.
Hi,
Yes by following the instructions from Knowledge Base Articles (KBAs) below:
1789331Analyse and correct wrong data returned by query when BWA is used 2056505How to proceed in case of "wrong/no data with BWA"-problems2204696How to identify inconsistent BWA-indexes in the BW query-result [VIDEO]Thanks,
Diego Seben.
Add a comment