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
i have a page that before the session variable was added, would display the text i required if the recordset was empty. Now i have a session variable on the same page and if the recordset is empty, instead of showing the text i need displayed, i get [More]
Hi Friends, I am working on tdsform with codintion IF ZPDATE-LOW >= '20100401'. when we given date as out put Posting Dates                   01.04.2010         to    29.12.2010 Document Type                                      to Bank Challan Numbe [More]
Just got a new imac and my iwork software wont work. I have the serial numbers but after migrating from my old mac running OSX tiger it won't even give me that opportunity. I do not have any discs as this was downloaded. HelpHi, hopefully you guys ca [More]
I try to use this bios-20080424160754.zip downloand from notebook support but when start tell me " this compute is not support " .... same help to upgrade firmware.You will have to execute the BIOS setup with administrator rights. This can be ea [More]
Hai, what is the diff. between Port and Socket and is Port related to Hardware?Or another way, A socket is the connection you make, the port is the channel that the socket connected on. A lot of ports are assigned to a certain use eg 80 = http. So wh [More]
Hello, I have a database whose primarey key is an ID field where the ID is made up letters and numbers such as: 'CB-01' 'CB-02' 'CB-03' I want to select the max ID from the database, add +1 to it and then display that new ID in a text box. The follow [More]
Hello, A strange problem developed on my system recently. Whenever I try to get into the preferences of a program like safari or mail, my system will just freeze for a few seconds and nothing will pop up. It is especially frustrating when i try to up [More]
Hi, I', using Tomcat 557 jdk 1.5.0.0_01, axis 1.2, and i have to build simple web service. The project is a list of students (their name, surname) and it has to do as the following: -adding new student -deleting existing student -changing existing st [More]
Ive found a problem with captivate 2 which causes it to crash (it always crashes on my windows vista systems, but i dont think captivate 2 is compatible with windows vista yet). If i put a check in the box for "automatically add click boxes" und [More]
Hi, All ! plz any body can give me reply how to release the sales order once if we blocked.hi VA14L - Sales Documents Blocked for Delivery V23 - Sales Documents Blocked for Billing V.25 - Release Customer Expected Price VKM3 Credit Block remove V.26 [More]