on 09-30-2008 11:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.