Performance issues with Inventory Reports in BW on HANA

[Former Member]

Hi Frzz,

Our client is migrated to SAP BW Powered by HANA.

Now the inventory cubes are In memory Cues.We have reports on Inventory cubes. But we didnt find any query performance after we migrated the cubes to in memory cubes.

Can some one suggest any performance tuning  w.r.t  the in-memory Cube / query.

Thanks and Regards,

Krish

[AtulKumarJain]

Dear Krishna,

You can check below link for more infor

Converting Standard InfoCubes to SAP HANA-Optimized InfoCubes - Modeling - SAP Library

http://www.saphana.com/docs/DOC-3129

It will help you .

BR

Atul

[Former Member]

Hi Atul,

Thanks for the response.

The links are provided info about Inmemory Cubes. But my question is how can we improve the query performace when we reading the data from inventory cubes.

Can some one please guide.

Cube contains almost 2 billion records. No partitioning has been done with the cubes. We are executing the query in Mode-3.

I heart some concept called SPO ( Semantic partitioning Object ). Will it be helpful to improve my query performance???

Best regards,

Krishna.

[Former Member]

Hi Krishna

Did you get any solution for this issue. How you able to handle this?

Regards

Resh