Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
- 2 Answers
- 8270 Views
- Mind Tree, I also Faced
- E-Mail Answers
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 |
What is Cardinality
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is conditional Formatting?
how to perform single sign in cognos by using url?
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
How u provide security to reports in report studio or in cognos connection?
------------------What is Focalpoint?
what is view? types of views?
How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?
What is Render Variable? where u can use?
how data modeling is usefull to cognos?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
Teradata 
