Search
BWFreak - Journey to the center of Business Intelligence

Archive for June, 2009

CUBE_SAMPLE_CREATE

Posted on June 25th, 2009

This program allows you to be really lazy if you want to have some sample records in a InfoCube. No need to use flat files, edit the value in a ALV-Grid or let the system generates random values for you. It works only on InfoCube, not ODS. Works for BW3.5 and BI7.0
The records are added to the cube [...]

Check sm37, jobs are “Cancelled”
All jobs scheduled in DB13 terminated during the initialization phase.
Check sm21

TemSe input/output to unopened file
Error 28 for write/read access to a file. File = /usr/sap/[SID]/SYS/global/

Check filesystem /usr/sap/[SID]/. There are still some space left, but can’t create new files using “cat > filename”, which indicates that I am running out of inodes.
Looks like [...]

Last Saturday, I went to a birthday party of the son of an Indian friend. There were refreshments, alcohol, a dinner buffet, Punjabi dances, games for kids, dance music for the guests, in the end, everybody went to the dance floor. At the background, there was the slide show of pictures of the family on [...]

I need to load 2 years’ data into one ODS. I’ve done it before, and I know to avoid:

Loading all in one infoPackage — if anything’s wrong, I need to re-do the whole thing.
Loading all and active at the end — Use a lot of temp space when activate, so I have to keep monitoring [...]

Excel dashboard

Posted on June 6th, 2009

Less than a year ago, a pretty smart developer told a group of us, self-absorbed Unix, database admin, java/web developers, “I am learning Excel, it is very powerful, “. We had a good laugh about him. Ironically, I got his point now. A well-designed Excel dashboard can give BW a huge face lift in front of the executives and [...]

Activate Business Content DataSources

Posted on June 1st, 2009

Sometimes, it’s easier to use existing Business Content DataSources, espeically for master data text or attribute.  
SBIW -> DataTransfer to SAP Business Information Warehouse -> Business Content DataSources -> Transfer Business Content DataSources -> Find the name of the DataSource name -> Activate DataSources
To find a standard dataSource, click on the top node: SAP -> Expend -> [...]