Row level data security for Local Subject area with auto caching or dataflow based saved dataset

Question

Can you please tell me how Row level data security works when Local Subject area with automatic caching or data flow based saved dataset is used in visualization.

* When we do it on live data or from a subject area directly in Fusion Data Intelligence, fusion application-based access group security is taken care in FDI so user can see only those opportunities what they have access to.
* But if I create a data set by joining subject areas and use automatic caching and a refresh schedule, and then sales users use visualization built using that dataset – how that row level data security is honoured?
* Same question if I create a data flow to pre process data into a file saved in Dataset storage / object storage and then create visualization from there ?

Rupak C · Answer

Thanks Hitesh

Hitesh Patel-Oracle · Answer

Hi Rupak,

If the local subject area (LSa) is built using the OOTB subject area, the row level security of OOTB SA will apply in LSA as well.

So, if the Sales Manager are seeing 10/20 oppties in CX - Oppty SA in FDI, you will also see the same in LSA built against the same SA.

Rupak C · Answer

Hi,

We are using CX - Opportunity and CX - Opportunity Revenue Line subject areas available in FDI to source data from the connected sales cloud instance.

my questions is -

if Sales Manager A can see 10 Oppties in Sales Cloud, he can see 10 oppties in FDI using CX - Opportunity SA by default.

if Sales Manager B can see 20 Oppties in Sales Cloud, he can see 20 oppties in FDI using CX - Opportunity SA by default.

as OOTB data secuity from fusion is covered. so far so good.

now, if i create a local subject area dataset using CX - Opportunity SA and use automatic caching and refresh that every 5 hours, the cache will contain

say 500 oppties (all oppties from the sales cloud system) i assume ?

if i create a visualization using that cached dataset and have sales manager A and Sales Manager B use those visualizations - how many oppties they will see

by default ?

all 500 Oppties or 10/20 respectively ?

Regards-

Rupak