cancel
Showing results for 
Search instead for 
Did you mean: 

Can we add a cube to BIA if the requests are deleted daily

Former Member
0 Kudos

Hello gurus,

We are facing a question with what cubes should be the candidates for BIA.

We have few infocubes where the data is loaded for the current period daily and the previous request is deleted. This is how this cube handles the delta. Can we add this type of a cube to BIA without having to re-index the whole cube every day?

Most forums and experts say we need to re-index the cube once you delete data out of the cube selectively. Is this procedure considered selective deletion and does it not work like a regular delta and if we roll up BIA after the load, does the BIA automatically load the delta indexes?

Please let me know your views on this.

Thanks in advance.

Raju Kosuru

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

HI Nagaraju,

You can add a cube to BIA even if the data is getting deleted or overlapping request deletion happens every day.

But if the data volume large you can do a roll up every day and a index filling on weekends since filling of indexes will take more time. This can be automatically done in process chains using decision step that does a roll up on a week day and filling of index on a weekends.

Note: filling of index step in process chain takes care of both deletion and creation of indexes.

Hope this helps.

Thanks,

Seetharaman

Former Member
0 Kudos

Hi ,

Yes, you can do the rollup and it will take care of filling the indexes.

We have a similar scenario, where we are using "Delete Overlapping Request " for Budget and Target Data for few cubes. We have indexed the cubes and use rollup to fill the BWA Indexes in our daily process chains.So , i would suggest you that there is no harm in this process.

But over the time , depending on the data volume, you need to delete unused BWA index data as a part of maintainance activities.

And as you mentioned in your case, you have few cubes , it would be best if you automate the process of deleting,creating and filling the BWA indexes of the cubes using a process chain that can be scheduled to run on a weekly/required frequency depending on the data volume.This will save a lot of manual effort.

For steps on the same, please see my response on the below thread:

-Vikram

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Hi Raju,

When you delete request from the InfoCube, then it is deleted only from DB table, but only marked as deleted in BWA Index. I.e. the query results are fine no matter if you run with or without BWA, but BWA stores unused data. The only way today to get rid of this data in BWA is to rebuild the BWA Index for that InfoCube.

So, if you have load with deletion of overlapping request, then you can index this InfoCube in BWA, but you do need to rebuild the BWA index from time to time. The good news - you do not need to do it daily, as you mentioned, but rather weekly or monthly - depending on the volume.

Regards,

-Vitaliy

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

I should have mentioned that this "full load" is considered to be "delta load" from BWA perspective, so Roll-Up will still work.

Cheers,

-Vitaliy