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
- 11930 Views
- I also Faced
- E-Mail Answers
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 |
How can I test reports in cagonos?
How many fact tables and dimension tables in your project?
4. How many dimensions did you use in your reports?
what is mean by complex starschema ,star schemagrouping?
What are the Macros?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
what is the main advantage of impromptu over cognos reportnet?
How can I change reports to another package???
What are the types of studio present in Cognos?
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
Teradata 
