Fusion Analytics Extensiblity Series: Case study-Semantic Model (Part 3 of 4)

Abhishek Bajpai - CEAL Team-Oracle

https://videohub.oracle.com/embed/secure/iframe/entryId/1_s1arrera/uiConfId/35965902

In this series, we will discuss the use case and showcase the steps to bring in the custom object (created in Oracle Fusion Application) into Fusion Analytics and model it for analytical reporting. This is a 4-part series. The current part covers the Semantic Model

Part 1- Use-Case Discussion.

Part 2- Data Augmentation

Part 3- Semantic Model Extension

Part 4- OOTB Security

This video is a continuation to the post

https://community.oracle.com/products/oracleanalytics/discussion/19575/fusion-analytics-extensibility-case-study-data-aug-part-2-of-4/p1?new=1

Abhishek Bajpai - CEAL Team-Oracle

First Part :

https://community.oracle.com/products/oracleanalytics/discussion/19571/fusion-analytics-extensibility-case-study-blending-fusion-app-custom-objects-with-fusion-analytics

Second Part :

https://community.oracle.com/products/oracleanalytics/discussion/19575/fusion-analytics-extensibility-case-study-data-aug-part-2-of-4/p1?new=1

Abhishek Bajpai - CEAL Team-Oracle

Last part :https://community.oracle.com/products/oracleanalytics/discussion/19589/faw-tech-talks-extensibility-implementing-security/p1?new=1

A Vidhan

https://community.oracle.com/products/oracleanalytics/discussion/comment/49128#Comment_49128

Hi @Abhishek Bajpai - CEAL Team-Oracle ,

I have completed the 3 out of 4 serial videos on the Fusion Analytics series. That was very informative even though some things were redesigned. Thanks for the hard work there.

My question is with Security part. As you can see, I could not see the OOTB security implementation part. Right now, I am in a FDI Project where Security Implementation is not aligned properly.

I am not able to use session variables there. Even the query is not running. Asked the Oracle SR Team - They are saying that FDI doesn't support Session Variables! That was a letdown.

We tried the other way using the Security Configuration/Assignments/Context's approach which was recommended by the Oracle SR Team. But there is not a single video or illustration on how to implement it or may be automate it using the new Security Assignments using a table in the ADW - You get the point here.

If there is any way that you can guide many of us regarding this security implementation; It will be very helpful to the community.

Regards,
A Vidhan Reddy