Hi,please suggest me how to creat username while creating a
report.



Hi,please suggest me how to creat username while creating a report...

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)

Is This Answer Correct ?    10 Yes 0 No

Post New Answer

More Cognos Interview Questions

pls any body give the cognos 8 versions release year.

3 Answers  


How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...

2 Answers   HCL, IBM,


In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,


what is an associated query?

2 Answers  


Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me

3 Answers  






what is view? types of views?

3 Answers   HCL,


how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 Answers  


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

0 Answers  


What is render variable?Where do you exactly use in developing a report?

3 Answers   IBM,


What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.

1 Answers  


cognos is holap or molap or rolap

7 Answers   Cognizant,


why u need to publish the package?

5 Answers   IBM,


Categories