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, identify potential and grow this 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

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…)

Posted in SAP Business Objects, SQL Server, XI 4.0, XI Migration
2 Comments »

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…)

Posted in Oracle Database, SQL Server
1 Comment »