Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

15. If I select the current month and year how can we
display previous 11 months data?

Question Posted / mkreddy

Answers were Sorted based on User's Feedback



15. If I select the current month and year how can we display previous 11 months data?..

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

15. If I select the current month and year how can we display previous 11 months data?..

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

Post New Answer

More Cognos Interview Questions

Can you explain the advantage of using shortcuts?

0 Answers  

How you will do the estimation for a task?

1 Answers   iGate,

how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......

2 Answers   TCS, Tech Mahindra,

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,

Can you define drill across?

0 Answers  

Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,

Can you define cognos impromptu?

0 Answers  

What do you mean by drill through report?

0 Answers  

cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  

What is defined as data mining?

0 Answers  

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

0 Answers  

For more Cognos Interview Questions Click Here
Categories