March 16, 2009
Ran process chains from Cronacle (Redwood explorer).
Most of the time, everything’s fine. Occationally, I got the following errors:
ORA-20800: JCS-02138: problem with parameter “I_SYNCHRONOUS”
 ORA-01008: not all variables bound
When it happens, the step fails inside Cronacle.
One possible cause is the job I am using didn’t set the value of “I_SYNCHRONOUS” and “I_STIMULATE”.
I Found the value of [...]

BW Admin, BW Unsolved issues, SAP BW | No Comments »

Several transports caused some issue on an existing ODS with data. The ODS couldn’t be activated, then after reversed some changes, activation is ok, but couldn’t load.
The error is:
No PSA for Info Source 8Azzzzzz 
It’s an issue with Data Mart transfer structure
Looking at InfoSource, all infoPackages and Source system were inactivated.
Changed table- transfer structure name according [...]

BW Admin, BW Modeling, BW Unsolved issues, SAP BW | No Comments »

My company recently purchased Xcelsius. So, I got a chance to play with SAP Business Objects, including Universe, Webi, Live Office, Xcelsius, Polestar, mobile application, Crystal Report, etc, etc.
I need some time to get to know the functionality of these new tools. When I am able to create some fancy schmancy Xcelsius dashboard in 5 [...]

BW Reporting, BW Unsolved issues, SAP BW | No Comments »

I almost jumped up when I heard the word “BI” from our newly appointed IT lead (CTO, CIO, Senior Excutive of IT, whatever the title). Then, a slide, a pyramid with Data Warehouse in the middle and Business Intelligence at the top…… His introduction speech  turned into a BI awareness session.
This is unusual. I haven’t heard BW/BI mentioned [...]

BW Unsolved issues, Life living, SAP BW | No Comments »

I started to create aggregates on several big cubes about a year ago, and since then, I’ve been really fond of this technology. I didn’t spend much time on it and make the query run-time acceptable.
However, it finally threw me off-guard.
Last Thursday, I found out a huge cube wasn’t all compressed. So I did the compression. I thought it’s totally harmless, [...]

BW Admin, BW Unsolved issues, BW performance, SAP BW | No Comments »

Edit an infoPacage, in Data Selection tab, select an infoObj of “Date” type, click on the round selection button, usually, the calendar pops up, but not for Data Mart (of the same BW system). 
Message no. RSAOLTP150
No solution on this issue so far.

BW Modeling, BW Unsolved issues, SAP BW | No Comments »