getting list of public folder content using SAC content usage Story

[former_member646700]

Hi,

I'm trying to retrieve the list of stories/models from public folders in SAC using a sample story SAC content usage (provided by SAP).

I used a model SAP_SAC_USAGE_FILES and got the below. But I want to list the objects under these folders. Please help me with your inputs.

Note: I have an another model SAP_SAC_USAGE_Other_Objects. But it doesn't have parent id or folder and I'm not able to link that model with this by using parent folder or id.

Designer:

Thanks,

Nivetha

[mfoeken]

Hi Nivetha,

I believe that the export to CSV already means you get the flat representation exported. I guess you can eliminate rows by using filters in Excel.

Kind regards,

Martijn van Foeken | Interdobs

[former_member646700]

Thanks for the response Martijin 🙂

[mfoeken]

Hi Nivetha,

I do see some unexpected behaviour. When you drill to level x in the hierarchy of the object 'Parent Folder' you get a folder structure. However when you add 'Description', the full list of objects is repeated on each above node as well. This is clearly not what you want, right?

Kind regards,

Martijn van Foeken | Interdobs

[former_member646700]

Hi Martijin,

Yes. That is what I wanted exactly. I want to list all the objects under each public folders.

I can get the list now. But now, when I exported it into .csv file, the folder path is not showing properly and the hierarchy got copied into cells.

[former_member646700]

Can you help me with the flat representation than a hierarchy? Sorry. I'm not a developer and this is new for me.

[mfoeken]

Hi Nivetha,

The object 'Parent Folder' is a hierarchy. If you expand the hierarchy or select flat representation you would be able to get the folder path.

Kind regards,

Martijn van Foeken | Interdobs

[former_member646700]

Hi Martijin,

Thank you! I want to list the objects under that each parent folder I've shared in the screen shot.

But I'm not able to do so.

Thanks,

Nivetha

[mfoeken]

Hi Nivetha,

Can you be a bit more precise on your actual requirement? Do you mean the folder name in the first column and the stories/models in the second column? Perhaps you can add a screenshot or example how it should be displayed in the story?

Kind regards,

Martijn van Foeken | Interdobs

[former_member646700]

Hi Martijin,

I want a report in the below format.

I want to list all the objects (Models/stories/analytical application etc.,) and the owner,location,create date & last modified date. I'm able to fetch the objects list But I'm not able to get the folder path/location.

Object Name owner Folder Path/location create date Last modified date

Thanks,

Nivetha