Answer / chiru

If u want to create a username for report....

First drag and drop a Query Caluclation and type #sq($account.personalInfo.userName)#... click okk and run the report u will get username

(or) if u type #sq($account.defaultName)# it will give Default name...........

Here
# ……..# denotes macro
Sq denotes single quotation.
$account --- Session Variables
PersonalInfo.username is default username( Note: u can get these expression and information in Internet also)

How do I remove the hyperlink from the drill through report?

2 Answers   Misys,

---

Explain the Difference Between Bursting and Scheduling?

1 Answers  

---

What is a Pivot?

0 Answers  

---

What is difference between primary key and unique key constraints?

0 Answers  

---

How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.

3 Answers  

---

what is the difference between native sql and cognos sql?

0 Answers  

---

wt is the differnce between Block & conditional block ?

2 Answers  

---

Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting

2 Answers   IBM, TCS,

---

Can we create reports using OLTP database?How?

3 Answers  

---

Can you explain the advantage of using shortcuts?

0 Answers  

---

what is the difference between java script and html in cognos?

1 Answers   IBM,

---

How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 Answers  

---