Skip to Content
avatar image
Former Member

Calculation Object in Universe

Hi Experts,

Need some inputs on creation of a Variable at universe Level.We have two tables Say A and B , B table is a calendar and holds daily date and a indicator that it was a Business day or not ,with value Y or N.

Table A will have a date say load date and a serial number of the product. We are looking to have the output as Serial Number ,load date , Previous Business day in one table in Webi.

Not getting how to achieve this , something's but not achieving this .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 05, 2016 at 01:25 PM

    Create a new object in the universe with the following SELECT text:

    (select max(daily_date)
       from b
      where b.daily_date < a.load_date
            and business_day = 'Y')
    Add comment
    10|10000 characters needed characters exceeded