Recent content by devul

You should use now instead of todate since now is a database function. Secondly If your Up and Billable Date does not have time in it then you should make sure you convert the system date now to date only and then filter out those Up and Billable Dates that equal the current date

I started a new thread regarding the same problem not realizing that you had started one already. We are also facing the same problem and we need to go live starting next week with our upgrade. Could you let me know if you were able to solve this problem ASAP? my email is jdevulap@strong.com Thanks

Hello! We have an IWR report with prompts for a firm name and the filter select all rows that contain the firm name. In IWR 6.0 if the prompt for firm name is skipped (i.e. it is left null) the report would run perfectly. Now in series 7.0 it gives out an error saying that 'The following prompt...

Did you try incremental build? i.e. Add new data to an existing cube?

You can use the configuration Manager. Configuration Manager allows you to congigure all COGNOS products/components

Were you able to resolve this issue? I am curiuos since we are upgrading from 6.0 to 7.0 Thanks Jaya Devulapalli

You can have multiple versions of COGNOS products but not of the same product. i.e. you cannot have Impromptu version 6 and 7 installed and running on the same server. But you can have Impromptu 7.0 and Powerplay 6.1 on the same server

In the datasource properties from which the current period has to be set, select the source tab and check the 'sets the current period' option. In the time dimension properties clikc on the time tab and check the 'Automatically sets the current period' Hope this helps

Impromptu lets you edit the SQL. The disadvantage is once you do so then you will have to maintain the SQL yourself. Impromptu will not do it for you. The advantage is you can write any valid SQL which can be the 3 table join.