shrini


{ City }
< Country > india
* Profession *
User No # 17958
Total Questions Posted # 1
Total Answers Posted # 5

Total Answers Posted for My Questions # 1
Total Views for My Questions # 5757

Users Marked my Answers as Correct # 8
Users Marked my Answers as Wrong # 10
Questions / { shrini }
Questions Answers Category Views Company eMail

1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

IBM,

1 Cognos 5757



Answers / { shrini }

Question { Satyam, 9364 }

what is the difference between group span and level span


Answer

Group Span and Level Span both are same

Group Span(Cognos8 Series onwards)

Level Span (Reportnet)

Is This Answer Correct ?    1 Yes 1 No

Question { 6005 }

Where in report Studio's property pane can I find
NoDataHandler?


Answer

Select you List or crosstab or chart, go to properties pane, you can find the No Data Handler, where you can give some message so that it displays that message(No data found for this selection) when data is not there for passed parameters.

Is This Answer Correct ?    5 Yes 0 No


Question { IBM, 7269 }

1)How to bursting the cross tab report?
2)What is meant by Object explorer?
3)What is cascade report?


Answer

1)How to bursting the cross tab report?
A:- Place the crosstab in a list and provide master detail relationship to list and crosstab.
From File Menu Enable report for bursting and set the Burst group and reciepents and save it. Schedule the report in cognos connection. The report gets distrubuted as per your receipient data item(Ex: country, Customer etc..)

Is This Answer Correct ?    2 Yes 2 No

Question { 4849 }

hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........


Answer

Think you have 4 dataitems in report, 1 column as salary.
So if you to find top 5 salaries then:-
rank(Sal)- Ranking Displays the ranks of the salaries based on there values.

running-cont(rank(Sal))-Top provides you the top salaries and least salaries. For example to show top5 salaries.
top<=5 display top5 salaries

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 5930 }

I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.


Answer

For example if you are in Mar2012:-

_add_months(sysdate,-2) which takes you into Jan2012.
After this convert the _add_months(sysdate,-2) to t0_char or to_date as required.

Is This Answer Correct ?    0 Yes 7 No