Answer / palzkumar

lookup table is nothing but the table which will have two coulmns, first one will've diff values (eg. Mumbai, Bombay, Bom, Mum) sec one will've single value (like Mumbai).

Your etl mapping would be... if any values like Mum, Bom, Mumbai, Bombay then you need to populate as Mumbai.

Answer / janni

Lookup is One Of the transformer in ETL tool.it can be used
to filter the data in Target table.

there are 2 types of lookup are there

1.connected Lookup
2.Un Connected Lookup

What is architectue of Cognos 8

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,

---

what are typees of dimensions

11 Answers   HCL,

---

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

0 Answers  

---

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

---

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,

---

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,

---

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

0 Answers  

---

----------------------What are the User Securities?

0 Answers   IBM,

---

what do you mean by parallel execution of query?

1 Answers   Mind Tree,

---

how to test reports in cognos?

0 Answers   IBM,

---

What do you mean by drill across?

0 Answers  

---