Answer / ram

In Cognos8.3 report studio proparties pan there is a
proparty called No data contents by default it shows No .
We can set that proparty to Yes. In the report pagebody we
will find one tab called no data content. there we can use
the text you can tell the end user there is no data

Answer / moon

Ram's answer was perfectly currect...................

Answer / ram_cog

Use No data pane option

Answer / viswa

It is possible when u have prompt in prompt page... suppose
u take one list in main page... the list query u will assign
the page.... and take conditional block and drag the after
list and take one text item drop after conditional block...
in ur list have year, product line,quantity..... and take
the year in prompt page as text prompt.... go to conditional
explorer u will take string write condition like this...
if(product line is null or product line='') then *('hide')
else ('show')and come to main page select the conditional
conditional block.. go to conditional explorer select the
string as hide and come to properties pane select the
current block choose hide and come to main page take the
text item drop at the conditional block....and again select
the conditional block go to properties pane select the
current block as show and come to main page take entire list
and drop at the conditional block.......

Answer / guest

Suppose there is no data in the report, when you run the
report, only the title will be displayed, data part will be
empty.

In such scenario, you have tell the user that the selection
criteria is not met with the business rules.

Eg. user run "monthly stock report" with selection of "week-
15" as time selection, will not display the record.
because, this report associated with calander month, so any
month has to be selected.. Last date of the month is
considered for monthly stock report.



rgds,
-palz-

What is loop in frameworkmanager ?

4 Answers  

what are typees of dimensions

11 Answers   HCL,

What is IQD?What is contained in IQD?

3 Answers   ABC, IBM, Infosys,

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

0 Answers   Accenture,

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  

What is defined as data mining?

0 Answers  

in u r data u having duplicates how to fetch the latest data in our report?

2 Answers  

we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

2 Answers   Accenture,

Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?

2 Answers   Satyam,

what is the difference between count and running-count functions?

1 Answers  

What is Normalization?

3 Answers  

how to change the colour of the bar in charts...?

3 Answers   IBM,