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 |
What is Star schema group?
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
what is the difference between java script and html in cognos?
Hi Experts, Can a single package be shared by multiple users?
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
How the Bursting happens in same report and how to Print the bursting Report?
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.