Interested to Buy Any Domain ? << Click Here >> for more details...
I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.
- 2 Answers
- 6909 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagendra
create a filter in the report Query with date from and date
to parameters.
eg: date>=paramdatefrom and date<=paramdateto
When you run the report Select date prompt from jan 1 to jan
31 2012
| Is This Answer Correct ? | 8 Yes | 1 No |
For example if you are in Mar2012:-
_add_months(sysdate,-2) which takes you into Jan2012.
After this convert the _add_months(sysdate,-2) to t0_char or to_date as required.
| Is This Answer Correct ? | 0 Yes | 7 No |
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
-----------------What is Direct and Conventional loading?
How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..
what is requery in cognos?
Why need staging area database for dwh?
Can you define set to be cardinality?
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
What is Online View?
where you can save the report net documentation in our local system?
what is the difference between cascading prompt and drill-thru
Define olap designer?
How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?
Teradata 
