Interested to Buy Any Domain ? << Click Here >> for more details...
1.How can we driil through from a page report having query1
to list report having Query2 in master detail relationship
n Drill through?
2.In database i have 50 records but when it is displayed on
the report i'm getting 100 record with duplictes.How can we
solve this to eliminate duplicates?
3.Exact Diff B/W Filter n Condition?
4.Render Variable?
5.I have leftouter join when right table does not have any
matched records with left table what will be the output of
the report whether it will be dispalying Null or blank in
that particular row?
6.How to test the reports i.e Unit Testing?
7.How canwe drill through when there is no common column
between the parent n child report?
8.How can we do performance tuning?
I kindly request all the experts to give reply with correct
answers and if possible send me some examples regarding
that at srini.madhala@gmail.com
- 1 Answers
- 6421 Views
- IBM, I also Faced
- E-Mail Answers
Answer / soujivadlani
Render Variables are generally created to conditionally
render a particular page or chart or list o block. The
purpose of the render variable is to hide a particular item,
we cant say it used to hide particular item.
When we are using render variable only the queries which
satisfies the parameters will be rendered and hence the
other queries will not be processed in back end by cognos.
| Is This Answer Correct ? | 3 Yes | 0 No |
where do we see the run time of the report ?
In which types of reports does the page breaks applicable in Cognos...?
Give me any example of semi and non additive measures?
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
Diff b/w surrogate Key and Primary Key?
Can you define pivot?
What is RenderVariable?
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
example for generated prompt
What is difference between page break and section report?
where you can save the report net documentation in our local system?
Teradata 
