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
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What is the difference between Standard and Metrics folder?
What are the advantages of using cognos sql?
What do you understand by the term 'aggregate advisor?'
What is difference between page break and section report?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
------------ Diff b/w MemberCaption and MemberDescription?
How to test a cube?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Define metrics studio?
What are the types of catalogs in cognos?