Write back to BW cube through HANA Stored Procedure?

[former_member216978]

Hi ,

I am looking for a way to write back to BW cube using HANA stored Procedure and not use the traditional approach

where we fetch the data as output using stored procedure and write that to BW cube using traditional write back approach .

Is it possible to write back to cube considering it is not a flat structure using simple insert sort of statement which we can do with DSOs?

Best Regards,

Rakesh

[roland_szajko · Accepted solution]

Hi Rakesh

Inserting data to a cube (even if its hana optimized) is a bit more complex than inserting data to a dso. In case of a DSO a simple insert is enough, since it contains the actual values. The cube however and its fact table does not contain the values, but the SID-s of the corresponding characteristic values. This makes a data upload to a cube via direct SQL statements too complex.

br

Roland

[former_member216978 · Accepted solution]

Thanks Roland!!

IN that case it will  be insertion to the fact table with the SIDs?

SAP should have given some standard stored procedure which can be invoked to write back like we have in ABAP layer.Any other opinion on this??

[roland_szajko · Accepted solution]

Yepp exactly. Before the insertion all characteristic values are converted to SID-s.

The reality however is not that simple, since many checks are done during the cube update. One of these is the time consistency check, which checks if the data for the time dimension is consistent or not. In case of non-cumulative scenarios this is essential.

As of now, its not possible to check this purely with DB tools and therefore there is no stored procedure available to do this from DB level directly. For the same reason its not possible to use HANA executions on DTP-s whic has cubes as a target.

[henrique_pinto]

Do you really need to use a cube?

If it's a BW 7.4+ system, consider populating a table in HANA and creating an openODS on top of it and a composite provider if you want to emulate your old cube.

If you can't due to license issues, just write back to a regular aDSO and create the composite provider on top of it.

[shanthi_bhaskar]

Hi Rakesh,

Check this blog on how to consume procedures

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f06342ec-60a0-3010-b8aa-9ece92ae0...

[Former Member]

Hi Rakesh,

      As far I know there is no simple way to write back to a cube.There are few options

1) Realtime enabled cube --> using Integerated Planning ,with your own custom planning function(your stored procedure) you can write back to cube.

2) As a workaround make your stored procedure to write to a table,then build open ODS on top of the table and consume the DATA.

Hope this helps..

Thanks & Regards

   A.Dinesh