I am new to installing SAP Rapid Marts. I am not sure and have not yet found any written material to confirm if I should use one target database for three rapid marts (IA, PP,SA) or if I have to setup one each. Thanks in advance for any advice.
I’ve installed multiple non-SAP rapidmarts at the same site before and they all went into the same target. The only thing to be careful of is that they don’t use the same table names.
I would guess that the reason there is no documentation on this is that it is dependant on your reporting requirements but they should still work either way.
I gone thru the documentation, it looks that i have to run some scripts(provided by BO) in DI. At my client place i dont see DI software. I was wondering is there a way to implement Rapid Marts without DI.
we dont have any customization, we are going to use the tables as it is.
i would appreciate if you or any one has implemented Rapid Marts, i would like to talk to you for 5min-10min. Just to understand the concept.
Hi All,
I am looking to have some kind of Documentation explaining the process for the implementation of Multiple Rapid Marts for Oracle EBS R12 (HR,AP & AR in first phase). I have searched across forums/available documents but cant find anything specific.
Any clue/suggestion will be of great help.
We are implementing 6 RapidMarts for a client. We used 6 local repositories in the dev phase for each of the 6 RMs. While moving to QA and Prod, can we hav 6 Local Repositories or do we hav to import all the ATL files to a single repository (Central Repository)?
You can do either one, usually you merge all repositories into one QA and and prod repo. Usign Central repo or export/import doesn’t make a difference.
Are there any recommendations or best practises to combine multiple Rapid Marts.
Some of the questions I have in mind are
Do I have to take special care of Global variables,init script, table values etc
Will all the combined rapid marts run all at once. Can I have one job yet have the handle to execute one Rapid mart at a time
3.What are the general Best practises to combine dimensions and fact
The Init_Script is identical across all RapidMarts so combining them all only requires one initial script and therefore no adjustments to the Global variables.
I would not run all rapidmarts at the same time but either combine them into a single job or schedule them one after another.
The RapidMarts share a lot of dimensional tables and maybe even some fact tables so running them in parallel can be troublesome. The advantage of combining them all into one job is that shared dimensions will only execute once. So, if the materials dimension is called in multiple RM’s it will only execute the first time, saving time and resources.
The SQL scripts that some with the RM for creating target tables are the same across the RMs so this only needs to be executed once, not one time for each RapidMart. Just be aware that if you execute he SQL scripts after loaing any data, the tables will be dropped and recreated and any data will be lost.
Hi, I Implemented three rapid marts (GL AP AR) sourcing from oracle eBS. We rationalized the ETL maps because each module had the the same set of reference data. So, we sequenced to have setup data, then dimensions, and last all facts in parallel.