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)

Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

2 Answers   Mphasis,

---

how u will design the report if the objects are available

0 Answers   Ness Technologies,

---

data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,

---

-----------Diff b/w OLAP and RDBMS?

0 Answers   Bank Of America,

---

Can you explain cognos planning?

0 Answers  

---

what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,

---

what is the difference between aggregation and roll up aggregation?

1 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  

---

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

0 Answers  

---

What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

5 Answers   IBM,

---

What is the enterprise class platform architecture of cognos 8?

0 Answers  

---

What is a Cube?

0 Answers  

---