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

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)

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to perform single sign in cognos by using url?

744


HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1694


What is difference between page break and section report?

945


how to merge 2 crosstabs thans

2355


Explain the difference between powerplay transformer and power play reports?

770


What are the types of studio present in Cognos?

788


What is the difference between low affinity and high affinity connections?

773


What is an olap designer?

726


Explain what is the difference between microstrategy and cognos reporting tool?

752


Name the types of report?

726


What are the other methods working as deployment functionality?

716


my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

3771


What do you understand by the term 'aggregate cache'?

745


how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

1860


Can you explain model durability?

824