Skip to Content
avatar image
Former Member

Create dimension using arithmetics operations

Hi Experts


Im using BO Information design tool, then I need to create a dimension of age based on the employee's date of birth. Any idea how?


thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 15, 2015 at 08:46 PM

    For create universe somebody knows if is it  importan type database?, conection is ECC, its not other source like mysql, access, etc.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I'm beginning to understand that the problem is the type of database that I select. The reason is that when SAP R / 3 realease 4 The SQL editor displays only me I have that database. It is correct?

      CONEXIONDB.png (39.5 kB)
  • Oct 15, 2015 at 04:57 PM

    Hi,

    You can do in multiple ways.

    subtract the date of birth from current date based on the years.You will get the age in years.

    year(curDate())-year(@catalog('Dummy')."PUBLIC"."Table"."DOB")

    or findĀ  out the number of days difference between two dates and divide by 365.

    Amit

    Add comment
    10|10000 characters needed characters exceeded