I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

0 Answers   IBM, KKL, Reliance,

---

2.How do you drill through report from Report Studio to Analysis studio?

3 Answers   IBM,

---

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 Answers  

---

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

0 Answers   TCS,

---

What is main difference mapplets and mapping?

0 Answers  

---

---

what is Associated grouping? and how it works in cognos impromptu?

1 Answers   IBM,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,

---

How to create multilingual reorts?

4 Answers  

---

suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???

3 Answers   CTS, iFlex,

---

Create 12 columns for months by writing single case statement?

1 Answers   Wipro,

---

What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance

1 Answers  

---