Loading

SAP BW : Usefull tables for DSO (Data Store Object)

Listing of commonly used tables in SAP BI and to understand the way data is stored in the backend of SAP BI


ODS Object
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

SAP BW : Usefull Tables for Aggregates

Listing of commonly used tables in SAP BI and to understand the way data is stored in the backend of SAP BI


Aggregates
RSDDAGGRDIR
Directory of Aggregates
RSDDAGGRCOMP
Description of Aggregates
RSDDAGGRT
Text on Aggregates
RSDDAGGLT
Directory of the aggregates, texts

SAP BW : Usefull Tables for InfoCube

Listing of commonly used tables in SAP BI and to understand the way data is stored in the backend of SAP BI


InfoCube
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

SAP BO Dashboards (Xcelsius) Online Tutorials



New SAP BO Dashboards (Xcelsius) Online Tutorials available...
Great new page on SCN that offers free tutorials on SAP BO Dashboards (Xcelsius) .
SAP BusinessObjects Dashboards eLearning Catalog sdn.sap.com
SAP Community Network eLearning catalog for SAP BusinessObjects Dashboards. A complete list of free, online SAP tutorials.

SAP BW Interview Questions and Answers: 1

Q) I want to delete a BEx query that is in Production system through request. Is anyone aware about it?
A) Have you tried the RSZDELETE transaction?

Q) What are the five ASAP Methodologies?
A: Project plan, Business Blue print, Realization, Final preparation & Go-Live - support.
1. Project Preparation: In this phase, decision makers define clear project objectives and an efficient decision making process (i.e. Discussions with the client, like what are his needs and requirements etc.). Project managers will be involved in this phase (I guess). A Project Charter is issued and an implementation strategy is outlined in this phase.
2. Business Blueprint: It is a detailed documentation of your company's requirements. (i.e. what are the objects we need to develop are modified depending on the client's requirements).
3. Realization: In this only, the implementation of the project takes place (development of objects etc) and we are involved in the project from here only.
4. Final Preparation: Final preparation before going live i.e. testing, conducting pre-go-live, end user training etc. End user training is given that is in the client site you train them how to work with the new environment, as they are new to the technology.
5. Go-Live & support: The project has gone live and it is into production. The Project team will be supporting the end users.

Using Alerts in Xcelsius

Alerts are commonly used to call the attention of the user to a specific item or action that has reached some pre-established limits. These limits are often called targets, budgets, benchmarks, etc. and are a standard to which an item is compared. This video gives a quick demonstration of how to add Alerts to your Xcelsius components.

Creating a what if scenario analysis model in Xcelsius

This video shows how to create a simple what if scenario analysis model in Xcelsius

Build a Custom Dialog Box in Xcelsius

Creating multi-tab dashboards and presentations in Xcelsius

This video gives a quick overview of how to use the tab set component in Xcelsius to create multi-tab dashboards and presentations.

Using the repair mode of the hash solution

With the function for checking the LBWQ for structure changes (the hash solution), a termination is forced when the update report RMBWV3xx is run (xx = application number) if the structure of the data in the LBWQ does not correspond to the current ABAP Dictionary version.
This occurs when changes are made to extract structures of the LO Customizing Cockpit, even though data of the 'old' structure was contained in the extraction queue (LBWQ).

The subsequent actions must take place in a posting-free period. It is absolutely essential that new data does not arrive in LBWQ during repair mode.

Step 1:  Lock your users and ensure that no IDocs are imported and that no batch tasks are running, and so on.

Selectors in Xcelsius


The functionality of selector components lets you create a visualization with multiple selections. This video shows how to use a label based menu in Xcelsius.