ABAP to set "Switched on/off BIA indexes for queries" flag?
Does anyone know if the "Switch on/off BIA Indexes for Queries" can be set for a specific cube by a delivered ABAP?
Here's my scenario. We go live with BIA next Monday 9/22. I've indexed our cubes in production BIA this past weekend and they're rolled up nightly. Until the go-live, I've manually set the "Switched Off for Queries" flag via RSDDBIAMON > BI Accelerator > Index Settings > Switch on/off BIA Indexes for Queries".
However, one indexed cube is deleted fully every night by the flag in the full load infopackage. In testing, I saw that the BIA fact table index was fully deleted when the E and F tables of the cube were truncated, and then reindexed when the full package is loaded and rolled up. This is all ok.
The issue is that after the delete, load and rollup, the "Switched Off for Queries" flag is not set. I have had to manually reset to off in the morning. This won't be an issue (hopefully) once we go live, but it does seem like a bug and I'll likely submit a customer message. I would think the delete, index and rollup process should not change the status of this flag.
Does anyone know if that flag can be programatically set?
Thanks for any advice,
Witalij Rudnicki replied
The setting is stored in the table RSDDTREXDIR field OBJSTAT (ACT or INA).
There is no funciton module, but (welcome to OO world! method SET_OBJSTAT of the class CL_RSDDTREX_AGGREGATE.
I believe that what happens is that processing for the cube overwrites the setting done manually, because it changes status ACT->INA at the beginning (which is already set manually), and then back INA->ACT at the end (overwriting manual setting). That's my assumption.
Good luck with go live!
Edited by: Vitaliy on Sep 18, 2008 4:14 PM