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 |
whats the difference between previous version of cognos and cognos 8 BI?
-----------------What is Direct and Conventional loading?
-------------How you design DWH?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
What is the use of report studio?
What do you mean by drill across?
How Metrics Studio is better than Report Studio?
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos