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...

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

Explain the difference between union and group?

1086


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

1011


Explain how we drill up week to month?

1077


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2175


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3818


What are the data types present in bo? What happens if we implement view in the designer and report?

1015


Explain what is aggregate table and aggregate fact table ... Any examples of both?

1098


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

1862


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2029


Explain what is the difference between slice and dice and cross tab report?

1055


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1011


Explain what three things do you consider to be the most important factors for a manager?

994


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3551


what will be the contents for a functional requirements specifications

2333


Explain what is the difference between business requirement document and use case document.

1004