Skip to Content
avatar image
Former Member

Help in Cognos report formula in Webi reports

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.

Add comment
10|10000 characters needed 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

  • Get RSS Feed

0 Answers