cancel
Showing results for 
Search instead for 
Did you mean: 

Help in Cognos report formula in Webi reports

former_member279151
Discoverer
0 Kudos

Hi,

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.

amitrathi239
Active Contributor
0 Kudos

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

e.g. add_hours funcitonaility?

former_member279151
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (0)