Search results for query: *

Hi Cognos Guys, currently we are investigating, how we get all european holidays into our data warehouse. Has anybody a possible solution, how we can get all european holidays? Preferred are RDBMS sources but if there is an excel solution available, no problem. Thank you in advance.

Hi, we do not use Impromptu, we use ReportNet. Can you specify your comment (Macro, Export Excel etc.)? Thank you.

Hi, we wanna send reports in Excel 2002 format per mail to our customers. But there is a big problem. We have about 100 person related data reports. In excel 2002 there will be created for every person an own worksheet (because of page break within Report Studio). That is okay, but if there are...

Hello, our customers wanna have an excel report with specified measures that will be saved on a network drive because he wanna do customer specific calculations. Is it possible to transfer the reports from Cognos Environment to a specified Network Drive? If yes, what I have to do? Thank you...

It works fine but we don't need milli seconds - but that is no problem. Does it also works with MR2? Because we have installed MR1 again.

Thank you. I will test it and give you some feedback.

I tested it and does not work within Report Studio.

Where do I find this functions like: Number-To-String-Padded, Round-Down ? Direct in Report Studio?

Hi, this one is failing: concat(concat(concat(concat(Decode ( Length (Floor ( ([T_LOGIN] ) / 3600 ) ), 1, concat('0',Floor (([T_LOGIN] ) / 3600 )), Floor (([T_LOGIN]) / 3600 ) ), ':'), Decode ( Length ( Floor ( mod((([T_LOGIN] ) / 60), 60 ) ) ), 1, concat( '0', Floor ( mod((([T_LOGIN])...

I asked your DBA and he said that we have installed version 9.204

supported I mean...

Hi, we use oracle 9.202 and we are using only the drivers that cognos supports. Are there any who were not reported?

Hi DoubleD, the calculation you posted worked also fine but with MR1. With MR2 it is not possible. We get the ORA-00979 error, QE-DEF-0177 or UDA-SQL-0446. So we analyzed that problem and if we delete the concat construct, it works. But we need this time format for our customers. We have shut...

Hi all, we were using the concat construct from djknuddel but until MR2 there is no possibility to use this. All our reports aren't runable so we had to uninstall MR2 and install MR1 again. Is here anyone how can help us with this issue? Thank you.

Hi, we have the same problem and we asked the support about that. They told us there is no possibility at the moment because nobody need that.