Monthly Archives: February 2014

Performance Tuning of SAP BI CUBE:

OLAP CACHE Use TCODE: RSRT Search for Query. New Window will open, Click on “Favorites” Select Query and Click “OK” Click on “Properties” Make sure Cache Mode enable. Also, based on requirement choose setting from 1 to 4. BI ACCELERATOR

Posted in SAP, SAP BI

Lock/Unlock TCODE in R/3 or ECC 6

Login to R/3 or ECC system Use TCODE: SM01 Suppose we want to lock VA01 Search TCODE: VA01 Lock VA01 by placing the cursor on TCODE VA01 and click on “Lock/Unlock” TCODE VA01 locked as shown below Now Execute TCODE

Posted in ECC 6, SAP

Webi Report filter disabled in BI Launch pad

Issue: I developed simple webi report and published to the public folder. User has “View on demand” permission but when I run that report I found that report filter become disabled. Task: How to enable Report filter for “View on

Posted in SAP BusinessObjects

Calculate Last Year (WTD, MTD & YTD) based on Adventure Works DW 2008 R2

Prerequisites: Download Adventure Works Databases – 2012, 2008R2 and 2008 (in my case I used 2008 R2) http://msftdbprodsamples.codeplex.com/releases/view/93587 Download AdventureWorksDW2008R2 cube for SSAS 2008 R2 http://msftdbprodsamples.codeplex.com/downloads/get/461461 Changes: After implementation of Last Year (WTD, MTD & YTD) when verifying the data

Posted in SQL BI