table relations

(0) Share

Report

Posted on by BK-08052110-0

HI, Is any one knows relations between these below tables in Dynamic 365 Customer Service DB.

msdyn_ocliveworkitem
msdyn_ocliveworkitemcharacteristic
msdyn_ocliveworkitemsentiment

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi，

You can check these tables in the Power Apps.

msdyn_ocliveworkitem --Conversation(tracks the interaction between the agents and customer)
msdyn_ocliveworkitemcharacteristic --ConversationCharacteristic(Characteristic associated to Omnichannel conversation)
msdyn_ocliveworkitemsentiment --Conversation Sentiment(Stores the machine learning generated customer sentiment of the communication between the user and the customer)

Open one table, and check Relationships:

Conversation has one-to-many relationship with
Conversation Characteristic and
Conversation Sentiment.

The same steps check that there is no relationship between the last two tables.

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No
BK-08052110-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hi Leah, Thank you very much for your prompt response which is really helpful and it will save my time, but I am unable to see these tables in my power app, Do I need any special privileges to access these tables in power apps.

Thanks

Balaji

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi，

Select correct environment and make sure select 'All' option in Tables pane.

Are you the system administrator?

Was this reply helpful? Yes No
BK-08052110-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hi Leah, Do you mean system administrator for sql db?

I am not a system administrator, how do I access those tables into power app?

Thanks

Balaji

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you have access to the power apps? Are all tables not visible, or just these?

Was this reply helpful? Yes No
BK-08052110-0 9 on at

Like (0)

Report
Copy link

Link copied!

Hi, I have access to Power apps and not able to see any dynamic 365 customer related tables.

I am able to access these tables from SSMS.

Thanks

Balaji

Was this reply helpful? Yes No
BK-08052110-0 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you, Leah.

Finally, I am able to access the tables in power app and seeing relations between those tables. could you please clarify how to see behind fact table logic means combinations tables involved, I am not able see behind tables in fact tables in that model.

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi，

I'm glad you can now access these tables in the power app, can you tell us how this was done?

For the fact table, i noticed that you posted new question about it in the forum, we can discuss it there.

Was this reply helpful? Yes No
Verified answer

BK-08052110-0 9 on at

Like (0)

Report
Copy link

Link copied!

I was in wrong environment initially, that's why didn't show those tables.

Thank you

Balaji

Was this reply helpful? Yes No