Skip to Content

BOA: Sorting Date Characteristics in Query with BW 7.5 on HANA

Hi all,

after upgrading to BW 7.5 on HANA, changing the sort order of date characteristics like 0CALMONTH and 0CALYEAR does not work anymore in BOA 2.4, if those characteristics are restricted within the Query. If a sorting other than the Default is defined for the characteristic in the Query, it is displayed correctly on the first execution of the Query. If the sorting is now changed in BOA, it is applied and cannot be changed again.

Sorting is possible when moving the "Characteristic Restrictions" to the "Default Values".

Other characteristics seem to not have the problem.

Is there any way to solve this issue? Can anyone check if sorting of those characteristics works in a later BOA version with BW 7.5. on HANA?

Thanks

Stephan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Jun 11 at 09:57 AM

    SAP provided Note 2654334 for this.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 09 at 02:17 PM

    Hello,

    Please implement the note: 2622886 - "Sorting doesn't work in case of Time Characteristic", which has been released recently.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Michael,

      our system is BW 7.5 SP10, so 2494060 - which I had already checked - does not apply.

      I found out that sorting by text does work for characteristics in the customer namespace (Z* in our case) referencing SAP time charecteristics. It seems only the 0* InfoObjects cannot be sorted by text.

      Regards

      Stephan

  • Mar 13 at 12:01 PM

    Hello Stephan - I haven't experienced any issue with 2.6 SP1 on 7.5 (but not using HANA)

    Is there a chance you could download 2.6 with the latest SP on a desktop to try yourself? 2.4 is several years old...

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Tammy, thank you for the quick reply!

      I will try to get 2.6 SP1 (or later) installed. It may take a while, since I do not have the authorization to do this myself.

  • Mar 19 at 08:37 AM

    Hello Tammy, after installing Version 2.6 SP1 sorting in a query still does not work properly. There is no problem running the same query in one of the other (non-HANA) Systems. I am afraid we have to create an incident. regarding this.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27 at 12:24 PM

    Hi Stephan,

    did you already hear something concerning your incident?

    We suffer from the same problem and I just tested with BOA 2.6 SP2 but the problem still exists. We're also running BOA on BW 7.5 on HANA. Beside of the dates 0CALMONTH and 0CALYEAR, I found the error with the date fields 0FISCPER and 0FISCYEAR. For example in the SAP demo query 0D_PU_C01_Q0016. If you restrict 0CALYEAR or 0CALMONTH you can't sort them properly, whereas the purchasing organization (in that case 0D_PUR_ORG) works perfectly fine.

    best regards

    Michael

    P.S.: Mabye it's a Java problem. The sorting error only occurs in the BOA, SAP Portal or Java Web (via RSRT) but I couldn't reproduce it using the BEx Analyzer or ABAP BICS mode in the RSRT.

    Add comment
    10|10000 characters needed characters exceeded