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

Categories:

Reporting and BI

All responses (9)

Answers (2)

Verified answer

BK-08052110-0 9 on at

Like (0)

Report

table relations

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

Thank you

Balaji
Leah Ju Microsoft Employee on at

Like (0)

Report

table relations

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.
BK-08052110-0 9 on at

Like (0)

Report

table relations

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.
BK-08052110-0 9 on at

Like (0)

Report

table relations

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
Leah Ju Microsoft Employee on at

Like (0)

Report

table relations

Hi,

Do you have access to the power apps? Are all tables not visible, or just these?
BK-08052110-0 9 on at

Like (0)

Report

table relations

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
Leah Ju Microsoft Employee on at

Like (0)

Report

table relations

Hi，

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

Are you the system administrator?
BK-08052110-0 9 on at

Like (0)

Report

table relations

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
Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report

table relations

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