we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
IBM,
4 7080After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
IBM,
1 4665After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate IBM,
1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
2 8404how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
1921Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
2113what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
TCS,
2 14672
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What are the themes in a data warehouse?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is defined as Cognos Impromptu?
Is it possible to join multiple Databases in a Catalog?
What are query items?
Can you define drill down and drill up?
What is defined as catalog and types of catalogs in Cognos?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is the model filter?
What are various types of gateways in cognos?
what are the special features in cognos reportnet?
What do you understand by the term 'aggregate advisor?'