Skip to Content
avatar image
Former Member

Hierarchy is not displaying correct in Bex Report

Hi all,

   I am having an issue with Hierarchies.An  Hierarchy which is correct in RSH1 are displaying incorrect in bex reports.In Bex report hierarchies are still pointing to old values where as in BW system they are up to date. Can some body help me to resolve this issue?

Thanks

Sai Mamidi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 02, 2015 at 09:36 AM

    Hi Sai,

    Please try re-activating the hierarchies and disable the cache and try to execute the report in RSRT.

    Also are the hierarchies time-dependant ?

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 08:16 AM

    Hi Sai,

    First of all, please narrow down if the issue could be reproduced in RSRT- html mode. If yes, try to deactivate cache during runtime to see the result. If still the hierarchy is outdated, try to check the hierarchy itself. For example, check if the updated hierarchy is mapped to the hierarchy I table and K table. I met some similar issues  in the past and solved it by reactivating the hierarchy to get the tables updated.

    Regards,
    Cecilia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The table looks good so the hierarchy itself should be consistent.
      I then have another thought that if the temp tables used in the query execution are wrong~~~

      you may get the temp table name from SQL during query execution, and check the nodes relationship in the table directly. Alternatively drop the temp tables by report SAP_DROP_TMPTABLES. Then the temp table will be recreated when you run query again.

      Regards,
      Cecilia

  • Nov 02, 2015 at 11:39 AM

    Hi Jacko,

    1) activate the hierarchy.

    2) check for time dependencies and compare backend and frontend for the same date.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Can you attach the screenshots here.

      1. From the Query designer showing the variable used.

      2. prompt value showing the older values.

      Also can you activate the master data for customer sales info-objext or run the ACR for same and test.

      Thanks,

      Amit

  • Oct 30, 2015 at 06:32 PM

    Hi Sai

    Since when you are facing this issue? was there any change in hierarchy recently?

    Is the hierarchy in ECC and BI RSH1 matching perfectly?

    Please run the query in analyzer and in RSRT to see if its an issue only with portal

    ALso let us know the bi version that you are currently using

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded