List of Inactive Cubes;ODS; and Multiproviders

[Former Member]

How to check for Inactive ODS ; Inactive Multiproviders and Inactive Cubes ; Is there a transaction or a way to look for it in Dev; QA and Production

[Former Member]

Hi,

I am new to BW 3.5 and I need to find out the list of Active ODS's used and the corresponding Data Source from which it gets data. Is there any transaction code to get this info together. Can anyone help me with this.

Thanks,

Tints

[Former Member]

Resolved

[Former Member]

Hi there,

Check these function modules in transaction se37:

BAPI_ODSO_GETLIST - Use it to get the list of all ODS. Just run with the objvers M - Modified, to get the inactives.

BAPI_CUBE_GETLIST - Use it to get the list of all InfoCubes and Multicubes. Just run with the status % for all types of Cubes and with objvers M - Modified, to get the inactives.

Diogo

Edited by: Diogo Ferreira on Sep 30, 2008 12:22 PM

[Former Member]

Hi Diogo

I am a Newby to BW - I run TC SE37 I get to a Screen ; " Attributes>Import>Export >Tables>Exception> Source Code

Please Advise on Steps

Regards

Donnavan

[Former Member]

Ok,

Do this:

go to transaction se37 you'll see a text box named "Function Module".

Now insert the name "BAPI_ODSO_GETLIST" in the text box and click on F8.

You'll see several names, one of them is "OBJVERS" which has the value "A". Change this value to "M". Press F8 again.

Now you'll see another name ODSOBJECTLIST with a string named "Result:". In front of it you have a table icon. Press this table icon and you'll see the list of all ODS that are Inactive.

Do exactly the same explained above but instead of the name BAPI_ODSO_GETLIST put the name BAPI_CUBE_GETLIST to see the cubes.

Diogo.

[Former Member]

Thanx a lot Diogo It really helped

What about Inactive InfoProviders

[Former Member]

Hi,

Just change the name of the function module like this:

go to transaction se37 you'll see a text box named "Function Module".

Now insert the name "BAPI_CUBE_GETLIST" in the text box and click on F8.

You'll see several names, one of them is "OBJVERS" which has the value "A". Change this value to "M". Press F8 again.

Now you'll see another name INFOCUBELIST

with a string named "Result:". In front of it you have a table icon. Press this table icon and you'll see the list of all InfoCubes and MultiCubes that are Inactive.

Diogo.

[Former Member]

Thank You Diogo

Last Question Please Advise what is meant by the following

INFOCUBE O TEXTLONG OBJ A INFOAREA

I guess everything that is marked with a X under the A is for Active

Please Advise if this is correct

Regards

Don

[Former Member]

Hi,

Smaller corrections...

Do what I explained before for the two function modules, i.e., BAPI_ODSO_GETLIST and BAPI_CUBE_GETLIST and do not change the value from "M" to "A", leave it in the current value "A".

The value "OBJ" determines the status of the Object (InfoCube, MultiCube or ODS), and if you have the value "ACT", it means you have the status "Active", if you have the value "INA" you have the status "Inactive" for that object.

Diogo.

[leticial_locatelli]

Hi, Don.

I know another way to see inactive objects.

Tansaction RSA1. From the menu bar...

Settings -> Select display options -> Only display restrictions -> all inactive objects.

I thing this should help to have a quick view of inactive objects.

Regards, Leticia

[Former Member]

Hello Leticia,

this unfortunatly works only for BW3.5. In BI 7 this filter is not available any more. I asked SAP if this is intended, and yes it is. They asked me to create a developement request, but I don't know if this is that usefull.

Kind regards,

Jürgen

[Former Member]

Hi

there is a standard program to find inactive object pls check RSUPGRCHECK program and select which objects you wants to check and run it.

[Former Member]

Thanx Mate

Please Advise on Transaction Code to Access Program