on 05-25-2011 6:23 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.