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.

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,

---

wt is tupple , Embed function ? wt is regular dimension ?

1 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

How can you create prompts in framework manager?

4 Answers   Tech Mahindra,

---

What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?

0 Answers   IBM,

---

---

what is log in cognos?

0 Answers   IBM,

---

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,

---

what is sdibling function tell me the some functions

3 Answers   IBM,

---

i have a table with 3 columns country,empname,salary and i want the query for get the  name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance 

2 Answers   IBM,

---

Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance

2 Answers   SAP Labs,

---

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

0 Answers  

---

what is the difference between list sequel and cross tab sequel?

2 Answers  

---