Oracle BIP : Create First Data Model

[@akrutipathak6031]

Thank you Arun for creating very informative video, it is very helpful.

[@atarunraj]

Appreciate the feedback

[@larrysherrod]

Really liked this one. I'm working a lot with SCM data. I have to transpose what you show and figure out how to do it in SCM. Keep it up. Nice work.

[@atarunraj]

Awesome. Appreciate the feedback.

[@tanyachaulwar2188]

Thanks for sharing !!

[@atarunraj]

My pleasure!!

[@appajaganroyal]

way of presentation...👌👌

[@atarunraj]

Thanks a lot 😊

[@ashmabakr790]

Yes please hope after finishing BI Publisher, hope you create SQL tutorial please

[@atarunraj]

Ok. That can be done :)

[@vakeeshganeshar9623]

Hi Arun, really insightful and great presentation. Are you able to advice similar ap_invoices_all for accounts payable - how do I able to view the data sets for projects. Also is there are any Oracle resource available to find FSCM data sets for GL, projects etc. thank you again

[@atarunraj]

I will try to make a video using Projects as an example. Here are a few links that might be helpful for you. Financials Tables and Views: docs.oracle.com/en/cloud/saas/financials/22d/oedmf/index.html Project Management Tables and Views: docs.oracle.com/en/cloud/saas/project-management/22d/oedpp/index.html

[@vakeeshganeshar9623]

Thank you and that will be great. Looking forward to watch Projects BI publisher tutorial. Also thank you so much sharing these links. Are you planning to do a tutorial in SQL BI publisher. take care and thanks again for your amazing videos.

[@atarunraj]

@@vakeeshganeshar9623 are you looking for SQL tutorial?

[@vakeeshganeshar9623]

@@atarunraj . Thank you. If time permits form your end. Are you able to do bit more SQL queries in projects reports in BI publisher which you planning to do at some stage. Or is it possible for us to show how join two different subject areas to create BI publisher reports. For eg: GL and HCM. In GL - account numbers and dollar amount and in HCM showing employee data related to GL subject area. thank you again

[@atarunraj]

@@vakeeshganeshar9623 I dont work with HCM. I can definitely show you some examples of Projects Tables.

[@akrutipathak6031]

can we set agent for any report created from DM, or it is only for analysis ?

[@atarunraj]

Hey. Can you elaborate on your question? I am not sure I clearly understood it.

[@akrutipathak6031]

Good Morning, i have just created one report thru data model, and now i want that report to be as a schedule job every day to come in email to certain people - can i do that? would you please kindly show how to.

[@atarunraj]

Sure. That is something that I can cover in the upcoming videos.

[@akrutipathak6031]

@@atarunraj Thank you, i look forward to that. Appreciated vary much.