Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BIA Index inactive while chagne run was executed - Is BIA in sync with BI

When the change run was executed for infoobject, the BIA Index on the cube was inactive.So there is no mention about the BIA index in the structure change job log (as expected)

Now how do I make sure that the BIA indexes are in sync with the newly loaded data to the infoobject.

Do I have to delete and rebuild the BIA Index for this cube?

Thanks,

Saurabh

replied

Hi Saurabh

Do you mean that BIA Index was deactivated manually before change run or automatically during change run?

The simplest check would be to compare number of records between your InfoObject's db tables and bia physical index. You could do it using RSRV check "Compare data in BI tables and BIA indexes" for your InfoCube. This check compares all records for all tables from your InfoCube star schema, but only for those smaller then 10,000 records. You can change this parameter to up to 100,000 records, but that's it.

So, the easiest would be to compare this number yourself by comparing number between this from SE16 for db table and TREXADMIN for BIA index. As far as I remember in your company only admins have access to TREXADMIN to your BIA, so you would need to work with them on this check.

If you like abaping, you can use f/m TREX_EXT_SEARCH_DOCUMENTS, where for given index I_INDEXES and selection criteria I_QUERY_ENTRIES using flag I_COUNT_ONLY='X' you can get E_INDEX_SIZE

Good luck!

-Vitaliy

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question