Migration of Universe from BO 5.1.9 to BO XI 3.1 - Issues

[Former Member]

Hi All,

We have recently migrated one Universe from BO 5.1.9 to BO XI 3.1.Post migration we are an issues with objects in XI 3.1 Universe.Their is no problem with these objects in BO 5.1.9

I have date objects defined in the Universe.This objects is used in prompts in Deski and Webi reports. In Deski I am getting only the date part in the LOVs bur in Webi I am getting the time also say '12/07/2010 12:00:00'. I know that this is a problem and is planning to use custom LOVs to take only the date part.But wanted to know is it the only solution or their is some other more feasible solution.

Many Thanks & Regards,

Sandeep

[Former Member]

Hi,

I am not sure if it is an issue that can be fixed by either a hot fix or by a service pack.

One potential solution is to modify the DATE object in the universe so that it only brings the date part and not the complete TIMESTAMP. If the column name is Date then try something like this:

CAST ('DATE' AS DATE FORMAT 'dd/mm/yyyy')

You might need to modify the syntax for your database. It should work just fine.

- Noman Jaffery

[former_member142702]

Which fix packs and service packs did you install along with BO XI 3.1?

Regards,

STratos

[Former Member]

I am using BO XI 3.1 SP3 and the backend database is DB2.

Regards,

Sandeep