Interested to Buy Any Domain ? << Click Here >> for more details...
15. If I select the current month and year how can we
display previous 11 months data?
- 2 Answers
- 9997 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Define metrics studio?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What is called cognos reporting tool?
------------ Diff b/w MemberCaption and MemberDescription?
how can I test reports in cagnos?
How to do Performence Tunning in Cognos Reports?
What are the main services provided by application tier?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate Why is auto-regression used in forecasting used on cognos platform? Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest. -----------------What is Direct and Conventional loading? Name the types of gateway? What is Metrics designer? describe the starschema grouping ?how can i add a new column
for existing report ,when it is not present even in model &
dataabase?
