suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
Answers were Sorted based on User's Feedback
Answer / suresh
Hi,
Steps to do.
1) Select that particular column
2) Unlock the object
3) Just simply cut that list column(Dont delete)
4) Create a boolean variable and write code
your measure column>50000
5) drag conditional block to that column which you already
cut the column
6) CB Properties Under Block variable Point to already
created boolean variable.
7) Select Yes and drag you measure value to that CB
8) Just select the text item and under drill through
properties point to your report.
9) Select no and drag your measure again to that CB.
10) Run the report.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kumar
Hi Friends,
We have Conditional Drill Through Concept.
Create a boolean variable with specific condition, select
the variable from conditional explorer then define the
Drill through.
Thank You
| Is This Answer Correct ? | 0 Yes | 2 No |
in u r data u having duplicates how to fetch the latest data in our report?
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve 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
how can you get the errors in job? when loops are araised we get error?
Write various indexes used in cognos?
What are the roles defined by cognos platform?
What is render variable?Where do you exactly use in developing a report?
Can you define cube?
Why do we create shortcuts in framework manager
what is an outer join? difference between left outer join right outer join with an example?
pls any body give the cognos 8 versions release year.
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance