Skip to main content
Kinetic Community

Business Objects Universe - Kinetic Request and Task

This page will help you determine which Kinetic Request and Kinetic Task forms can be used to build your Business Objects Universe.

Usage

Attached to this page are the following ERDs:

  1. KineticRequest_CustomerSubmission_ER_V4.png - Customer Submission Data (Base and Answers).
  2. KineticRequest_TaskEngine_ER.png - Task Engine data (data gathered and how long each Task took to complete).
  3. KineticRequest_ServiceItem_ER.png - Template Information (templates (or Kinetic forms) meta-data).
  4. KineticRequest_Task_Universe_ER.pdf - Request Information linked to Task for a Universe design.

For the creation of the Universe you will want to connect the Customers Answers (1) with the Template Information (3).  This connection will provide the specific details of the Request (Answers to specific Questions).

 

Example

As an example we will use an iPad Request Service item.

Note - In the table fields listed below the Database Names are listed on the 2nd line of the 1st row.

The Service Item Definition information would be (KS_SRV_SurveyTemplate):

 

Template

(Survey_Template_Name)

Template Id

(instanceId)

iPad Request KS0050563f776etP7LtgEO-vAAxgNx

 

The Base information would be (KS_SRV_CustomerSurvey_base) would be (connected to the Template information via GUID):

KS_SRV_SurveyTemplate.instanceId = KS_SRV_CustomerSurvey_base.Survey_Instance_ID

 

Request Number

(CustomerSurvey_ID)

When

(Create_Date)

Who

(First_Name + Last_Name)

Catalog

(Category)

Template

(Survey_Template_Name)

KSR000005 6/8/12 John Sundberg ACME iPad Request

 

The Answer information (KS_SRV_SurveyAnswer) would be (connected to the Base information via GUID):

KS_SRV_CustomerSurvey_base.instanceId = KS_SRV_SurveyAnswer.CustomerSurveyInstanceID

 

Request ID

(CustomerSurveyInstanceID)

Question ID

(Question_Instance_ID)

Answer

(Full_Answer)

KSR000005 q123456 White
KSR000005 q123457 ATT
KSR000005 q123458 I will be traveling
KSR000005 q123459 no

 

The Question information (KS_SRV_SurveyQuestion) would be (connected to Answer information via Question ID):

Note - You will need to get the template id of the request and then connect that to the Question ID.

KS_SRV_CustomerSurvey_base.Survey_Instance ID = KS_SRV_SurveyQuestion.SurveyInstanceID AND

KS_SRV_SurveyAnswer.Question_Instance ID = KS_SRV_SurveyQuestion.instanceId

 

Question ID

(instanceId)

Question

(Question)

q123456 What color iPad?
q123457 What telco carrier?
q123458 Business justification
q123459 Do you need a carrying case?

 

The Task Tree information (KS_TSK_Tree) would be (connected to the Base infromation via GUID):

KS_SRV_CustomerSurvey_base.Survey_Instance ID = KS_TSK_Tree.Association_ID

 

Name

(Name)

tree_id

(instanceId)

ipad_request_tree t0000022233

 

The Task Instance information (KS_TSK_Instance) would be (connected to the Base information via GUID):

KS_TSK_Tree.instanceId = KS_TSK_Instance.task_tree_instanceId AND

KS_SRV_CustomerSurvey_base.instanceId = KS_TSK_Instance.source_id

 

tree_id

(source_id)

task name

(task_name)

start

(Create_Date)

stop

(Modify_Date)

t0000022233 look_up_manager 2012-05-12 08:00:00z 2012-05-14 08:00:01z

 

By building a Business Objects Universe using these forms your users will be able to build reports that display data from Kinetic Request and Kinetic Task.