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
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 |
can reportnet supports cubes???
how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?
How to do Performence Tunning in Cognos Reports?
What is the difference between macros and prompt?
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?
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333
in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day
diff b/w dimension and regular dimension
can any one say the which is the best performance in framework manager
if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?