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?



I have a report with list and cross tab in same page,How do you restrict one user can see only the l..

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

Post New Answer

More Cognos Interview Questions

Main Differnce between Cognos7 and Cognos8

1 Answers   IBM,


-----------With out using DrillThrough how to do Reports?

0 Answers   IBM,


What is the difference between Open Connection command ang Open Session Command?

0 Answers  


Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 Answers  


I want to run one page with filter and another page without filter, what is process?

1 Answers  






Can you explain dynamic query mode?

0 Answers  


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

0 Answers   IBM,


wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

0 Answers  


What is a scope? can you tell me one example for scope?

1 Answers   CTS, IBM, TCS,


what is an outer join? difference between left outer join right outer join with an example?

1 Answers   HCL,


Define the slice and dice?

0 Answers  


what is meaning by Master detailed relationship ? please explain one example

4 Answers  


Categories