on 06-17-2009 8:45 AM
Hi all,
Has any one of you encountered such problem before?
In my case, I originally developed the universe and reports on XIR3 and then I was told that the upgrade of production (XIR2) will be delayed. Therefore I moved XIR2 testing environment and developed the universe and reports (yes, start everything from the beginning as BO does not support downgrade migration).
However, I found the same queries which are working in XI R3 are not working in XIR2.
To verify my observation and make sure I didn't do anything wrong in universe and reports, I migrated the objects from XIR2 testing environment to XIR3 again and found things working in XIR3!
What I am trying to display in report is quite complicated to describe and example here.
Simply, I have a table to store monthly sales information.
In the report, it contains a crosstab, which consolidates the sales information of every year's last/latest month and annual information.
So, I built 2 queries, query A retrieved every year's last/latest month sales information only and query B retreived summary information of every year.
It seems working in XIR3 but in XIR2, the columns from query B become blank.
Any one has similar experience during migration or in the report development?
Thanks and Regards,
Cherry
did you compare the sql query generated in xi 3.0 to xi r2?
-Subhodeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
10 | |
8 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.