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
First my Macbook is almost 5 yrs old and is probably on it's last leg.  The other day it froze and was making some pretty loud clicking noises.  I turned it off by holding down the power button and tried starting it up again.  At that point the scree [More]
How to generate nested xml/ complex xml in Oracle 8i using 8i packages dbms_xmlquery or xmlgen . The xml might be looked like this.. if any body have idea then pls let me know. i am trying to write Stored procedure on that i am using query like selec [More]
why i cannot drag and drop any file when using safari , and what happens the file auotmatically open while i need to upload it only , extra for that , i cannot write  any remark or fill a space while using website related to my work. my work is to up [More]
I have a number of sites eg itv.com and want to download the itv player. When I click to download the app from the website, apple apps open but instead of the install window,I just get an empty white box and it hangs, I have tried leaving for hours b [More]
I'm using CR 11 Release 2 I created a report pointing to a SQL stored procedure in our 'development' database (called development).  I now want to change the report to point to the identically named stored procedure in our 'Production' database.  I t [More]
hi experts presently the data is available in sql server(legacy system).so we have to extract data from sql server to bw server through DBconnect.tell me the procedure for how to connect sql server to BW server through DB connect.hi Suresh, there is [More]
Hi, I have a requirement in travel management where when manager rejects a trip or if there is no response from manager , then the status of trip will be changed to " not modifiable". I want to change the status to open . Any body could help me [More]
I am going to order the X301, with 128 SSD, DVD-R/W, XP, and Verizon WWAN. Plus I am adding the USB Dock. Sometimes too much research can be a bad thing. I am now having second thoughts that the system will run as advertised. Specifically, I am conce [More]
Hi can any one tell me what is linear and binary search in detail. and what is the difference between them . which one is useful in coding. Thanks&Regards, S.GangiReddy.hi, If you read entries from standard tables using a key other than the default k [More]
Hi, I am newbie for OIM. I follow the instruction to integrate Oracle Identity Manager with Sun System Directory Server: Performing User Management and Provisioning. When i click import under Deployment Management, i get error "Error invoking bean me [More]