Recent content by Julia23

Thanks Kevin and I will try this out. Sorry again for my request! It was realy stupid and I did not want to make anyone to make the work for me. Thanks again!!

Ok and please sorry for my stupid request...

Halo, I have this script and I want to run it on a cacm.all collection but I become always this error: perl split.pl cacm.all Can´t call Method "print" on an undefined value at split.pl line 49, <> line 1 I think the code is right but IO::Fileworks probably not on my PC. The cacm.all data is...

Hallo blom0344 and thanks for your Help, I already knew that Cognos Impromptu is a Reporting tool but I was hopping. I just wanted a clearly Answer. I really thank you for the Help. I must make it in Acccess. I had a few Problems with the Catalog. I have found it in the Firma and I couldn´t...

Thanks billnted, I have alreay read the Impromptu Ebooks. It´s a little difficult my situation... I will read it again more carefully. We had already a Cognos course but we learned just the Basics. Thanks again :-) Julia

Hello everyone, I have a few questions about Impromptu (7.1). First can I insert Data in Impromptu? I have the columns and I want to insert a new Column and the User can add the Data Manually. Is that posibble? I have read something about Prompt... Is that the way? Can anyone describe me that...

No one? I have read over 200 Posts in this Cognos Forum but I don´t find a way to connect the 2 tables so I can then make a calculation in Cognos. I have tried to import the new Access Database in Impromptu but there is no way I can add the new Access Table there. I don´t have created the...

Hallo everyone, I have a difficult task... I have worked for a while with cognos and with your help I have learn a lot. I must now import in my Transformer Model a new Data source. Its a Access Database. My Question is, can I connect the new Data Source with the others Tables The new Table has...

Thank you very much Lex for the information! I will search in this Forum for a cognos Macro. Yet I know that a different way to update the Data isn´t possible. Thanks for you help again!!!

Halo Everyone, I am looking for a way to update the Powercube data. I have read the ebooks but I can´t find any simple way or the option for Automatic Update. I have a Database for the current year (2007) and tha data imports are every day. I have created a Model and a Powercube. But if I only...

Halo, I have tried again and now it works. It was a simple paranthesis Error. Here the right expression: if ( "Datum" = 2007-01-01) then ( "Umsatz Plan 2007" * 8/ 100)else( if ( "Datum" = 2007-02-01) then ( "Umsatz Plan 2007" * 78/ 1000) else ( if ( "Datum" =2007-03-01) then ( (...

Halo, I have try it but it doesnt works. Is there a problem with the else if´s or maybe with the Date? Or with the () is there a problem? I will try a new expression. Thanks for your Help

Halo mfgf, Thanks for the Tip- I will try it now. Thanks both of you.

Halo drlex and thanks for the fast answer! Both are decimal points. I have tried it with a (.) point and with comma (,). Both doesnt work..

Halo, I want to create a new Column and I use this Query Defination: if ( "Datum" = 2007-01-01) then ( "Umsatz Plan 2007" * 8/ 100 ) else if ( "Datum" = 2007-02-01) then ( "Umsatz Plan 2007" *7,8 / 100)else if ( "Datum" = 2007-03-01) then ( ( "Umsatz Plan 2007" * 9,1/ 100) / 22*...