Answer Posted / 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 many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2161

---

how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

2341

---

4. How many dimensions did you use in your reports?

1998

---

What do you understand by the term 'model durability'?

1071

---

how to create measures and dimensions?

1176

---

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2372

---

What is looping and how to avoid it in framework manager?

1254

---

What is dtm?

1218

---

What are the types of studio present in Cognos?

1081

---

Name the types of report?

1010

---

can we insert all types of charts in a list report? what r the realtime prompts?

2264

---

How the Bursting happens in same report and how to Print the bursting Report?

1918

---

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2066

---

What are the types of security?

1076

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2623

---