Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Report Filters & Hierarchies

Hi Guys,

We are migrating from BO 5.x to BO Xi R3.

Some of our existing 5.x reports have report level filters.

When we select any of the filter values the other filter objects are automatically changes either forward or backward compatible.

Example table:

Country ;; State ;; City ;; Address

India ;; Karnataka ;; Bangalore ;; Arthur Road

USA ;; Florida ;; Jacksonville ;; Arthur Road

India ;; Karnataka ;; Bangalore ;; G.C Road

India ;; AP ;; Hyderabad ;; M.G Road

Canada ;; Ontari ;; Toronto ;; Arthur Road

+Note:+ none of these objects are placed in an order in the BO 5.x universe. They are all mixed and belong to different classes and no custom hierarchy is defined.

The method filters work in BO 5.x is that the prompt values are filtered both forward and backward when we select a value in any of the prompts

Scenario 1:

Select Country as "India". The values in report prompts will be

Country ;;State;; City;; Address

India;; Karnataka;; Bangalore;; Arthur Road

;; ;; ;; G.C Road

;; AP;; Hyderabad;; M.G Road

Scenario 2:

Select Country as "USA"

Country ;;State;; City;; Address

USA;; Florida;; Jacksonville ;;Arthur Road

Scenario 3:

Select Country as "Canada"

Country;; State;; City;; Address

Canada ;;Ontari;; Toronto;; Arthur Road

Scenario 4:

Now for backward compatibility. Select Address as "Arthur Road"

Country ;;State;; City;; Address

India;; Karnataka;; Bangalore;; Arthur Road

USA;; Florida;; Jacksonville ;;

Canada;; Ontari;; Toronto ;;

Scenario 5:

Select a report filter in the middle like City "Bangalore"

Country ;;State;; City;; Address

India;; Karnataka;; Bangalore;; Arthur Road

;; ;; ;;G.C Road

Scenario 6:

Select Address "M.G Road"

Country ;;State ;;City ;;Address

India ;;AP;; Hyderabad;; M.G Road

The report filters when placed or used in the BO XI R3 report after migration does not work the same way as in BO 5.x.

Not sure what the reason could be.

Have checked the universe and there are no changed between the BO 5.x and BO R3 universes.

I cannot go for custom hierarchies as there are reports which use these objects from different classes and there are too many permutations and combinations to consider.

I would like to know whether the forward compatibility can be achieved without using custom hierarchies and does BO R3 support backward (i.e start from address and get the other values)and intermediate (start with city and drill both forward and backward) compatibility

replied

The objects have to be unique - does each Arthur Road have a unique code for example?

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question