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
Firefox is very slow to respond when opening and nearly always stops responding altogether, even refusing to react to the Task Manager "End Program" command. The "not responding" error message also comes up during navigation on line. S [More]
. I bought a new Mac Pro from an Apple store 2 days ok, it was sold as factory sealed, but it's reconditioned - it has some strangers entire photo,library from 2003 to 2011 in the trash bin. I was bought a Mac book pro as a birthday gift from the App [More]
Hello, I just got an iPhone 4S and it seems that the bluetooth function in it doesn't work. I tried few times to pair it to other non Apple phones but it never worked. Does anyone has an idea how to solve the problem? Tks.This is not a feature of iPh [More]
I have a new iPhone where I restored from an old iPhone. The old iPhone had an iCloud account I hadn't used and I don't know the password. How can I remove the old iCloud account from my new iPhone? It keeps asking for the old password I don't have.Y [More]
We are integrated with our OnPrem system via HCI for Customers and Employees.   A change occurred to one of our employees within our ERP system (last name changed).  The change came over to our OnPrem system from ERP and an iDOC was generated to send [More]
I am on Windows 7 and Adobe Acrobat XPro.  Every time I try to delete pages in any PDF after saving I get the error message "one or more pages are in use and could not be deleted".  the work around is to close the file and then reopen.  Then you [More]
This Connection is Untrusted You have asked Firefox to connect securely to xxxx.xx.xxx, but we can't confirm that your connection is secure. Normally, when you try to connect securely, sites will present trusted identification to prove that you are g [More]
I have used Firefox for years on Windows machines having found it the best for my purposes . so installed it on my new MBA. After trying Safari found  it good but lacks a lot of the add ons  .... however just found out that Safari has battery managem [More]
Hello I want to know the full cycle for the Asset under construction.........if i go for line item settlement or without this...........what should be the treatment............. what is the step by step procedure for it............ regardsDear Pari, [More]
I'm using Oracle 10g, from SQL plus I used some built in functions to spool to an xml file, my question is what functions I can use to read from an XML file and insert into an Oracle database table as varchar2 or number or date not as an XML type in [More]