cancel
Showing results for 
Search instead for 
Did you mean: 

Report Filters & Hierarchies

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You will find a few instances of different behaviour across 5, 6.5 and XIr2/3.

Another is with the behaviour of what are now called merged dimensions. They now work how I want them to.

Anyway, back to your problem - as far as I have seen, you have to fully qualify Arthur Road in terms of it's ownership.

Former Member
0 Kudos

Hi Me map,

Thank you for the reply.

Can you be a little more elaborative when you say "you have to fully qualify Arthur Road in terms of it's ownership".

Thanks,

Arun

Former Member
0 Kudos

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

Answers (0)