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...

Thanks for your help mfgf, greatly appreciated. I tested the items in FM and the results were correct but it would not generate the SQL. I verified the sql in the relationship SQL in the relationship definition in context explorer and I did see an outer join. Despite this an inner join was...

Thanks for the reply blom0344. No I didn't modify and publish with the existing report open. The relationship problem is just a part of a larger report. I created a new report from scratch with just these fields to try and identify the problem. Thanks for help anyway. Cheers

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...

drlex, navshiv, jdaems thanks for your advice and help. I checked the cognos.ini file and iqd file and everything looks ok. I noticed that a new cube recently designed with framework manager builds ok but all the historical cubes did not. I could not get any of the imr's to run and I noticed...

Thanks for persisting drlex & navshiv, appreciate your efforts. SQL Server Management Studio is installed.The database was originally setup in Impromptu 7.0 as 'Microsoft SQL Server 6.5(DB-LIB)' We no longer use Impromptu as we have Framework Manager now, however when researching transformer...

I was unsure about this as there are only 2 system data sources set up on the old machine with a SQL Server driver. None of these are specific to Cognos or access the servers needed for cube builds. The rest are Microsoft Access Drivers.

Thanks drlex I checked and both machines have the same version of SQLSRV32.DLL driver.

Hi drlex, thanks for your reply. This file was already present on the machine where I did the install in the location you specified. I copied across the file from my old laptop to test and I still get the same error message. Both of this files are identical, same date modified and file...

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...

CognosProfessional, thanks for your help. I can return ReportDate() but not CubeDate. The report on my portal now returns the date the report was run, but does not indicate when the cube was refreshed which is misleading. How can I get CubeDate() to work properly. Thanks in advance

Instead of ReportDate() I used CubeDate() and received the following error message: Function name was not found in expression: "CubeDate() When testing some date expressions: Today() returns a value ReportDate() returns nothing CubeDate() returns the above error message Not sure what I am...

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...

Jelledaems I have just found a solution to this. In Analysis Studio you need to drill down into the dimension through all the layers until you get to the lowest level of children. Pick any entry, it doesn't matter as long as it is the level that you want to insert all for. Right click, then...

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...

drlex, thanks for your help. Greatly appreciated. Cheers

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...

Thanks for your reply christenhusz. Currently all the measures are in pounds. The US amount is already converted to pounds. What I have been asked to do is display the US sales amount converted to pounds with a format of '£' (Already done) and the US sales amount with a format of '$'. The...