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?
- 1 Answers
- 12507 Views
- I also Faced
- E-Mail Answers
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
in u r data u having duplicates how to fetch the latest data in our report?
Can you define a catalog and types of catalogs in cognos?
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.
how to connect datamarts
What are the types of studio present in Cognos?
i was asked what are the caluclations done by you in your report? plz give reply
What are initial page components of Cognos connection?
What is set to be cardinality?
Can you define cognos impromptu?
Which studio is used to create reports?
What is a Cube?
Can you explain model durability?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
how you create security to reports?
