Post reply

Cognos Query In SQL server

  • September 21, 2009 at 9:57 am

    #215502

    Dear All,

    I am using the Cognos generated query to create a View in SQL server 2005.The snapshot of the query is

    ((EXTRACT(DAY FROM T1."INVOICE_CREATION_DATE_IH" - T1."SERVICE_DATE_IH"))) AS 'CHARGE LAG',

    Can somebody help

  • September 21, 2009 at 11:19 am

    #1056394

    We may be able to help, but I'm unable to see from your post what you would like help with. Could you please clarrify?

  • September 21, 2009 at 2:31 pm

    #1056480

    I believe that the EXTRACT function is MDX language, that would work against a cube. Are you doing this against a SQL Server cube, or against the table?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply