cancel
Showing results for 
Search instead for 
Did you mean: 

Key figure [Number of records] is missing from BW powered by Hana compare to BW powered by DB2)

SAPSupport
Employee
Employee
0 Kudos

Hey team, we notice a strange behaviour:

  1. Created query based on multiprovider from DB2 DB and the [Number of Records] shows in query in KF.
  2. Create a query based on the composite provided based SAP 7.5 Powered by HANA and the [Number of Records] is missing from the KF

Our System is Netweaver 7.5 SP25 powered by HANA.

Does anyone know?

Thanks!


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee
0 Kudos

Hey,

the concept behind this [Number of records] key figure is technically referred to as 1ROWCOUNT.

It is not provided for all provider types. It needs to be checked if your composite provider would actually contain at least one part provider of such supported type.

Have a look into the Wiki for more details:

Technical Key Figure 1ROWCOUNT (ROWCOUNT)

Also, the KBA provides more background:

2545497 - 1ROWCOUNT in Queries based on InfoCubes, ADSOs or CompositeProviders

Hope this helps!

Answers (0)