15. If I select the current month and year how can we
display previous 11 months data?
Answer Posted / revanth reddy
for example emp table i am telling
hiredate=add_months(sysdate,-11) from emp
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the roles defined by cognos platform?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is called materialized view?
What are the themes in a data warehouse?
What are the methods by which it non-durable model could be changed into the durable model?
What is defined as Query studio?
What are all the different types of prompt in cognos?
how to connect datamarts
Diff b/w Crossproduct and Outerjoin?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is a Cube?
What do you mean by drill across?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
what is degenerate key in oracle ?whare do we use it?
What is Metrics designer?