Search results for query: *

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

Thanks CognosChicago! It's really helpfull! Yet I know how I can create this categories. I was a little confused with the substring command. Yet I know how I can use it. I have tried this and I have explore many others possibilities. I copy that command from you and work with this in the...

Halo Cognos Chicago again! Sorry to bother you but I am a bit confused and helpless. Can you maybe help me again? I have this data: 59012-imo Markt Gesmbh 59023-Praktiker 59089-Praktiker 59067-Praktiker Hagen 60789-BMW etc. The first Level that I have are the Businnes Levels (they are in...

Thanks again CognosChicago, you are already an expert in this and any information is really helpfull for someone newbie like me. Thanks again and I will try my best!!!! Julia :-)

Thank you CognosChicago, its really a great Idea. I will make that. thanks a lot again :-)You are REALLY great!!!!

Hallo CognosChicago, yes I am trying to create a level above this information in a dimension in transformer. I have already created a New Dimension and then a new BMW level in the Diagram view. I have import the data and it works. My Question is if I can create a New level that categorizes the...