Exporting RPD Application Roles/Groups to Excel (XLS/CSV)

3167249

The requirement is to export the Application groups/roles defined in the RPD to an Excel document. The "RPD DOCUMENTATION" utility can only be used to export the attributes present in Presentation, BMM and Physical layer along with their relations into a xls file. But I need to export all the application roles that are defined in the RPD to an excel file. I am using OBIEE 11g. Is there any way to do this ?

Gianni Ceresa

You maybe want to export them from the source of groups and application roles ...

The RPD display them, but application roles and groups come from weblogic.

There are scripts (WLST) allowing to export them and for some probably also in the UI you can manage to export some of them.

3167249

Thanks Gianni.

I will check and let you know in case I face any further problems.

3167249

One last thing. If I use the scripts (WLST), will that export the application roles into an excel file ?

Gianni Ceresa

Excel files are overrated (mainly because a binary proprietary format).

The script can definitely manage to get you a CSV-like file you can easily open with Excel.

What's the real need, the final target of that requirement?

3167249

The actual need is documentation for future references. Just need to store all the application roles along with their corresponding user in a spreadsheet which can be referenced when required.