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

A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?

1 Answers  

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

0 Answers   iFlex,

How to publish a package by running Java Script?

0 Answers  

how to convert crosstab into list?

4 Answers   TCS,

Usage of Stored Procedures in Cognos

1 Answers   General Motors GM, TCS,

Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  

What are slice and dice?

0 Answers  

What is difference between content store and content manager?

0 Answers  

What is drill down and slicing and dicing whats the difference between them?

0 Answers  

How do you call a store procedure within a transformation?

0 Answers  

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,

For more Cognos Interview Questions Click Here
Categories