Sitemap

Amicuk Programming Answers

Effect of Cube Compression on BIA index's

2015-10-11   Views:4

Advertisement

What effect does cube compression have on a BIA index? Also does SAP recommend rebuilding indexes on some periodic basis and also can we automate index deletes and rebuild processes for a specific cube using the standard process chain variants or pro

What effect does cube compression have on a BIA index?
Also does SAP recommend rebuilding indexes on some periodic basis and also can we automate index deletes and rebuild processes for a specific cube using the standard process chain variants or programs?
Thank you

The replay answer
Advertisement
<b>Compression:</b> DB statistics and DB indexes for the InfoCubes are less relevant once you use the BI Accelerator.
In the standard case, you could even completely forgo these processes. But please note the following aspects:
Compression is still necessary for inventory InfoCubes, for InfoCubes with a significant number of cancellation requests (i.e. high compression rate), and for InfoCubes with a high number of partitions in the F-table. Note that compression requires DB statistics and DB indexes (P-index).
DB statistics and DB indexes are not used for reporting on BIA-enabled InfoCubes. However for roll-up and change run, we recommend the P-index (package) on the F-fact table.
Furthermore: up-to-date DB statistics and (some) DB indexes are necessary in the following cases:
a)data mart (for mass data extraction, BIA is not used)
b)real-time InfoProvider (with most-recent queries)
Note also that you need compressed and indexed InfoCubes with up-to-date statistics whenever you switch off the BI accelerator index.
Hope it Helps
Chetan
@CP..

Go to See the other 2 answers

Effect of Cube Compression on BIA index's

Category:DefaultRelease time:2015-10-11Views:130

What effect does cube compression have on a BIA index? Also does SAP recommend rebuilding indexes on some periodic basis and also can we automate index deletes and rebuild processes for a specific cube using the standard process chain variants or pro[More]

Error when creating BIA INDEX FOR CUBE

Category:DefaultRelease time:-0001-11-30Views:130

Hi I am trying to create BIA index for a cube and I am getting error "An error occurred. Choose "Continue" to start again from the beginning"  in the second step. Could any body explain what this error mean and How to correct it. and w[More]

Transport error failure with return code 12 for BIA indexed Cube

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I was trying to transport few cubes from the Dev to the QA system. However, the transport failed repeatedly with return code 12. I noticed that the version of Cubes in the target system had BIA indexes loaded on it.   So, I deleted those index[More]

Prerequisites for an Infocube to crete BIA indexes

Category:DefaultRelease time:-0001-11-30Views:130

Hi experts, I am very new to BIA. I have just loaded some data into a Cube and I want to create and fill BIA indexes. But before that I doubt whether we need to do any must-be-done activities such as roll up or compressing that particular request. Pl[More]

Fact Table index vs BIA Index

Category:DefaultRelease time:2015-10-11Views:130

BIA gurus.. Prior to our BIA implementation we had the drop and rebuild index process variants in our process chains. Now after the BIA implementation we have the BIA index roll-up process variant included in the process chain. Is it still required t[More]

ABAP to set "Switched on/off BIA indexes for queries" flag?

Category:DefaultRelease time:-0001-11-30Views:130

Hi everyone, 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[More]

Delete Full Requests from an InfoCube with a BIA index on it

Category:DefaultRelease time:-0001-11-30Views:130

Hello all I need to delete certain random Full requests from a cube which has both DB indexd and BIA index on it? What will be the steps i should be following in regards to deleting/ rebuilding indexes ? Regards SanjyotThanks Vitaliy but I have multi[More]

BIA Index creation error due to invalid characters

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, While creating BIA index on an Infocube the index creation process fails with the following message. Index for table '/BIC/SSPSEGTXT' is being processed A character set conversion is not possible. Parallel indexing process terminated (Task: '[More]

Error in creating BIA index after SPS upgrade

Category:DefaultRelease time:-0001-11-30Views:130

Hi BIA experts, we got issues in BIA after our BI SPS upgrade (current level SPS18): when wir try to create new BIA index for a cube (normal basic cube), we got error RSD_TREX121 (index type ICB). This issue occurs since we completed SPS18 upgrade. A[More]

Initiate and Fill BIA Index Step Fails in Process Chain

Category:DefaultRelease time:-0001-11-30Views:130

HI!        In our weekend scenario for a cube, we refresh the data in a cube. What we do is, we delete BIA indexes before the data refresh in the cube, load the data, recreate the indexes using "Initialize and Fill BIA" step. Last run the fillin[More]

BIA INdexes : URGENT

Category:DefaultRelease time:-0001-11-30Views:130

Hello I am maintaining the BIA Indexes for my cubes and when i say continue i am getting this error message Restart master index server I got this error message yesterday as well and I did restart the mater index server through the BIA Index Monitor[More]

Hot
Hello! I`ll try to make this quick because I need help asap. I`ve been starting to make YouTube gaming videos 3 weeks ago and my channel is growing up pretty fast. I promised I would make a video everyday but it`s been a full week since I couldn`t up [More]
no matter where I'm at. Why is that? Does the 3g symbol take the place of the bars? I may be fooling myself physchologicaly but it seems a tad faster. Don't really know if it's even working when this happens.If the 3G logo is displayed then the signa [More]
contacted att about the issue, so I figured I would try here again.  When I contacted ATT about it, and the person I talked to claimed that my service was not compatable with the phone.  It is the 50 data package so I don't think that is the issue.  [More]
I am running FireFox 3.6.9, and have upgdated Flashplayer to 10.1 r53 (the latest) I keep getting notified when checking my plugin updates that Flash wants to be updated and is vulnerable with more info message of This Plugin version has a security v [More]
Why has my iPad screen stopped rotating?  I have tried by using the mute button to unlock.  It says it is unlocked. But it won't rotate.1. Make sure the Side Switch is set to Lock Rotation: Settings>General>Use side switch to http://i1224.photobucke [More]
Hi Folks - Another IPS Tech Tip coming up and this time we will be hearing from some past and current Cisco Remote Services members on their best practice suggestions. As always these are about 30 minutes of content and then Q&A - a low cost high rew [More]
hi, when i run an application on a palm(handspring treo) i got this error , and it couldnt even start the interface..There was no problem running it on "sony clie". and the Form at the beggining has only 6 buttons and their listeners.also there [More]
Does anyone know is there meant to be presets with trapcode starglow?  From everything Ive read online the answer is yes but I dont appear to have them. Ive tried refreshing effects and presets and I have animation presets showing in the effect contr [More]
Is there a way to get the 'process id' in LV?Hi codas Basically, you have ways to get prcesses id: 1.- If using Lv 7.x,.NET could be a good choice. See example about task manager and modifie to get ID too. 2. If not ( or if you like), use system exec [More]
I'm reading 3 digit integers back from a controller in the form of XXX. I need to format them to the form XX.X Example 245 should read 24.5, or 345 should read 34.5. Besides the easiest method of just dividing bt 10 is there a labview function that w [More]