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 tabular set? how can you break the report?

1 Answers   Syntel,

How to test a cube?

0 Answers  

8. Can you use calculations in report headers and footers? How?

1 Answers  

What are the themes in a data warehouse?

0 Answers  

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

0 Answers   Satyam,

What is the use of report studio?

0 Answers  

--------------Explain Table of contents?

0 Answers   Cap Gemini,

How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 Answers  

How to select multiple values from type-in prompt?

0 Answers  

what are versions of cognos from starting release to latest in the market?

4 Answers   IBM,

Explain how data modeling is useful to cognos in daily life?

2 Answers  

What is the difference between regular dimension and derminant?

0 Answers   TCS,

For more Cognos Interview Questions Click Here
Categories