Operational Report - How to filter by [current user]?

[Peter_ITA]

Hi SAP Marketing Community,

in Analytivcs and Report Galery, can we pre-configure an operational report to automatically filter by the current user?

Example:

• Robert opens the campaign performance report and gets all the campaigns he is responsible for (field "campaign owner" is filtered to roberts user)
• when Sarah opens the same report, she only gets the campaigns relevant for her - where she is campaign owner

Is there any chance to set such filters?

Thanks, Peter

[Abd_Am_K]

Hi ppfitzner,

1. This is a custom development. You will need to create the data source (Analytical Cube) based on I_MKT_CampaignSuccessCube
2. Here you will need to add a new parameter (P_System_User) using the System Default -> User
3. Then include all the necessary field you need in the report.
4. In the filter tab add a filter on the Campaign Owner field, with Value Type Parameter and the Value P_System_User
5. Now check and Publish

Next you will need to create a custom Query as mention in the Blog in the comment by Luis. This query when published should fulfil your use-case. If you would like to restrict the User from changing the User id, this you can achieve in SAP Analytics Cloud.

Thanks,

[Private_Member_467521]

Hi ppfitzner,

You can create a custom query and assign the user that you need to have access to that.

https://blogs.sap.com/2016/09/02/how-to-create-custom-analytical-queries-for-sap-s4hana-marketing-cl...

Also, keep an eye on SAC at it is set to be the future for C4C reporting. SAP continues to develop new functionality there...

Cheers,

Luis