Home | Ciber
Knowledge page of Ciber Netherlands

Archive for February, 2009

SAP Supply Network Collaboration as one-stop-shop for external communication

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.

clip_image002

Read more

No comments

OBIEE Reporting on dateranges

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

image

 

Read more

No comments

OBIEE Making a distinct date prompt

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".

image

 

Read more

No comments

MSSQL using synonyms for remote connections

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

No comments

Cognos 8.4 verbinden met een SSAS cube

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

No comments

OBIEE "Selling" federated query’s

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

No comments