on 11-03-2012 12:31 PM
Dear All,
Is there any way to know in which SAP BW table the technical name, description, creation data of reports created using Bex Analyzer is stored?
Please help me with this.
Regards,
Rita
Hi Rita,
If you want to know such details,while you are opening a particular query, press properties button you will get the details.
You will find information about technical names and description about queries in the following tables. Directory of all reports (Table RSRREPDIR), Directory of the reporting component elements (Table RSZELTDIR) for workbooks and the connections to queries check Where- used list for reports in workbooks (Table RSRWORKBOOK) Titles of Excel Workbooks in InfoCatalog (Table RSRWBINDEXT).
Regards,
Prerna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Friends ,
we are doing SAP BI implementation project. business blueprint documents given cube/dso name and table description. how to find out technical name In ECC side.
Can please guide to me
regards
nuthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nuthan,
Your question is not very clear.
As per my understanding of your question,
you want to get the datasources for the infocubes/dso's given in the list. If this is what you are expecting then it would be challenging but possible. You have to design your BI infoproviders as per the datasources or based on the business requirement.
let me know are you using standard Cube's and DSO's in BI?
Regards,
Ashok
Hi Ashok ,
we are using standard cube and DSO's in BI ,we can find it datasource .but infoobject given only description , i unable to find out technical name
for example
description data type technical name
time period date nill
in calendar days
form/to
Material group char nill
i think you can understand my issue know clearly. please do needful to me
regards
nuthan
Hi,
You can find the infoobjects in BI content as per the description. You can install it if its not not installed.
If the infoobjects already installed then you can find them in Se11 and put the table name RSDIOBJ and execute it. Here also u can seach the infoobject name as per your description.
Regards,
Ashok
hi,
you can know all details from RSA1 -> Metadata Repository.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
RSZELTDIR | Directory of the reporting component elements |
RSZELTTXT | Texts of reporting component elements |
RSZELTXREF | Directory of query element references . To get a list of query elements built on that cube.filter by: OBJVERS = 'A', INFOCUBE= [stage:cubename] |
RSRREPDIR | Directory of all reports (Query GENUNIID) . To get all queries of a cube.filter by: OBJVERS = 'A', INFOCUBE= [stage:cubename] |
RSZCOMPDIR | Directory of reporting components. To get query change status (version, last changed by, owner) of a cube. |
RSZRANGE | Selection specification for an element |
RSZSELECT | Selection properties of an element |
RSZCOMPIC | Assignment reuseable component <-> InfoCube |
RSZELTPRIO | Priorities with element collisions |
RSZELTPROP | Element properties (settings) |
RSZELTATTR | Attribute selection per dimension element |
RSZCALC | Definition of a formula element |
RSZCEL | Query Designer: Directory of Cells |
RSZGLOBV | Global Variables in Reporting |
RSZCHANGES | Change history of reporting components |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.