Skip to Content

Help in Cognos report formula in Webi reports

Mar 08 at 04:00 AM


avatar image
Former Member


I am developing the cognos reports to webi and looking for help in writing the below formula. The backend database being used is Sql server.

I need help in writing the below formula in Webi using backend database as sql server.

maximum(if([Database View].[Suspense workflow_events].[status]='Posted') then (_add_hours([Database View].[Suspense workflow_events].[created_at], -5)) else (null) for [Database View].[Suspense workflow_events].[entity_number])

maximum(if([Database View].[Suspense workflow_events].[status]='Submitted')
then ([Database View].[User - Suspense Workflow Events].[User First Name]+' ' +[Database View].[User - Suspense Workflow Events].[User Last Name])
else (null) for [Database View].[Suspense workflow_events].[entity_number]) .

Appreciate your help and many thanks in advance.

10 |10000 characters needed characters left characters exceeded

can you please share the screenshot of data and bit more details on Cognos formula?

e.g. add_hours funcitonaility?

Former Member

Hi Amit,

I can achieve above requirement using Relative date formula in BO but there is other issue seeing problem with date format as described below.

VDays in WDO Suspense

=If([Release Events Number]<>"") Then DaysBetween(CurrentDate();[vAs of Date]) Else DaysBetween(CurrentDate();[Lines Of Interest From Date])

vAs of Date =ToDate([Suspense Events As Of Date];"DD/MM/YYYY")

And format of data for Suspense Events As Of Date = 2016-01-13

When I pull the report variable VDays in WDO Suspense throwing #Error due to date format conversion.

Could you please advise. Thanks

* Please Login or Register to Answer, Follow or Comment.

0 Answers