Welcome to the Oracle Analytics Community

Home› Anish Goswami› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Anish Goswami Rank 2 - Community Beginner

Comments

  • Hi Kiran, Response to query: 1. Step/Status you are looking for History or Step/Status of last CSW activity i.e. means Current Step/Status. We are looking for History step/status. 2. Last Activity is tracked using "Is Most Recent" in OBI but do you want to additionally check if the latest activity within 24 hrs. Most…
    in Building a BO subquery in SQL Comment by Anish Goswami May 6, 2016 9:30AM
  • Hi Kiran, Response to query: 1. Step/Status you are looking for History or Step/Status of last CSW activity i.e. means Current Step/Status. We are looking for History step/status. 2. Last Activity is tracked using "Is Most Recent" in OBI but do you want to additionally check if the latest activity within 24 hrs. Most…
    in Building a BO subquery in SQL Comment by Anish Goswami May 6, 2016 9:30AM
  • In this particular SubQuery is used for populating Most Recent Comment, date and user by. In OBI, we have used transaction tracking fields, as historical step/status was not populating data properly. Can you help me with particular sub query as well. 
    in Building a BO subquery in SQL Comment by Anish Goswami May 6, 2016 3:50AM
  • Hi Kiran, Thanks for the response, we use application tracking CSW step and status, when we are looking for all such transaction that has happened to particular submission. So this helps us in having historical data to be used in reports. If there is requirement for any current CSW step/ status we use Application Current…
    in Building a BO subquery in SQL Comment by Anish Goswami May 6, 2016 3:40AM