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 can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....
What is Star schema group?
What is a Pivot?
How many fact tables you have in your project?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
hi my name is siraj i want to know cognos queriy language
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
Why are meta service important then other services?
Can you define confirmed dimension?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
Where do you edit cognos sql in report studio?
what is the use of layout component reference