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
- 9407 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 |
Explain the difference between native sql and cognos sql?
How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?
i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?
what is bobble chart?
Define query items?
-------------How to do Bursting a Report?
what is cube size?
What are the differences between Cognos 8 and Cognos 7.x version?
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
what is a join? what are the types of joins?
Teradata 
