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

What is the deployment requirements used in cognos?

0 Answers  

please please give me some banking calculations in framework manager.

0 Answers  

------------ Diff b/w MemberCaption and MemberDescription?

0 Answers  

how to explain health care project and which reports we can create in health care doain?

0 Answers  

What is the difference b/w macros and prompt?

0 Answers  

What are Governer Settings?

2 Answers  

how to perform back drill through in cognos 8 what is the use of it

0 Answers  

cognos is holap or molap or rolap

7 Answers   Cognizant,

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,

what is conditional query subject and example

2 Answers   TCS,

what is the difference between a data item and a query item?

2 Answers   Bodhtree, HP,

4. How many dimensions did you use in your reports?

0 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories