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
- 6040 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is an olap designer?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is meant by Reportstudio shortcut?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What are the components of the report studio?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What are the components used in web tier?
can you tell me what are the dimension tables are used in project
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Give the advantages of cognos?
Diff b/w Crossproduct and Outerjoin?
How to test a cube?
