Interested to Buy Any Domain ? << Click Here >> for more details...
15. If I select the current month and year how can we
display previous 11 months data?
- 2 Answers
- 9900 Views
- TCS, I also Faced
- E-Mail Answers
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?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
How you drill from powerPLay to Impromptu?Explain all Steps?
which difficult you faced in your project?
how you create security to cubes ?????
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
what are slowly changing dimensions? Why we are used scd?
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.
What do you mean by drill through report?
Write various indexes used in cognos?
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
Teradata 
