How to create Generic TIME CLASS, which includes Objects
Year,Month and Qtr?

Answer Posted / g.v .subramanyam

year=to_date(to_char(timeclass,'yyyy'));
month-->to_date(to_char(timeclass,'month'));

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference in creating filters in designer and business objects?

560


Explain the data types present in bo and what happens if we implement view in the designer and report?

528


how to create reports on screech?

2044


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2572


U r project in which stage in implementation?

1925






Can we create universe with no cache??

1928


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

565


Explain the difference between union and group?

599


what is the difference b/w the refresh and buffered data?

1734


Can more than 1 metric be applied on an analytic in business objects?

1632


What is the difference between datawarehousing and businessintelligence?

588


Explain is there any other repository domains rather than universe, security, document?

560


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

4407


When to use local filter and when to use global filter?

572


How to restrict password to a user while sending a document in .pdf format

1828