Interested to Buy Any Domain ? << Click Here >> for more details...
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
- 4 Answers
- 9191 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prathik
We can achieve this by using condition blocks.So that user can select the block which he wants to see based on the condition.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / seshu
We can do the same by using render variable but if you use the render variable that is better way to take two pages on one page you should have the list and on other page you should have both that are list and crosstab.
use one prompt with static choices that are as follows:
1>List
2>Both
make any boolean variable or string variable where you need to define the condition that if (?promptdisplayvalue?='list')
then
1
else
2
assign that 1 variable to the page where you have list and assign the value of 2 where you have both list and crosstab
| Is This Answer Correct ? | 1 Yes | 0 No |
OP, Can you clarify how to differentiate between the first user and the second user?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mohana krishan kapa
You can use the layout calculation,
This will return the user Name and based on user name you can restrict the data.
| Is This Answer Correct ? | 0 Yes | 3 No |
what r the filters in fwm and report studio
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
How to create measures and Demensions?
Can i apply drill through on master detail relationship report?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
What are the services provided in cognos 8?
cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer
What is the difference between Conditional Layout and Conditional Block
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
Column level security in report
---------------Describe OLAP Reporting and RDBMS Reporting?
Teradata 
