Skip to Content

SAP Bex Reporting

Hi Bex Experts 

I Have a Field HU (Handling Unit ) then i want to get count of handling unit .

so please tell me how to get count

Regards

Srinu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2014 at 09:20 AM

    Hi,

    it is very easy to get the total count.

    do one thing at desiging level.

    add the one KF (ZCOUNTat target (cube/dso) level.

    while making the transformation give the constant values 1 for the ZCOUNT KF

    select the KF at transformation -> go to the change mode -> select rule details -> select the constant -> give the 1 - it will count each record 1.

    come to designer -> open the query -> create the new selectionfor the HU (Handling Unit ) and add the KF.

    now you will get the count of HU (Handling Unit )

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      you are shared the scrren shot it the document format .

      you can easley get the count of objects.

      in target level use the KF constant 1 then load to DSO/CUBE.

      have you started the design if not please start the design and let me know.

      Thanks,

      phani.