Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to create new filed using date column in obiee

Closed
81
Views
6
Comments
User_HQ9TE
User_HQ9TE Rank 3 - Community Apprentice

Hi,

How to create new fileds in obiee using exciting columns student,email,person,date is data is available.

so how to create email wise date data column and remaining also.

could you please let me know anyone

student

person

email

date

email_date

person_date

student_date

sd

ab

ae

19-06-2022

Thanks for advance.

Tagged:

Answers

  • User_HQ9TE
    User_HQ9TE Rank 3 - Community Apprentice
  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_HQ9TE - You need to update the table using alter command to add new columns and insert data in to it.

    Syntax is as below:

    ALTER TABLE table_name
      ADD column_name column_definition;
    

  • What date will be in the Email_Date, Person_Date and Student_Date?

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead

    @User_HQ9TE -You may try the below approach.

    In obiee edit formulae ,fx we see several functions.

    For date column ,use cast function to convert it as CHAR.

    Now pull another column and use concat function between person column and column where you had used cast function.

    Please see if this approach helps.

  • Harriet Huang-Oracle
    Harriet Huang-Oracle Rank 5 - Community Champion
    edited June 2024

    Hi @User_HQ9TE ,

    How to add those date columns depends on how you would use those columns and how the data would be populated. Would you please describe more details on the purpose to add those date columns and the data source for them?

  • Renuka Nuguru-Oracle
    Renuka Nuguru-Oracle Rank 5 - Community Champion

    Hi User_HQ9TE,

    Creating new column with email and date is easy, which has been explained above. Can you describe your requirement in simple and clear so that we can help accordingly. Layout the base column and the data in excel, and what you are expecting in new columns.

    Thanks,

    Renuka

This discussion has been closed.