SAP BW backend tables for a Design Studio Application

[former_member225723]

Hi,

I m working on a design studio application. I need to get all the technical details of that application (like what are the data sources present in it, what charts are used and their types(line chart or pie chart) etc..

For Bex queries, all these type of technical details of a query are stored in SAP BW backend tables.

Likewise do we have any SAP BW backend tables that stores the details of all Design Studio applications that we create?

If not, kindly suggest whether there are any other ways to extract these info.

Thanx in advance.

Regards,

Mathan.

[MustafaBensan · Accepted solution]

Hi Mathan,

It sounds like you want to access the details of the application object hierarchy.  This is stored in XML format in the content.biapp file for the specific application.  You can find this file in the local repository by selecting the Application > Open Repository Folder menu in Design Studio.

If you want to programmatically access these files from the platform they are published to (BusinessObjects BI, NetWeaver or HANA), you will probably need to code a custom web application or equivalent to do so.

Regards,

Mustafa.

[former_member333283 · Accepted solution]

I found these tables containing DS application info

RSAOOBJ

RSAOOBJT

RSAOOBJXREF

[former_member225723 · Accepted solution]

Hi Mustafa,

Thanks for your answer..:)

But as you said, content.biapp file will get stored in the repository folder only when the application is created in Local mode.

In case of Netweaver mode applications, I hope the same content.biapp file will be getting stored in the corresponding repository. Searching that only..:)

Regards,

Mathan.

[former_member225723 · Accepted solution]

Hi Bjørn,

RSAOOBJ table contains the information of the file content.biapp, but I can't be able to find its entire content or access it.

Is there any way to access that file..?

Thanks & Regards,

Mathan.

[MustafaBensan · Accepted solution]

Hi Mathan,

What about the RSAO tables Bjørn has suggested above?

Regards,

Mustafa.

[former_member225723 · Accepted solution]

Hi Mustafa,

The table RSAOOBJ stores only details about the file (like file type, owner etc.,) and not its content.

But I need the content of that file..

Regards,

Mathan.

[MustafaBensan · Accepted solution]

Hi Mathan,

Thanks for the confirmation.  That's exactly what I was wondering about, the level of detail in the RSAOOBJ table.  Although I haven't checked myself, I would expect the content.biapp file (or equivalent) to be published to the NetWeaver repository when the DS application is published to the platform.  Have you tried to find it?

Regards,

Mustafa.

[former_member225723 · Accepted solution]

Hi Mustafa,

Thats what I am searching for, right now.

For the time being, I am downloading the application to local mode and geting the file..:)

Regards,

Mathan.

[Lutz2 · Accepted solution]

Hi Mathan,

did you already find a solution for reading the file content.biapp from table RSAOOBJ? I've already checked all classes starting with CL_RSAO_TLOGO* but didn' find a method which delivers the content in the original XML-format.

Regards

Lutz

[former_member333283 · Accepted solution]

Hi Lutz

I dropped the idea of getting the biapp file from the backend table. I found another way through design studio it self. In design studio I go to menu point Help-->Support-->Download Application

Don't know if this is usable for you.

Br

Bjørn

[former_member225723 · Accepted solution]

Hi Lutz,

I can't find out any backend table for reading biapp file.

The only way is to download the application locally and get the same file from Repository folder as of now.

BR,

Mathan Msd.

[Karol-K · Accepted solution]

Hi,

first, there is no official public api to read the content on ABAP server.

Why you actually need to make this?

on the technical side (as someone will find it anyway...)

The objects are stored in ABAP in non-string way. You can either activate RSTT trace or put a breakpoint in FM RSAO_BICS_OPEN and see the structure E_S_AO_ROOT_OBJ.

Element CONTENT is containing the biapp file, but this is an byte representation of the UTF8 string. In Java you would need to do:

String biapp = new String(content, UTF_8);

I have no clue how it is in ABAP.

Karol

[former_member333283]

I have the same request...any answers yet?

Regards

Bjørn

[TammyPowlas]

I am not really following this; if I create a Design Studio application using a BEx Query as a Data Source but deploying it on the BI Platform I wouldn't expect any Design Studio details to be stored back in BW.

But I would like to understand this request better - can more details be provided?

[former_member333283]

Hi Tammy

I can only answer for my side 🙂

We're using NW to deploy our applications and these are stored in the BW backend.

Therefore I was seeking any RS tables containing this information.

Br

Bjørn

[TammyPowlas]

Hi Bjørn,

Now I follow - thank you

We haven't deployed to NW; may try that on a sandbox sometime and see what happens.