 Related Questions 1.Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction). 2.Highlight Latest Answer : You can use the following steps to have a dynamic column title1. Click the unlock button and unlock the report design2. Delete the column title3. Place a text item on the column4. Go to the query explorer5. Drag a data item into the query6. write the ... Read Answers (11) | Asked by : Jagan How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count Read Answers (3) | Asked by : Jagan Use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007 i need to restrect this query to current date and current year [gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosales_goretailers].[Orders].[Order month]=to_number(to_char(current_date,'MM'))pass polar ID Read Answers (2) | Asked by : ramakrishnamanne What is meant by Junk Dimension?How do you perfom while running the report?Where will you see the time of running report?Size of the cube?What are the types of prompts in ReportNet?What is macro and how it will be work?What is difference between Cognos and Cognos ReportNet?How do you create cube in ReportNet?There are 10 facts are there.How will you connect all? I need answer Read Answers (11) | Asked by : hakkim View Question | Asked by : SC Latest Answer : Catalog contains metadata which is used retrieved by warehouse database is called catalog.Actually 4 types
catalogs. They arePersonal catalogShared catalogSecured catalogMaster Distributed catalog.MDC is better one ... Read Answers (8) | Asked by : chimpara reddy Latest Answer : 1. In Cognos Connection, Go to Public Folders or My Folders, click the schedule button for the report you want to schedule.2. Under frequency, select how often you want the schedule to run.3. Under Start, select the date and time you want the schedule ... Read Answers (4) | Asked by : chim Latest Answer : Users and Permissions can be given in Access manager - Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine. ... Read Answers (4) | Asked by : chim Latest Answer : Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main. ... Read Answers (1) | Asked by : chim Latest Answer : I worked with cognos transformer / powerplay version 1.0 back in 1995.... cognos is a company founded in 1969. ... Read Answers (2) | Asked by : chim
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
