on 11-06-2013 4:36 PM
Hi All,
What are the options to move data from BFC 10.0 - Cube designer to SAP BW?
Will Business Objects FIM can be of use? Is there any other option than BODS.
regards
Hello,
Cube Designer allows you to deploy and generates Netweaver BW cubes.
FIM and BODS enables you to read data from BW through a RFC connection and inject data into your target system (BOFC for example).
Regards,
Matthieu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You should have a look into the installation guide of BOFC 10.0 there is a lot of explanation on what you need to do.
To summarize you need to :
So there is a lot of stuff to do on the BW side, and a little on the IPS/BOFC side, however this is not rocket science
Everything is detailed in the FC10 install guide, so you should download the last one and fine a BW buddy available to work with you.
Regards,
Matthieu
I have gone through the installation document and I just want to crosscheck one part, what is mentioned in the installation document is deploying the cube as netweaver BW.
In my case I am deploying it in SQL database and deployment type is Star Schema (please see the last message screenshot).
I want to extract the data from this star schema table to SAP BW.
Am I missing something (or lot of things may be )
Hello,
Sadly, never had a customer that wanted to do that.
I usually retrieve data from more than I inject them into BW.
So I can't help you about that.
Regards,
Matthieu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I have no customer that tried to do that.
I mean, you want to extract data from a StarSchema to the BW PSA and then reuse some of these data into another BW cube ?
Regards,
Matthieu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Jith,
The problem that with a starschema you have severals tables.
If you only need the measures (amount,convamount and consamount) you need to extract one table: 'Default_coGlobalAmounts', so I guess that with SAP DataServices it is possible to make it but you need to have some good skills in designing jobs.
However, I think it's maybe possible with FIM.
You can create a datasource based on this table as a source, and a datastore as BW.
then you will map your tables and run the job.
BW can either be a source or target of a FIM job.
Hope it will help you.
Regards,
Pierre
Hello,
You can deploy the equivalent of your SQL starschema into a BW cube.
It may also require you to change some settings into your cube designer settings. (the xml file into the cuber designer installation folder)
You can copy paste the installation folder to have 2 cube designers with two different configurations.
Regards,
Matthieu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.