Answer / lakshmi

Using Star schema grouping we can resolve the ambiguous joins
if there is more than one path exists between query
subjects then we may get wrong data to overcome that one we
have to identify where the loop is occured then select the
query subjects right click create star schema grouping then
it will ask name space if u give any name for that then
click k then one Alias Shortcut is created for the entire
query subjects whatever you selected which is nothing but
phisically exists and which is used to resolve the loops

pls ans what are the filters we have in framework manager? filters in report studio?

3 Answers   IBM,

---

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

2 Answers   IBM,

---

How to schedule the report twice in a day?

2 Answers   Cognizant,

---

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers   HCL,

---

What DB View and Bus View?

0 Answers  

---

what r the names of the reports that u prepared???

9 Answers   Covansys, IBM, Wipro,

---

What is the difference between ‘macro’ and ‘prompt?

0 Answers  

---

what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,

---

How do you call a store procedure within a transformation?

0 Answers  

---

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

1 Answers   IBM,

---

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers   Satyam, TCS,

---

In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,

2 Answers   Tech Mahindra,

---