cancel
Showing results for 
Search instead for 
Did you mean: 

DWC Data Flows based on views with DAC

paulvatter
Participant
951

Happy new year DWC community & SAP,

my customer noticed a behavior in a data flow which seems to be related to this remark in the SAP Help - Creating a Data Flow:

  • In your data flow, if a source view or an underlying view of the source view has data access controls applied to it, then no data is read from the view during the execution of the data flow. This results in incorrect data or no data in the output.

    For more information, see Securing Data with Data Access Controls.

Main idea was to create a snapshot history of a quite complex relational dataset view to see the development over time. One of the base views of the relational dataset has DAC applied and is used in several other views.

Question is now if there is any option to overrule this limitation besides removing the DAC (which leads to high effort in other places). Is there e.g. a dedicated execution user name of the data flow which could be added to the DAC with full authorization etc?

Thanks in advance and best regards

Paul

View Entire Topic
d_a_
Explorer
0 Kudos

Hello Hannes and Paul,

I have the same issue like Paul and try to solve it with like Hannes but it doesnt work.

Within the Dataflow in the source table I can preview the data but not in the target table. When I remove the DAC then it works.

@Paul: How did you solve you issue?

d_a_
Explorer
0 Kudos

Important to know:

I shared my view with DAC to another space and want to persist in a local table.

dob1
Participant

We had the same issue. The solution provided by Hannes helped us!

You can use the following SQL statement.

select * from workload_mappings where workload_mapping_name LIKE '%_SPACEDISUSER'

Then insert the user from column USER_NAME into your DAC control table. You have to pick the user of the SPACE where your Data Flow is running.