Integration

Currently in rampup SAP’s supply network collaboration solution promises to deliver smooth integration possibilities with all parties in a supply chain. Whether you’re a supplier (subcontractor, 3PL, outsourced manufacturer) or customer, SNC offers you various connection options.

Read more

When your data is stored in ranges instead of individual events:

Read more

One of the question I get asked on regurlar basis is: "If have a timestamp column, how do I convert this in a date only prompt".

Read more

When using remote server connections in MSSQL they need to be in the format select * from [ServerName].[DatabaseName].[SchemaName].[TableName]. If you want to switch between two servers (say Production and Test) you only need to recreate the LinkedServer. The problem arises when the database and or schema name on the linked server is different. [ProductionData].[Pub] -> [TestData].[dbo]. This change would mean that you have to change every query which reference to the linked server.

A solution is using Synonyms instead. This means that you can use select * from [SynonymSchemaName].[Synonym] instead. The big advantage is that you can script the creating of synonyms, so a database connection switch can be done in seconds rather then hours.

Read more

Om COGNOS 8.4 te laten connecten met een SSAS cube. moet je een aantal zaken regelen. Begin met het in stalleren van SQL Server 2005 SP3 op de Cognos server.

Hierbij werd de SQL Native Client bijgewerkt alsmede de MSXML 6.0 installatie welke een prerequisite is voor de SSAS OLE DB 9.0 driver waarmee naar de cubes geconnect wordt.

Read more

One of the powerful features of OBIEE is the possibility of federated query’s. Sadly in most sales pitches we tend to emphases the technical part instead of the practical part. Every now and then there is a BI-manager in the audience who really knows his stuff and starts asking the wright/wrong questions. In this article I want to show you some of the pitfalls when trying to "sell" federated query’s.

Read more