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

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

Question Posted / g.v .subramanyam

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

Please Help Members By Posting Answers For Below Questions

what is document design in boxi,have u participate in that

2192

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?

10906

Explain what would you consider as your biggest achievement and why?

984

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

1056

explain in detail about type 3?

1022

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

1099

Explain in detail about type 2(scd),

1108

Explain how to execute the plsql procedure from the report by clicking with mouse?

1057

What is difference between custom hierarchy and report based hierarchy?

1028

Explain about a time when you discovered a more efficient way to do a work task?

1156

What are the join problems comes appart from loop,chasm & fan Traps

2146

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

988

Explain what task is 98% of the required work of a business analyst?

1107

What is the difference between the public object&schema object?

1082

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

1366