Home | Ciber
Knowledge page of Ciber Netherlands

Archive for January, 2009

OBIEE Creating a Yamazumi Graph

A Yamazumi chart is a stacked bar chart that shows the balance of cycle time workloads between a number of operators typically in an assembly line or work cell. The Yamazumi chart can be either for a single product or multi product assembly line. 
Yamazumi is a Japanese word that literally means to stack up.
Toyota uses Yamazumi work balance charts to visually present the work content of a series of tasks and facilitate work balancing and the isolation and elimination of non value added work content.

Read more

No comments

OBIEE rowbased calculations in a pivot table

One of the little known possibilities are the row based calculations in a pivot table. Let’s start with a simple report based on the sales sample RPD:

image

Read more

No comments

OBIEE Impersonate a user

If you want to check how a report or dashboard runs as a different user but you haven’t yet setup "ACT AS" functionality or you don’t know the password of the user, you can pass the &impersonate variable trought the URL. (If you are logging in as Administrator)

Change this URL to the one shown below:

Read more

1 comment

JavaScript LinkedList and HashMap

Lately I’ve been doing some JavaScript coding again and the lack of 2 simple but very useful functions like LinkedList and HashMap inspired me to write my own implementation.

Read more

2 comments

OBIEE Multiple connection pools

In an ideal world the OBIEE development team has his own unlimited hardware, a DBA, an ETL guy/girl, a data architect / repository builder, some reportbuilders who really know the tool, a dashboard designer with a good feeling for DTP and off course a project leader. All these functions should be full time available or at least in the same room and all the noses should be pointing in the same direction.

Read more

1 comment

Cellen in Excel leegmaken vanuit SSIS

Soms kan het handig zijn om in een Excel workbook een tabblad leeg te maken voordat nieuwe data geschreven wordt. Om de meta mappings in SSIS in stand te houden is het dan niet wenselijk om de header regel in de Excelsheet ook te verwijderen.

Read more

No comments

OBIEE Leap Year Challenge

Have a look at these tables of February 2008 and 2009: (remember 2008 was a "leap" year)

image image

 

Read more

No comments

Excel als bron in SSIS (SQL Server 2005):

Vanuit SSIS kan naar een tabblad in Excel data geschreven worden. Hierbij kleven een aantal voorwaarden aan dat tabblad.

In de connectie manager voor Excel bestanden kan aangegeven worden of er een hoofdregel is.

Read more

No comments

ISO weeknummering in SQL Server 2008

In SQL Server 2005 en daarvoor was het altijd lastig om van een datum het ISO weeknummer te krijgen. Via internet zijn er mooie functie te krijgen die dit oplossen, maar standaard bieden deze SQL Server versies hiervoor geen oplossing. In SQL Server 2008 is dat veranderd.

De functie DATEPART kent nu de optie ISOWW. Hiermee kan de ISO weeknummering door de database, zonder extra code, gegenereerd worden:

Read more

1 comment

Subversion 1.5

Today the de facto standard for (open source) versioning systems seems to be Subversion, but it wasn’t always like that. Up until a couple of years ago most projects were using CVS.

CVS has some limitations though. It didn’t version the moving or renaming of files or directories. In the world of Java where refactoring of software is common this is quite a big issue. Complete directory trees might move because of a single refactoring action. Clearly CVS wasn’t up to this.

Read more

No comments

Next Page »