on 01-30-2009 6:09 AM
Hello SDN Mates,
I have a doubt how to find the backend table of a cube or dso in BI?
Good day
Regards
Arun S
HI,
I think by backend you mean the tables which form the part of the cube and DSO??
for that you will have to understand how the cubes and DSOs are built.
just go to SE16 and put the cube name and give the star on both sides and press F4...it will give you all the dimnesion table and fact table names for the cube and similarly for DSO you will get the name of change log,new table and active table name.
Thanks
Ajeet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
GO to Active table of DSO..
There u will find the table name..
Put that table in SE16..
Hope that helps u..
Srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot ,mates.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
I've a table name /BIC/AZ2WC1AI040 and I need to locate the name of this DSO. I've tried using the tables RSDODSOTABL and RSDODSO. It is listing out the names of the DSOs but not the technical names. I've used Find all option also but could not get any thing from there.
Like BAPI_CUBE_GETDETAIL do we have any BAPI to get the details of a DSO from its activated technical name (/BIC/AZ2WC1AIO40 in this case).
Please advise.
Thank you.
Regards,
Pavan.
Hi Pawan,
The naming convention is made including the name of the DSO inside the table name, so in your case, the name of the DSO is "Z2WC1AI0" the first characters /BIC/A means that it is a customer defined DSO (if it were /BI0/A then it would be the bi content dso) and the last characters can be "00" or "40". ""00" refers to active table "40" refers to new data table.
Regards
Yasemin...
Hi,
ODS:
RSDODSO Directory of all ODS Objects
RSDODSOT Texts of all ODS Objects
RSDODSOIOBJ InfoObjects of ODS Objects
RSDODSOATRNAV Navigation Attributes for ODS Object
RSDODSOTABL Directory of all ODS Object Tables
Cube:
RSDCUBE Directory of InfoCubes
RSDCUBET Texts on InfoCubes
RSDCUBEIOBJ Objects per InfoCube (where-used list)
RSDDIME Directory of Dimensions
RSDDIMET Texts on Dimensions
RSDDIMEIOBJ InfoObjects for each Dimension (Where-Used List)
RSDCUBEMULTI InfoCubes involved in a MultiCube
RSDICMULTIIOBJ MultiProvider: Selection/Identification of InfoObjects
RSDICHAPRO Characteristic Properties Specific to an InfoCube
RSDIKYFPRO Flag Properties Specific to an InfoCube
RSDICVALIOBJ InfoObjects of the Stock Validity Table for the InfoCube
Edited by: Surendra Reddy on Jan 30, 2009 10:33 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
You can always find the cube tables through Tcode LISTSCHEMA.
For DSO tables, you can search the tables name in either SE11/SE16 by giving <DSO technical name>
Hope this clarifies your doubt.
Srinivas.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
Open se16, and the following overview might help you to find any kind of object.
Regards, Birgit
InfoObjects: /BIC/P<IOBJNAME>master data table
/BIC/T<IOBJNAME> tests
/BIC/X<IOBJNAME> Navigation attr
/BIC/S<IOBJNAME> SID
/BIC/Q<IOBJNAME> time dependent
/BIC/M<IOBJNAME>all master data views
ODS /BIC/A<ODSNAME>00 acitvated data
/BIC/A<ODSNAME>40 new request (nicht aktiviert)
/BIC/A<ODSNAME>50 Change Log
InfoCube /BIC/F<Infocubename> fact table
/BIC/E<Infocubename> komprimed fact table
/BIC/D<Infocubename>1 dimension table
/BIC/D<Infocubename>D dimension table
/BIC/D<Infocubename>T dimension table
/BIC/D<Infocubename>U dimension table
/BIC/D<Infocubename>P dimension table
PSA /BIC/B PSA-Tabelle
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
Go to SE16 and enter * CUBE_NAME/ODS_NAME * -> F4.
This will give u the dimension or fact table names for the cube.
For ODS it will give you the New,Active,Change Log tables.
Hope this helps.......
Regards,
Apeksha.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.