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.
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 is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,
what is a Galaxy Schema?
How can we improve performance in framework manager level?
What is the difference b/w macros and prompt?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
What are all types of prompt?
Which one is better among Value and select & search prompts,in terms of performance?
How do I remove the hyperlink from the drill through report?
first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.
if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?