I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?
Answer / rashmi
1. Create DataItem1 using session Parameter to get User Login details
#sq($account.personalInfo.userName)#
2. Create Bollean Varaible
Variable1: DataItem1 in ('UserID1','UserID2')
Variable2: DataItem1 = 'UserID2'
3. Assign Variable1 to List as render variable
4. Assign Variable2 to the cross tab as render variable
5. Run the report
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what is the difference between native sql and cognos sql?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance
hi my name is siraj i want to know cognos queriy language
Can you explain cognos planning?
how u will design the report if the objects are available
what r the names of the reports that u prepared???
9 Answers Covansys, IBM, Wipro,
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
Write some methods to apply securities in framework manager model?
What is content store?
Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me