Search results for query: *

Hi all, currently we are busy migrating our Cognos 8.x environments to Cognos 10. Our cubes are built with an old Transformer version on a Unix machine and distributed via PowerPlay Web (not PP Studio!). Now we are analyzing how to proceed with them and the question arose if cubes built in...

Hi all, some of our users switched to IE9 recently and now experiencing some problems in opening Excel-Reports or export Cubeviews to Excel. I guess, IE 9.0 is not supported for Cognos 8.3, but I have found nothing definite on the web. Does any of you know more concerning that topic? Thanks...

Hi Jean, sorry for my late response, but I was on vacation the last days and left work far behind me ;-) I have no idea why there is this different behaviour and at the moment there is nothing which comes to mind, how you could further duplicate my issue. So I think I am going to contact...

Hi Jean, unfortunately I just discovered that my solution is not working as fine as I thought it would - in fact it is only working for prompts with single selects, but not for prompts with the possibility to select multiple values :-( Greetings, Mahali

Hi Jean, there are two types of prompts: drop-down lists as cascading sources and list-fields (I hope my translations are correct, as I am working with the german version). There is no static default value set, the contents for the lists are set up in queries - so if the report is called for...

Hi Jean, thank you very much for your answer! The users are re-running the report from the "run" icon that's shown in the report. I already checked the permissions, but the already only have the permission to read, execute and transit :-( I am thinking the whole time if there is not some...

Hi Thies, we have a prompt with different filters, e.g. a customer can be selected via a preselection of a customer group or a sales rep. Let's say I am first selecting a customer group by using a drop down menu, then, as a result I get a list of all customers and can select one or more from...

Hi there, our users are not very satisfied with the fact, that, if a report runs a 2nd, 3rd, etc. time the prompt shows the values, which were last selected, so they have to reset the prompt themselfes in order to select new values. Is there any option to reset a prompt automatically when...

Hi there, there has already been a thread (thread401-1343602) regarding this question and I just wanted to know, if installing Adobe on the server did work out? We are facing the same problem, so I would be happy to hear from you :-) Greetings, Mahali

Finally we have found a solution: hiding the columns by using variables and conditions turned out to be quite tricky and got us all confused in the end. What we now did is the following: we created four blocks, one for each different view and the use a string variable to show or hide one of...

Hi there, I have just discovered a strange effect, maybe one of you has an explanation: there is a select-statement in a pl/sql-procedure where there is a multiplication of a number and a varchar2-value and, which works perfectly well. If I copy the select-statement and execute it "stand-alone"...

Hi there, again facing a problem, which is starting to make me want to throw things through the office :-( I would like to create a report, which shows certain columns or hides them, e.g.: we have a product hierarchy and the user should be able to choose down to which level he would like to see...

Hi, great - this is working perfectly, thank you very much! Kind regards, Mahali

Hi there, as I would like to create some columns which should only be shown under certain conditions I need to access each column separately to change the output-variables. So first I select a column and the option "list column" from the properties pulldown-menu. But then the whole list report...

Hi there, I have just figured out the solution: what I had done wrong was to use a ',' instead of a ';' between the date and the format 'YYYY' - now it works perfectly well :-) Kind regards, Mahali

Hi there, just started with Cognos 8 Report Studio I am already facing some basic problems: all I would like to do is to show the current year. I tried with to_char(sysdate(), 'YYYY'), but that does not work and I cannot find any Cognos functions - I remember that there were year(), month()...

Hi there, just to get this topic finished: up to now I have not found a solution to the problem, but as we are planning to migrate to Cognos 8 in the next months, we are not going to invest more time than needed. The user found another workaround by just asking her colleagues to print the...

Hi lex, I have not tried this yet, but could this be the problem, if this is the only report, which can not be openend? The users says, the other reports open correctly. Thank you again :-) Mahali

Hi there, we are still using Impromptu V6 in our company and today the following error occurred, but it is only one user who gets this error: When trying to open the report she is getting the message: "The report is not a valid Impromptu report." After that a second error message appears...

Hi there, I have already found the reason for the error: it were some, I thought minor, changes on the underlying table that caused inconsistencies in the catalog - a little bit embarassing, but at least I might have learned that there hardly never is a "I did not make any changes"... ;-)...