Skip to Content
0

Calculation Object in Universe

Dec 05, 2016 at 07:12 AM

55

avatar image
Former Member

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 .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Joe Peters Dec 05, 2016 at 01:25 PM
0

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')
Share
10 |10000 characters needed characters left characters exceeded