Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2101


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2421


hi my name is siraj i want to know cognos queriy language

2272


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1165


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

2353


i was asked what are the caluclations done by you in your report? plz give reply

2194


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

1015


What is the difference between a data mart and a data warehouse?

1044


Why cognos decision stream is used?

1160


What are all the types of report?

1096


What is the use of report studio?

1031


What are the different types of reports present in cognos?

986


1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3568


How is possible this scenario using in type-in prompt.?

1057


Explain what is the main advantage of impromptu over cognos reportnet?

1049