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 |
How to hide/unhide the prompts which are not used by unauthorized users?
How many fact tables and dimension tables in your project?
what do u mean by bridge group? where we r using this one?
can reportnet supports cubes???
How do you improve the performance of the Cognos Analytics report
how to do page breaks in cognos 8 Report studio pls give the navigation
How to a create header dynamically in a crosstab report in cognos 8.1?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
Can u please describe the different types of traps with eg. Thanks
what is an outer join? difference between left outer join right outer join with an example?
Where do you edit cognos sql in report studio?
In a Single page we are having 3 list. While running each has to populated in separate page?