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 |
What you mean by drill across?
I want to run one page with filter and another page without filter, what is process?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
what is a join? what are the types of joins?
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
Can you define confirmed dimension?
Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.
What is the difference between the standard and metrics folder?
How to do deployment?
what is the generated prompt,how can i use?
----------------What is meant by DSS?