This Documents explains you how we can trouble shoot some of the BIA related issue, I tried to cover most of the issues which usually occurs in BIA.
BI Accelerator – Checks –
•RSDDV Transaction – You can check all available BIA index and Aggregates
BI Accelerator – Issues –
•In case you want to check whether BIA server index is giving the data issue or DB level data issue.
RSRT Transaction – Execute + Debug option
We can see BIA server option
•BI query is taking longer time than expected – You can check in transaction RSDDBIAMON
•Any Info cube BIA index gets deleted automatically – You can delete and recreate the Index and if it is still doesn’t work you have to restart the BIA server through RSDDBIAMON transaction as shown below. Basis normally perform this activity every weekend.
•Once restart is complete you can recreate the BIA index as shown in the next slide.
•To delete and recreate the BIA index post BIA server restart.
•Right click on cube and maintain BIA index will take you to screen shown here. You can delete and by continue option and then it will show recreate option.
•BIA Index properties will show you whether BIA index is active or not and time stamp when it is created.