If there are two values at value prompt level and when selecting first value it
have to go to date prompt and when selecting second value we have to get
output without any prompting. How to solve this issue. if any plz mail me on this
vasuattada@yahoo.co.in
Answers were Sorted based on User's Feedback
Answer / pradeep
create a dataitem ib the query like...
case
when ?first? = 'Product Line' then [Product]
else
?Product?
end
use this dataitem in the filter condition for product
Is This Answer Correct ? | 0 Yes | 0 No |
What is the importance of Dimension in the cognos.
What are the Macros?
set scope level in transformer
what are the enhancements in cognos reportnet ?
What are links & Segments in Cognos Framework Manager?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
how to improve performance in report studio level
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
Tell me about Schemas?
write the sql query to display 5th and 10th row in a table?
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
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?