Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 12331 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is main difference mapplets and mapping?
What is the advantage of using shortcuts?
How Metrics Studio is better than Report Studio?
What are the different uses of a repository manager?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
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.
What is main advantage datawarehousing over oracle?
What is a Folder?
how you migrate reports to cognos 8 from previous versions?
What are the components used in web tier?
can you tell me what are the dimension tables are used in project
How is cognos model organization works?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Can you define dimension?
What is catalog and types of catalogs in cagonos and which is better?
