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 |
---------------Tell me about DWH Concepts?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
How can we improve performance in framework manager level?
What is defined as data mining?
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)?
What is the abrevation of .PPR? (Power play report) or anything new?
Write various indexes used in cognos?
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
How can we find out cardinality between two tables?
Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.
I want to run one page with filter and another page without filter, what is process?
Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex: