SAC - get the path from the folder hierarchy in SAC

[igdulia]

Hi,

I want to have the "SAC usage (Stories) by Folders" report.

I found the same question, but didn't find the answer, maybe we have smth new now.

getting list of public folder content using SAC content usage Story | SAP Community

Perhaps you had the same task and found a solution?

I tried to use two models: ACTIVITY_LOG and SAP__SAC_USSAGE_FILES

But faced following issues:

1. I can't use blending of two models in the Optimize view mode Stories. Do we have any other possibility to have data from two models? I used classical view mode, but in this case, I also have a lot of restrictions.

2. Is it possible to show list of Stories in the folder, but to have the Name of folder as path, not just Parent folder. If I use hierarchy I get some records, but I need to have it in one record as

instead of:

I tried to use calculated Dimension, but as I understand I can't take Level of Hierarchy in formulas, right?

Like L1 + L2 + L3 ....?

Thank you.