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 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


Please Help Members By Posting Answers For Below Questions

how can I test reports in cagnos?

856


What is the difference between Standard and Metrics folder?

779


What is a Framework manager?

777


what is degenerate key in oracle ?whare do we use it?

2289


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1898


What is called cognos reporting tool?

793


Define the slice and dice?

762


What is main advantage datawarehousing over oracle?

766


---------------Describe OLAP Reporting and RDBMS Reporting?

1887


Can you explain new content durability?

757


New coloums are added in database, then how you know in report level

1364


What you mean by drill across?

793


Write some methods to apply securities in framework manager model?

868


what are the names of the reports that you prepared?

810


What are the components used in web tier?

740