How connect BW infocubes via Datastore DI?

dataservices administration
1

I want to use Data Service 3.0 to connect the infocubes from SAP BW.
However, after i connected it, i only see the fields/colums as an object in the table.

My infocubes name is Customer Sales, and it has infoObject/fields:
Characteristic
-CustNo
-CustName
-Sales Office

Key figure

  • Amount
  • Quantity
  • Volume
  • Counter

Time characteristic
-Fiscal year
-Fiscal year/ period

After i create new datastore (Datastore type: SAP BW Source), my table is containing all the InfoObject but exclude the key figure: Amount, Quantity, Volume and Counter.

My questions are:

  1. Is InfoCubes is something look like a table also? Because InfoCubes is containing data, is it suppose the InfoCubes = Table in my DI? In other words, under my table, it should be InfoCube model, and not the InfoObject/field
  2. If all the InfoObject is under my table, how am i to do the ETL? Is not possible to extract the InfoObject into other data warehouse right?

ylai20 :malaysia: (BOB member since 2008-05-21)

2

The way DI works with the BW source datastore is that you import an Infocube and we import all the tables that form together that cube for you. But it is still table based.

Using OpenHub would be a better approach.

Werner Daehn :de: (BOB member since 2004-12-17)

3

Thank you for your reply.
Is it means that is not a right way to connect infocube using DI? Because i dont see any good point that i connect the infocube like this way.

I have try to use openhub in BW, it is a way to extract data directly from infocube and put into a csv format right?
However, my company need to build a separate data warehouse (a table that contain data from the infocube in BW), because we need it for another project (reporting purpose), we do not want to get the data directly from BW itself.

I suppose have to use DI to do all the extraction job…is it possible? Please advise, thanks!

Thank you very much!

ylai20 :malaysia: (BOB member since 2008-05-21)

4

No one can help me? :cry:

ylai20 :malaysia: (BOB member since 2008-05-21)

5

These tables you see are the tables of BW. Your question hence is, how does BW organize the cube into tables?

Werner Daehn :de: (BOB member since 2004-12-17)

6

After i imported the cube, it gives me all the dimension that form the cube…is it means that i need to use DI to form the table back/define the relationship among the table? I thought i just need to connect the cube and it gives me the whole cube fact table? :?:

ylai20 :malaysia: (BOB member since 2008-05-21)

7

Unfortunately yes, you need to join the tables yourself.

Werner Daehn :de: (BOB member since 2004-12-17)

8

Oh, thank you very much!

ylai20 :malaysia: (BOB member since 2008-05-21)

9

Is it the same with BODS 4.0 also. do we need to join those tables once i import Infocube ? which means rebuilding cube in BODS

Please advice.

learndi_2011 (BOB member since 2011-03-03)

10

No change.

Johannes Vink :netherlands: (BOB member since 2012-03-20)