Search results for query: *

Hi Cognos 8 Report Studio report sourced from a cube Issue: I have a nested crosstab report which looks like this: YTD PYTD --------------------- YOP 2007 YOP 2006 --------------------- Subject 200 100 I am trying to create...

FRAMEWORK MANAGER 8.1 REPORT STUDIO 8.1 I have an issue where records are being suppressed from a report studio report. The report is referencing two joined tables. Table 1 – Individual Table 2 – Individual Primary Subject Tables are joined on primary subject code. Cardinality for the tables...

Hi Hoping someone can point me in the right direction. Cognos 8.1 (Report Studio) Issue: I have created a report which is not returning all records that I need. It is a list report with a aggregated (total) count. I checked the generated sql/mdx and ran this in SQL Server Man Studio and...

Appreciate any help in advance. Powerplay Transformer: 7.3 Issue: I have received a new laptop and have installed the client software and can open models successfully, however I can't build any cubes. I receive the following error message: (TR0118) Transformer can't read the database []...

Could I please have suggestions/advice on the following please: External consultants have been working on a new project which has involved creating a new database and cognos 8 installation in one of our overseas offices. The database will be replicated to one of our servers locally and the...

Apologies in advance for this post as I know this should be straight forward however I am new to C8 and would appreciate any help. Product: Cognos 8 Report Studio 8.1 Issue: A cube has been published as a package and I have created a report off this cube (report is a chart). As the cube is...

Cognos 8 Analysis Studio Version - 8.1 We have recently upgraded for Cognos Powerplay Series 7 to Cognos 8. There was an icon which was heavily used amongst our users in powerplay client (on the left hand side of the dimension viewer in reporter mode) which inserted the lowest level of...

Impromptu Administrator Version - 7.0 My catalogue currently points to tables only in a SQL Database. Additional data needs to be added to the catalogue and I have been asked if views can be used in addition to tables. I cannot see an option to do this. Is this possible or will I need to...

Hi Cognos Transformer - 7.0 I need to be able to display measures with different currency formats. The default format for my cubes are £'s. I would like to add another measure to be displayed in US dollars $'s. Is this possible? I have tried adding new currency and changing the default...

Powerplay Transformer 7.0 Problem: TR0806 The date is invalid I am trying to use a .csv file as a datasource within my model. I have selected source type as delimited-field text with column titles. An example of the date format is: 01/07/1993 12:00 I have tried using Data Class = Date &...

PLATFORM: Windows 2000 Impromptu Version: 6.1.4.0 ImpUser.exe – Application Error I have used several versions of Impromptu but this version would definitely be the most unreliable so far. My problem occurs when saving a query as .csv Saving as any other file type works fine. Error...

Hi, I have created a basic report with the following information: Total Count Count < 1 hour % < 1 hour Northern Southern Western Cluster Count In addition to other filters applied through the Select Expert, I have set parameters for the Start Date and End Date for the report. This...

Hi, I need some assistance with the following: I have the following fields: DATE IDENT_NO UNIT_ID LOG_CLEAR Ident_No is a string and Unit_ID is numeric. Log_Clear is a date-time field. I would like to run a report which returns those rows where Log_Clear is null...

Hi, I would like some help to calculate a distinct count of two fields. The two fields I would like to calculate a distinct count of are: CASE_NO VEHICLE_NO I would like to group these by location so I have placed the following formula in the group header: DistinctCount({CASE_NO},{LOCATION})...

Hi, I am currently using Impromptu 7.1 to generate a flat file out of an oracle database. I need to import this flat file into an access 2000 database. My problem is that the date/time fields do not accurately show down to seconds. eg. 01/07/2003 12:12:00 When I import this file the seconds...

Hi I have a table which stores time intervals in seconds. I would like to format these to hh:mm:ss. Can anyone help me with this? Any help would be greatly appreciated. Thanks in Advance. Cheers

I have created a calculation in an impromptu report to return an interval between two date/time timestamps. The impromptu report is retrieving records via an oracle database and the format of the field generated is: 0 00:00:50:000 I have been asked to calculate an average of this field to be...

I am new to crystal reports and a novice using SQL so any help with the below would be appreciated. I have two fields: D.Case (Date/Time) Format dd/mm/yyyy hh:mm:ss T.Case (String) These are fields in Q_Case Table. I would like to count T.Case but group by day of month. eg. 1/07/2003 25...

I have a table with numerous timestamps in (dd/mm/yyyy hh:mm:ss) format. I have worked out the calculations of specific time intervals which are updated for each record. Each “job” may have any number of records associated with it. Each job is given a unique JobID number which is in...

I am currently having problems displaying a date/time value to corresponding fields in a table. I need to split a date/time field into 3 fields. These are: 1. Day of Month 2. Month of Year 3. Day of Week The current format of the source date/time field is dd/mm/yyyy. I have successfully...