SAP BW .....all info @ one place
SAP BW relevant Information
Loading
Showing posts with label cube. Show all posts
Showing posts with label cube. Show all posts

Forum post in BI General: Re: Collapsed request in infocube-How to get delta back
https://forums.sdn.sap.com/thread.jspa?threadID=588063&messageID=4236057#4236057

Yes you are correct SVR,

We can not delete request once it is compressed. Selective deletion is not usefull in this case.

You can try following -- Be careful -- follow steps -- first try in Dev

If you know last requests generated todays delta in base/source ODS and those requests are available in PSA for reconstruction.... then...

1. Delete initialization from this source ODS to all 3 targets.
2. If requests are available for reconstruction, delete required requests from ODS.
3. Now initialize without data transfer from ODS to 3 targets(2cubes + 1ods).
4. Reconstruct deleted requests in Source ODS(it generated delta)
5. Pust delta to 3 targets.

Hope it helps
Srini

- - - - - - - - - - - - - - - - - - - - - -

Visit the SAP Developer Network at https://www.sdn.sap.com.

 

BI Data Modeling:
Business Content in SAP NetWeaver Business Intelligence ships with hundreds of InfoCubes and other data structures. To satisfy the demands of very demanding business communities, many of these structures are quite complex. The guidelines documents in this section describe the practices and recommendations used by SAP's internal Business Content developers to build these structures. As you build your own, you'll benefit from following their lead.

  1. Multi-Dimensional Modeling with SAP NetWeaver BI
  2. Modeling the Data Warehouse Layer with BI
  3. BI Data Modeling: MultiProviders and InfoSets
  4. Modeling Data Transformations in SAP NetWeaver Business Intelligence
  5. How to Routines within Transformations
Frontend Design:
  1. Frontend Design Guidelines - SAP BI in SAP NetWeaver 2004s (PDF 673KB)
  2. Frontend Design Guidelines - SAP BI in SAP NetWeaver 2004 (PDF 139KB)
  3. How to Create and Maintain User Interface Patterns for BI Content (PDF 6MB)
  4. Business Content - User Interface Patterns Guidelines (PDF 79KB)
  5. Download Package - the BI Template Wizard
  6. How to Calculate Balance Sheet Key Figures Using the Cell Editor in the BEx Query Designer (PDF 467KB)
  7. How to Add BI Reports to a Portal Page (PDF 2MB)
  8. How to Do Exception Broadcasting (PDF 490KB)
Source : BI Data Modeling and Frontend Design

 

BW Useful Programs

Posted In: , , , , , , , , , , , , . By Srinivas Neelam


RSIMPCURR
--
To Transfer Exchange Rates
RSIMPCUST -- To Transfer Global Settings from source system
RS_TRANSTRU_ACTIVATE_ALL -- To Activate Transfer Rules
-- Useful whenever we need to activate transfer rules in Quality or Production system after transports.

RSAU_UPDR_REACTIVATE_ALL -- To Activate Update Rules
SAP_CONVERT_TO_TRANSACTIONAL -- To change Basic Cube to Transactional Cube
RSAR_PSA_CLEANUP_DIRECTORY -- To Clean PSA and Change log
SAP_INFOCUBE_DESIGN --
To know statistics(Size) of Cubes
--
Useful to know the size of Fact Tables and Dimension Tables
RSSM_SET_REPAIR_FULL_FLAG --
To change request status from Full load to repair full
-- Useful to start delta loads, If full loads are already present in data target from same data source
RSDDS_AGGREGATES_MAINTAIN -- For Hierarchy/Attribute Change run
RSDDS_CHANGERUN_MONITOR -- To Check Change run Status

RSDG_ODSO_ACTIVATE -- To Activate ODS in background. very much useful when BEx reporting switched on.
RSDG_IOBJ_ACTIVATE -- To Activate Infoobjects(Mass Activation)
RSDG_MPRO_ACTIVATE -- To Activate MultiProviders
RSDG_CUBE_ACTIVATE -- Activation of InfoCubes
RS_COMSTRU_ACTIVATE_ALL -- Activate all inactive communication structures
RSCONN07 - SAP Connect Administration(System Status)
RSAOS_METADATA_UPLOAD_BATCH -- To replicate single datasource from Source(R/3)

RSDRD_DELETE_FACTS -- To delete data selectively from infoprovider(ODS or CUBE)
RSAR_LOGICAL_SYSTEMS_ACTIVATE -- Activate All SAP Source Systems (After BW Upgrade)
RSDS_DATASOURCE_ACTIVATE_ALL -- Activate All DataSources of a Log System
RSTCC_ACTIVATE_ADMIN_COCKPIT -- Perform all steps to activate the content for the BI Admin Cockpit
RSTCC_ACTIVATEADMINCOCKPIT_NEW -- Activate Content for the BI Admin Cockpit

 

How to Papers, related to BW direct download

Google
 

Recent Posts

SAP Jobs