Tagged: cube

Want to find out which queries have been created on a dataprovider?

Being active on a global SAP BW roll-out, I’d to find out which queries had already been created on a dataprovider (DSO, Cube, MultiProvider,….) before creating new ones. As all roads lead to Rome, I’m herewith sharing the road I’d taken today. Execute transaction RSRT Within the ‘Menu bar’, select ‘Environment’ and...

More

Semantically partitioned object (SPO) wizard

A semantically partitioned object is an InfoProvider that consists of several InfoCubes or DataStore objects with the same structure. Semantic partitioning divides the InfoProvider into several small, equally sized units (partitions). SAP often uses the picture below the explain the SPO principle. As of BW 7.3, creating SPO based InfoProviders...

More

HANA requires new kind of cube: InMem Cube

As stated a couple of weeks ago in the InMeM DSO post, HANA requires a new kind of DSO. But not only a new DSO is available, of course also the cube will be presented.   As to be seen in the picture above: All dimensions (and the E table)...

More

Usefull (std. SAP) ABAP programs within a SAP BI environment

Listed below several “may come in handy” ABAP Programs (within a SAP BI environment) RSCDS_NULLELIM: Delete fact table rows where all Key Figure values are zero. See Note 619826. RSDG_CUBE_ACTIVATE: Activation of InfoCubes RSDG_CUBE_COPY: Make InfoCube Copies RSDG_CUBE_DELETE: Delete InfoCubes RSDG_DODS_REPAIR: Activation of all ODS Objects with Navigation Attributes RSDG_ODSO_ACTIVATE: Activation...

More

Find out which queries are created for a Infocube/Multiprovider

It’s ‘easy’ to find out which queries have been created “on top of” an infocube or multiprovider.–> Execute transaction RSA1 and press the “Metadata Repository” button (left bottom of the screen)–> Within the overview of all repository objects, click on multiprovider or infocube. See screengrab below–> A list of all...

More