15. If I select the current month and year how can we
display previous 11 months data?
Answers were Sorted based on User's Feedback
Answer / revanth reddy
for example emp table i am telling
hiredate=add_months(sysdate,-11) from emp
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vamsidhar
A filter which filters the data for the last 11 months
should be defined.
The below filter with mior modifications will work...(I did
not try)...treating parmater1 as the prompt parameter
month_field between (parameter1-11) and (parameter1)..
U can also use addmonth function i.e addmonths(parameter1,-
11)
Is This Answer Correct ? | 1 Yes | 5 No |
How to apply securities for reports in cognos connection?
-------------What is a Conformed Dimension?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
how to explain health care project and which reports we can create in health care doain?
How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
7 Answers Genpact, iFlex, TCS,
Why do we create shortcuts in framework manager
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
What is difference between page break and section report?
Can you define cube?
What are slice and dice?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
How many fact tables you have in your project?