Were hiring

Clariba Job Opportunities

Clariba as a BI leader consulting company strives to constantly improve and adapt to the changing market. This is why we recruit talented individuals, with potential to help us go further.

Read more about our career opportunities and submit your CV.

Clariba Blog

Welcome to the Clariba business intelligence blog. We invite you to read our posts related to SAP BusinessObjects, Data Management and other BI topics, written by our consultants. If you have questions or comments, please let us know.

Archive for the ‘SQL Server’ Category

How to configure SQL Server connectivity for WebI from SAP BusinessObjects BI4.0 in Linux

Sunday, February 10th, 2013

Nowadays we have noticed some of our customers are following the trend of open source products. Indeed, Linux is a great choice of operating system due to the fact it is totally compatible with SAP BusinessObjects BI 4 and it also help companies to cut costs.  However, Linux has retained the way the classical Unix operating system works and therefore everything is about rights and batch commands. Therefore an advanced Linux technical know-how is compulsory before getting into it.

The purpose of this blog entry is to share the issues we faced in one of our customers running SAP BusinessObjects BI4 SP4 in a Red Hat Enterprise Linux Server release 6.3 using MySQL 5.1.61 as the system database and how we solved them. (more…)

Migration from Deski R2 to Webi R4 with FreeHand SQL

Tuesday, September 27th, 2011

In this article I would like to write about our first migration from BOXIR2 to BOXIR4 in which we had to migrate the entire BO platform (Universes, Reports, Dashboards, Security…). This was quite a substantial migration.

Most of the reports that we had to convert were Deskis. We used two applications in order to migrate these objects: Report Conversion Tool (RCT) used for converting reports from Deski to Webi and Upgrade Managment Tool (UMT) which instead is used for moving objects from different environments. This should be an automatic and simple process, but we had encountered some difficulties when migrating Deskis that had FreeHand SQL embedded.

So we would like to move on to explaining the two solutions we worked on that have lead to a successful conversion.

(more…)

Weekly Reports: An inside look at the week format results in Oracle Database and SQL Server

Friday, August 20th, 2010

Weekly reports are usually requested by customers who want to follow their activity results by weeks running from Monday to Sunday. The most common way to collect weekly data is by grouping date ranges by their Week No. of the Year. 

As you will see in this post, when I started  investigating this topic I found some interesting information about the week format in both Oracle Database and SQL Server, which I hope will be useful to others using these tools.

(more…)

Twitter Updates

  • RT @SAPMENA: Visit #SAPMENA stand @Gitex to learn about latest innovation and network with our partners - Stand 57, Hall 6 #sapgitex htt ...
  • Final arrangements for #GITEX 2012 #Dubai! we are excited to be there next week with @EXXOVAworldwide, showcasing @MyBIMobile
  • Our lovely finance and admin manager Marije welcomed her firstborn into the world today! Welcome to the Clariba family baby Daniel! =)
Go to Clariba Twitter
SAP Gold Partner