Search results for query: *

sln007 I accept to what you say but it again is just for the first letter.That wouldnt be of much use for the kind of data i am using. Neil

Hello All In Cognos,when we create a prompt,Is there a way in a pull down list we can type in the value so that it comes up rather than we pulling it down and choosing a value .Say if we have 500 values ,can the user type in the value in the prompt rather than go through the list of 500 and...

Can reports and catalogs developed in cognos 7.2 be opened in cognos 6 .I guess the answer is no. neil

Hello all How useful is essbase certification neil

hello all is it quite normal for a complex impromptu report to take 4 minutes neil

hello all I have a report for which i have to use a sum and group by function for a set of records. I get incorrect sum when i try to pull a data from a table which is connected to the previous table with a simple equi join.The error is so weird that i am not able to debugg.Any help Thanks Neil

Hello imp gurus I have a whole bunch of impromptu reports which all have 1 to 4 prompts.All of these prompts pull data from views.Because of this reason all of my reports take 15 seconds JUST TO BRING UP THE PROMPT.Is there any way this time can be reduced.Any suggestions. Thanks Neil

Hello all wish you all a very happy new year.I have problems with one of my reports not opening up for a particular data set.I ran the sql in an interepreter and it has 2 parts and both the parts run in less than 10 seconds for that data set but wouldnt open up in impromptu ,any suggestions neil

Hello everybody, Wish you all a very happy new year.I have designed some reports in cognos impromptu.I have a couple of reports which wouldnt open up or takes a long time(dont know how long) for a particular input value ,when i try to access data for a particular period.The dataset...

Einyel No good ,It did not do any good Thanks Neil

sakthi lu,acct,ytdamount,mtdamount

saikat No i am not using a powerplay report,i am using a impromptu report,any suggestions on it Thanks Neil

saikat I dont follow it.can you please explain Thanks Neil

Hello all Is there a way we can generate mtd amounts from ytd amounts,i know that we have to subtract from previous amounts ytd,but how to do it.any insight Thanks in advance Neil

hello impromptu gurus I have a very critical problem with all my cognos impromptu reports.All my reports open up very fast in impromptu but when i publish them on to portal,it takes ever to open up sometimes.This problem is not consistent.Sometimes I dont have any problems opening the report in...

Thanks kenzolia,dave griffin,mac Happy holidays and wish yu all a very happy new year

Hello all I am having a problem with the date format .I need to generate reports with date format mm/dd/yyyy using cognos impromptu.Impromptu does not seem to have a facility for this date format.Do anyone know how this format can be achieved. Thanks in advance Neil

griffindm I need to update a catalog after a new view or table is added to the database,i dont think cognos impromptu gives the new tables views to be selected for the old catalog . Neil

hello all I have a huge catalog,I have created some additional views in the database,but the table list doesnt show me the new views.Does anybody know the reason for this.How can i updated my catalog to include the new views in impromptu. Thanks in Advance Neil

Hello impromptu gurus Does impromptu have any inbuilt function which calculates the YTD from MTD? Thanks Neil