Any one please help me to solve this issue in Universe(3.1)

[Former Member]

Hi experts,

Recently developed an universe using universe design tool. Here the source is the SQLServer. Here we are getting issue in Date field.

Whenever i am taking the Date as Character we are getting error in WEBI report.Whenever i am taking date as Character i am getting error.

Can anyone tell me the ways to resolve this issue.

Thanks,

Anusha.P

[Former Member]

If Date datatype is defined as "Date / DateTime" in SQL server, then while creating an object in Universe define its datatype as DATE.

If you want to convert Date to Character then use To_char function.

or

Verify whether Date object Lov's contains any days like 1,2.. rather date.

[Former Member]

Hi Sujitha,

can u please tell me how to change the date format with screenshots in universe level using 3.1 like DD-MM-YYYY to YYYY-MM-DD. Help me if u know this..

Thanks,

Anusha.P

[Former Member]

In Universe, create an object with the below syntax..

[Date Object] =  LEFT(CONVERT(VARCHAR, [Your Date Column], 120), 10)  // Output date format will be YYYY-MM-DD.

Refer the below screenshot.

or

In Web Intelligence, you can create a variable like

Date = formatdate([Date];"yyyy-MM-dd")

[Former Member]

Hi Sujitha,

Thanks for your reply, if u have any document on creation of formulas in webi u can please share those documents to me....becz i dont know how to create formulas.

Thanks

Anusha.P

[Former Member]

Refer below threads, helpful for you to better understand Web Intelligence.

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_ia_en.pdf

https://dwbicastle.files.wordpress.com/2013/12/webi-report-function-overview.pdf

[Former Member]

Thanku you Sujitha...