0 Replies Latest reply on Nov 9, 2012 3:41 PM by Cameron-TheOttawaHospital

    OBIEE BMM - Day of Month calculation using obsolete function.

      I tried using the following expression as a logical column expression in the Business Model Mapping layer of my Repository.

      DAYOFMONTH(MAX(TIMESTAMPADD(SQL_TSI_DAY, 0, "Dim Date"."ddatDate")))

      When I ran a consistency check, I received a warning about using an obsolete function. I reverted to a different expression for the logical column. That alternative does not calculate the data correctly. To workaround the problem, I inserted the correct expression(above) in the desired column in Analytics. I'm able to get the proper calculations on my data.

      I've checked several OBIEE blogs but I'm looking for an expression that does this: DAYOFMONTH(MAX(TIMESTAMPADD(SQL_TSI_DAY, 0, "Dim Date"."ddatDate"))) but uses compliant functions that I can apply to the BMM layer.