Answer / mohanakkireddy16

First i need to know,
1. is it a relational or Dimensional Package
2. about your Time Dimension

See, in go Sales Query Package, its easy.
Firstly, Create a crosstab report where product will be on rows year on column and revenue on measure. (Assume this as (Query 1)), Create a value prompt - USE value & Display Value is "Month" Query Item. - (Assume this as (Query 2))

Create a detail Filter as [Sales (query)].[Time].[Month] = ?Month? in (Query 1).

Unlock the Cells. then Drag Layout Expression to left side of the " <#Year#> " and then drag Month Parameter into the expression and then click ok .

Give some Default value for that value prompt like March.

There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)

1 Answers   CTS, IBM,

---

Explain the characteristics of cognos?

0 Answers  

---

what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?

2 Answers   IBM,

---

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,

---

7. What is performance tuning?

0 Answers  

---

For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,

---

How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 Answers  

---

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,

---

Any Cognos planning Queries Rise

5 Answers  

---

if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

2 Answers   CTS,

---

What are the Ways to Import Data into Catalong?

1 Answers   Cognos, IBM,

---

How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?

1 Answers   Mind Tree,

---