Search results for query: *

Hi all I need urgent help with a date format issue. I have a report in Cognos 8.4 that exports data to Excel 2002. The date fields are not always exported in the date format (dd/mm/yy hh:mm:ss) but sometimes is a number. Example: 13.07.2010 18:00 40372.72916666 To me it seems it happends...

Hi all I have an issue with a chart in Cognos 8.4 comparing to 8.2 version. I have a bar graph, horizontal (actual a combination graph)and on axis x I show the values for count of tickets, and it is showing the intervals as: 0 0 0 1 1 1 (version 8.4) 0 0.2 0.4 0.6 0.8 1 (version...

Hi all I have 2 tables table1: cr_id 1 2 3 and table2: cr_id, location 1 loc1 1 loc2 2 loc3 3 loc3 3 loc4 I need to show in the excel output the list of cr_ids and associated locations separated by comma for example. Like below 1 loc1, loc2 2 loc3 3 loc3...

Hi all I have a cube and drill-through report. One of the dimensions of the cube has the values: 'tree' 'hou&se' 'block'. I have for example three dimensions in the cube: dim1 (the one above) dim2 (date) dim3. If I select dim1='tree' and a value for dim2 and dim3, the drill-through works...

Hi all Do you know how can I rotate the labels in the Ordinal Axis in a graph, from showing them horizontal direction into vertical direction (90degrees)? I am using Cognos Report Studio 8.2 Thanks Miki

Hi all I have a Cognos 7 cube with a drill-through report Cognos 8.2 I have for example 2 dimensions on which I can drill-through: Metadata items - [REQUESTOR_BUSS_FUNCTION] (with values Blank and 'Architecture') - [CREATED_DATE] with dates 1. If I choose 'Architecture' and dates for which...

Hi all I have in an FM model, table1 & table2 with a left outer join. 1table: every day in the calendar: day1, day2, day3, day4. 2table: day, record_id, group_id: day1, record_id1, gr_id1 day1, record_id2, gr_id2 day2, record_id3, gr_id1 day3, record_id4, gr_id2 I want to be able in Cognos...

Hi all Is there any function (or way to do it) that would return the previous record values while I am reading the current record? I need to do a calculation = previousrecord.field1 - currentrecord.field1? any ibm support/tips&tricks document existing to give me some ideas on this? Thanks...

Hi all I have a report that extracts the reported_date field from a database, where the date is stored in GMT time. Currently in the report this reported_date is shown in GMT time (like in the database). I would like to know if there is a function in Report Studio that converts this date into...

Hi I would like to know if there is a way not to show Categories button and option in the BOXI enterprise. Only Folders I want to show. Thanks Anca

Hi I have the following data: weekno field1 field2 field3 week1 value1 value2 value3 week2 value4 value5 value6 I would like to show the data trasponzed (as you are able to do in Excel by clicking on copy-paste special and transpose: weekno week1 week2 field1 value1 value4 field2 value2...

Hi I have created a report in CR9 based on a Command. The command looks like this: SELECT A.SITE_NAME, A.CUSTOMER_ID, A.CUSTOMER_NAME, A.START_DATE, A.RECORD_FROM, A.OUTAGE_TYPE FROM IML.TAMSSLA2 a WHERE A.START_DATE>=date(year({?datum})-01-01) And A.START_DATE<={?datum} The command has a...

Hi I created a report (with CR 9) based on a query from SQL Designer. Two of the fields are date_altered and time_altered. I just created the report which groups a bit the data but in rest it just shows the same fields from the query. When I opened the first time the report it worked fine. But...

I have a problem with exporting a report to a csv. When exported it loses the data in. It should be like this: Sep-03,99.9421,99.9884,20.0000 Oct-03,100.0000,100.0000,0.0000 and instead it looks like: 09/03,100.0000,100.0000,0.0000 10/03,100.0000,100.0000,0.0000 I don't understand why. I...