Skip to Content
0

Fact table data not visible in Analysis for Office when inserting using procedure

Sep 24, 2017 at 09:38 AM

22

avatar image
Former Member

Hello,

in my project we have a real-time InfoCube and Calculation View. On top of both of them we have composite provider, aggregation level and planning function to copy data from CV into InfoCube. This architecture is not recommended by SAP system when having CV as part-provider in Composite Provider planning function is not executed in HANA but in ABAP which means it takes 15 min to insert 300.000 rows.

We have developed a different architecture with Hana Procedure that is inserting data from CV into Fact table of the InfoCube. The procedure is called by the method inside class -> then method is called in the program -> program is inside Process Chain -> and process chain is started using planning function so that user can start it from Analysis for office. This solution is allowing us to insert 1mln records in 3 min.

The issue that we are now facing is that when procedure is run and data is inserted into fact table this change is not visible inside Analysis for Office. We are able to see data correctly in the InfoCube. When entering through rsrt or analysis for office data is sometimes showing already copied data sometimes is showing old data. There is no stable situation when accessing this data from front-end tools.

After running the procedure there is no request added to the InfoCube which means there is no tracking of this action.

Is there any requirement to read data from InfoCube if it was inserted by the procedure directly only fact table?

Thank you for your help

Emilia

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers