Tuesday, July 1, 2008

List Report - 2 color rows

If you are using list report, and for better readability you want to use 2 colors for alternate rows in list then this can be achieved by the solution below-

  • Create 2 extra data items in the query say dataitem1 and dataitem2. Define them as-
dataitem1 - running-count([any data item of query])/2
dataitem2 - _round([Data Item1],0)
  • Create a boolean variable say boolean1. Define it as-
[Query1].[Data Item1]=[Query1].[Data Item2]

  • Attach this variable 'boolean1' with all the columns of list i.e. select each column body and set boolean1 into their 'style variable' property.
  • Now go to conditional explorer and click on 'Yes' below the 'boolean1'. the central vertical bar will become green.
  • Now Select all the list columns and from background color property select first color you want.
  • If you want to keep second color as default color then save the report and run it to check or repeat the previous two steps to 'No' value of 'boolean1'.

Thursday, June 26, 2008

Cognos 8 Interview Questions

  1. What are the different type of prompts available in Cognos 8?

  2. What is Cascaded prompts and how we create cascaded prompts?

  3. User want to display either a chart, a cross tab or both as per the selection from prompt page. How can it be achieved?

  4. Why do we use Java scripts in cognos?

  5. There is a uniselect value prompt. User want to add an option 'All' to select all the values from the prompt. How can it be achieved?

  6. What are different types of reports available in Cognos 8?

  7. What is the difference between 2 properties 'Aggregate function' and 'Rollup Aggregate function' of any data item?

  8. User want to have 5 fixed columns on the report page and 10 optional columns. Optional columns are listed in a prompt. Report should display optional columns those are selected by user from prompt. How to achieve this?

  9. Which tools are available in cognos 8 and what is the purpose of each one?

  10. What do you mean by Drill through reports?

  11. What is Master-Detail Relationship?

  12. What is conditional block?

  13. What are the limitations of Cross tab reports?

  14. What is report bursting?

  15. How to use conditional variables?

  16. What are the advantages of using Layout component reference?

I'll be coming with more questions very soon.