Search results for query: *

Hello, I was wondering does anyone know how to get the cubes viewable over the web. I have the cubes on the powerplay enterprise server and working but I cannot view them over the web. Does anyone have any ideas on how to get started, I have installed a web server, and it is working but I...

Hello, Can anyone tell me how to change the currency symbol on powerplay web and upfront. I set the local in upfront to my country but it associates the old currency symbol to the measures instead of the euro currency symbol. Regards canhe

Hello, I am putting cubes on Powerplay enterprise server on a unix machine. I can connect with powerplay client remotely and I can see the cubes. However, when I try to view the cubes over the web interface I cannot see the cubes. I can see the sample cubes e.g outdoors.mdc. I have set the...

Hello, I was looking into Impromptu Web reports and how they work in a client(Windows)/Server(Unix) environment. Could someone please clarify this. (A) I create the reports on Impromptu web reports windows) export these reports onto Upfront(Unix) and the user is then able to view the...

Hello, I have Cognos Transformer on Sun Solaris system and it keeps throwing and "Out of Memory" error. I have over 2gb free in memory and plenty of disk space. I have set the memory in Cognos Transformer to 65 mb but when a do a top command (see below) as it is running and it shows...

Hello, I am trying to create a cube but I start running into memory errors like: (TR1901) Out of memory rswrkfil.c (291): sort error rsgen.c (489): sort error I would like to know has anyone come on these kind of errors. I am using Transformer v7.0 on unix machine. I guess it has to do with...

Hello, I have a report as follows 2002 2003 Year No of outputs 10 20 30 Value 1000 2000 3000 ... ... Now I want to divide the Year "No of Outputs" = 30 into all the values in the...

Hi, I have a situation where I have 2 different user classes say UC1, UC2 I have a Location Dimension -> Country code, Region Code. I have two customers Customer A Customer B Country Code IRE IRE Region Code MO MO UC1 can see all levels for all customers. UC2...

Hello, I was wondering how some developers verify the cubes they create? I wrote some macros and pulled some information off the cubes into a text file and ran some sql queries off the database and outputted to a text file. I ran a compare script to see if there were any differences. I think...

Hi, I have a situation where I have Cognos Cubes residing on Powerplay Enterprise Server(Unix). Users connect remotely to view the cube. I was wondering does anyone have any ideas on exporting the data from the cube to an file. This is purely for testing the cube against the database. Any help...

Hello, I have a situation where I have cubes sitting on the Powerplay Enterprise Server (Unix) and users connect remotely. I was wondering has anyone come on the situation where it is possible to export data to a file from the cubes. I want to be able to export the data without having to...

Hi, I have a situation where I have a dimension Customer(Customer No) and a Region Dimension (Postal Code)in a cube. I want to restrict access to certain users on Region when the Customer No is say "246". In this, certain users cannot see the region when the customer no is...

Hello, I was wondering what is the best way of securing cubes on a unix machine and allowing some users see certain levels in the dimension. The cubes sit on the Enterprise server on a unix machine and the users connect remotely. Any info would be appreciated. Canhe

Hi, I got this error running transformer on Unix "(TR1901) Local PowerCube size exceeded allowed maximum of 2147418112 bytes." . Does the cube have an maximum allocated space. I did not run out of space for reading otherwise the error would be 'transformer cant write to a file' Any...

Hi, I have a catalog created from an Informix database. Everything is fine until the transaction logging is turned off on the database and then I can no longer connect to the database as it gives me 'Isolation level errors'. Is there a way to connect to the database and run reports with the...

Hello, I am enquiring is there any analysis function in Transformer and Impromptu to analyse catalogs, sql, mdl files etc. I know Impromtpu has Content Overview. Is there any more procedures available for either tools? Thanks

Hi, I was wondering has anyone exported data from a database to a file and used these files to read into Cognos Transformer. If you did; Did it reduce the time to build the Cubes and did it reduce the overall time it took to create the cubes between the two options below: Option (1) to run the...

Hello, Does anyone know what is new in Impromptu 7 in comparision to Impromptu 6?

Hello, I was wondering has anyone got a solution to replacing /0 (divide by zero error) in a cube with 0. I have some calculations that are completed with a "Calculate Measure" in transformer and in cases gives me some results like /0. It is not possible to complete these calculations...