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

How to configure the Cognos configurations to work in the Windows 2000 Server machine?

1 Answers   IBM, Infosys,

suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,

What is meant by drill down?

0 Answers  

What is Additive function?

0 Answers   IBM,

2. What is With Clause In Cognos?

2 Answers   Wipro,

What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

0 Answers   TCS,

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

0 Answers  

What are various types of gateways in cognos?

0 Answers  

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 Answers  

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers  

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

3 Answers   TCS, Thomson Reuters,

----------------What is Scopr Relationship?

1 Answers  

For more Cognos Interview Questions Click Here
Categories