Adding a filter value within a DTP

It’s been a while (in fact: it’s been to long) since I’ve last posted a blog entry. The reason for this was that I’ve been working as a team-lead the last couple of months. Therefore I was more ‘occupied’ with leading a team, then I was with inventing/discovering great BI...

More

Exclude query to use BW Accelerator (BWA)

What’s in a name : High Performance Analytics(HPA) became Business Intelligence Accelerator(BIA) which became Business Warehouse Accelerator(BWA) which will, eventually, become Open Database Analytics(ODA). Anyway: After you’ve enabled a cube to be indexed/loaded to the BWA, all queries belonging to that cube will be executed via the BWA. You’re able...

More

Debug startroutine in BI 7.0

Within BI 3.x it was quite easy to debug your startroutine. Pressing the sequence F7 -> F6 -> F5 brought you directly to the startroutine (code). Within BI 7.0 the “F7->F6->F5” trick doesn’t work anymore. To debug a startroutine in BI 7.0, the following steps need to be executed: 1)...

More

Hierarchy on navigational attribute decreased query performance

A multiprovider, based upon 5 different infoproviders and 2 infoobjects, was causing a performance drain whenever a query was executed. Every query, based upon this multiprovider, contained a hierarchy on a navigational attribute of an infoobject.Eg. Infoobject A –> navigational attribute B –> Hierarchy C.To make sure that the hierarchy...

More

Making an added function module (to a function group) visible in SE80

After creating an (additional) function module within a function group, it wasn’t visible within SE80 after it was transported to another BW system.When displaying the function group, via transaction SE80 –> Function Group, the newly created function module WAS NOT visible, even though the import/transport ended without errors.The trick, to...

More