I have one connection to sap bw, we reached the objects but some objects like cubes , matillion does not reach this objects, the error said Table not available

Matillion ETL
1

When i check when the next query SELECT * from DD03L WHERE TABNAME = '/table/table' sap give me information about it, but matillion didnt see this information, some one of here know how to reache this object?

2

Hi Francisco,

Cube data in SAP is very tricky to get to. A cube is a collection of tables: fact tables (with separate tables for compressed and uncompressed data) and dimension tables. These tables are joined through technical keys (SIDs). If that is not complex enough, you might also have master data relationships to take into consideration, adding more complexity to it.

 

Cubes is a bit of a 'thing of the past' - SAP is moving to a different kind of storage object, which is more relational than OLAP (ADSO or Advanced DataStore Object) - so depending on your version, and whether your BW system runs on HANA or not, you might have different connection options.

 

One thing to be aware of is that in most license agreements SAP explicitly forbids to extract data from Cubes, unless you go through OpenHub. The use of OpenHub does require a license - but once you have this, it does make extraction a lot easier. The OpenHub interface is basically 'flat tables' which are populated from a cube through a load process. Your SAP BI team should be able to advise on this.

 

If your BW system runs on HANA, you might consider connecting to HANA Calculation Views instead. Again there are licensing restrictions, but as long as you use the Calc Views which are automatically generated by BW, you stay within the license agreement.

 

I am not sure why you don't see the tables you are looking for. Are you looking the Matillion SAP Netweaver Query component? If that is the case, there is a default limited set of tables exposed to this component, but you could change the configuration to include any table.

More info on that topic is here:

Add New Data Sources to SAP NetWeaver | Matillion ETL Documentation

 

I hope this help. Good luck,

Jan.

3

@jan.vanansem1621938233548​ many thanks for that insight, and for the helpful pointers. Now I understand why you did not mention cubes in your presentation at the SAP Document and Data Management SIG in March this year 😀 (You have to login, but here is the link).

Best regards,

Ian