Skip to Content

Change in Key for profit center hierarchy in Webi Report


We have recently made a few upgrades to our systems (Unicode in ECC and BODS upgrade to 4.2) and I have noticed a change in the key for profit center hierarchy, this has impacted the population of filtered tables and graphs, as the filter is looking for profit centers that it can not find. This can be fixed by manually changing all the filters, but this would be extremely time consuming.

As an example: A filter might have had a restriction on a few profit centers with keys in the format PC_xxxx_xx while the new key is 0HIER_NODE/PC_xxxx_xx.

Has anyone else experienced something similar and knows where the change originates from? Is there a work around instead of needing to manually change the report?

Many thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Oct 22, 2018 at 11:05 AM

    One work around if you know mentioned values are changing frequently then instead of applying filters directly at report level, first create the variable and use Right() function to capture the values in variable and later apply filter on variable.With this if extra text is going to be added in the hierarchy then it will not impact filters.

    Add comment
    10|10000 characters needed characters exceeded