Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

i am facing date format issue in webi report in BI4.0
environment.
i have unx based on Mysql connection.
date is coming in 10 digits numeric format like(2345623456).
I want to change it in dd.mm.yyyy format.
Please suggest

Answer Posted / avijit paul

create a variables to get the individual digits and then
concat the extracted digits. you can change it to date
format also using todate().

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What would you consider as your biggest achievement and why?

1012


how to create reports on screech?

2558


Explain in detail about type 2(scd),

1101


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1053


How to open a universe with out using the Designer ??

7602


what is xcelsius architecture?

4581


what will be the contents for a functional requirements specifications

2355


can anybody tell me about complicated object you have created

3222


When we use aggregate awareness function in designer?

979


What Is Snow Flake Schema?

1208


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4719


Explain about alerts in bos, under what situation we need to use alerts?

1054


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1267


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

5113


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10893