Recent content by umag

I would assume that you have date prompt for this report. Then you filter out the data till last year based on the prompt date and follow logic given by Double D. One query with embedded logic at column level. or else you can have list queries for each data set i.e ytd, qtd and last year...

Hi Swereyng From my experience the BI development varies from organization to organization. Depends on the budget the entire BI solution can be implemented by 2or 3 resources or can be done as a group consist of Business Analyst, Systems Analyst, DB Designer, ETL designer/developer, Security...

Hi Ronche There is no function which will return working days from month. You need to create a table in database with marking the working days and use it for reporting needs. This table can be populated well in advance for whole year if the company schedule is known in upfront which is the...

you are right stacybost upto creating conditional variable. after that selects a conditional variable value 1 and select the report column you want to hide and on properties to your left hand side select box type to none and this will do. please let me know if you don't understand anything...

Hi Cindyw It's all depends on how your organization functions. At some places everything will be done a single person or 2 if the organization is small and can't afford more people. In contrast if the org is moderate/big and have lot user base there will be a demarkation between development...

mjcotter consider the solution of having text prompt, date prompt. for example your prompt1, prompt2, prompt3 are like Prompt1 = Date 1 (inactive_date) Prompt2 = Date 2 (active_date) Prompt3 = Date 3 (effective_date) you can create 2 prompts with one as text prompt with 3 defined values to...

Hi I am trying to explore different option available for my question. I have a report which runs every month on a scheduled time and saves the output into pdf and excel formats. This report has page break on primary item say company name. The pdf format is fine as I am giving page break on...

Hi Gurus I have a question. I have a table which stores data like this. I receive entry for the same loan with all information same with latest effdt. loannum acctnum dbt_crt_cd amount effdt 300015360 132206 10 110500.00 08/22/2003 300015360 176294...

Thanks MKW42 You are absolutely right and that solved my problem few days back but forgot to update here. But anyways you are observation is very good. Do you know if the udf is having argument type date or datetime how the function should be declared and defined. I have problems with this. when...

thanks for the reply. Here is what I was doing 1) In impfunct.ini, this is the entry for function name get_nxt_bus_day= and this is for function definition at the end of impfunct.ini file [get_nxt_bus_day] label=exp param=3 return=DT 1=DT;date_exp 2=NM;numeric_exp 3=CH;string_exp...

Hi I want one database(informix) function to appear in impromptu to be used in preparing reports. It is not showing up. Can someone please tell me where am I doing wrong. I have done the following steps 1.created the function in informix database 2.added this function name and definition in...

Hi Can someone please tell me why I am experiancing this problem. I am preparing a cross tab report and including list frame sub report into it. I am done with the development and getting the result what I want but PROBLEM is when I am saving it as pdf IMP application is crashing meaning imp...

Hi Add the following line in your cer2.ini Impromptu Workspace 7.0=C:\Program Files\Cognos\cer2\bin\User Workspace as shown below will solve your problems [Cognos Locations] Impromptu 7.0=C:\Program Files\Cognos\cer2\bin Impromptu Workspace 7.0=C:\Program Files\Cognos\cer2\bin\User Workspace...

Thanks Dave I looked into the database and the type is float(I am using informix DB). Instead of that column if I selected other column with datatype is integer it is working fine. I don't understand why is this weird behaviour, if you know please help me understand that. But for the problem I...

Hi I am using ImpAdmin 7.0 with informix DB. I have a problem here with if statement in one of the field of my report. Calculated field definition in report look like this if (flag = 'S') then (loanamt) else (0) impromptu throwing error as 'corresponding types must be compatible in CASE expr'...