1)How can we do the Union in Report Studio?
2)What is the meaning of Aggregation and Rollup Aggregation?
3)How can we hide the columns in Report Studio and How can
we view the hiding Objects?
4)Can we provide joins in Report Studio and in which
situation we can go for outer join?
5)If we take a Date Prompt and run it once it will show
default data,how can we change it exact 1 month back data?
Answer / sowjanya
1. For making Union query Both the input queries should
contain same columns.
2.Aggregation refers to Detail level Aggregation
Roll Up Aggregation is for Summary Level Aggregation
3.By making Box Type property None, we can hide a column. To
see the Hidden objects click on Visual Ads button and check
View Hidden objects
4.Queries can be joined making use of join query. when there
is any null record in the joining column which is to be
fetched then we go for outer joins(1..0)
5.To change the default date selection in the date prompt,
Java script need to be implemented
| Is This Answer Correct ? | 9 Yes | 1 No |
What are cognos connection initial page components?
-----------What is member Description?
-----------------What is Determination Model?
Explain the different types of views used in cognos.
What are the differences between cognos 8.2 and cognos 8.4? Please help me..
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What are the themes in a data warehouse?
-------------------What is StarShema?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
----------0Diff b/w Report Functions and Database functions?