Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

Design Studio will not start up

Yesterday it happended a lot that my Design Studio would not start, the error log showed: !MESSAGE Problems occurred when invoking code from plug-in: “org.eclipse.e4.ui.workbench”. Even the logon screen for BO server did not come up. Solution to this is: … Continue reading

Filed under Design Studio, Miscelleneaous | Tagged | Leave a comment

Tableau: sets

If you use a parameter in a condition to create a set you can use the formula [Dimension]=[Parameter] only on the referenced dimension, if you reference a different dimension then you need a aggregate condition like MAX( IIF([Dimension]=[Parameter],1, 0) ) … Continue reading

Filed under Tableau | Tagged , , | Leave a comment

Tableau: Distance formula

Calculate distance between 2 geographical points (great-circle distance): [VAR] * ACOS ( SIN( RADIANS([Origin-Latitude]) ) * SIN( RADIANS([Destination-Latitude]) ) + COS( RADIANS([Origin-Latitude]) ) * COS( RADIANS([Destination-Latitude]) ) * COS( RADIANS([Destination-Longitude]) – RADIANS([Origin-Longitude]) ) ) [VAR]= 3959 for miles [VAR]= 6371 … Continue reading

Filed under Tableau | Tagged , , , , , | Leave a comment

Tableau: Polygon maps

In using polygon maps you need to add the polygon ID and grouping ID to details and the sequenced point ID to path in order to display your own custom group map. When you want to overlay a second axes … Continue reading

Filed under Tableau | Tagged , , , | 1 Comment

Tableau: filter to Keep up to current day or month of year

Calculated Field for “Keep up to current day of year”: DATEPART(‘dayofyear’, [Order Date])

Filed under Tableau | Tagged , , | Leave a comment

Tableau: Relative Date Filter over year change

In case you want to compare years when filtering on last x weeks and have the year comparison over the year change (week 53 and week 1), you can’t use a relative date calculated field filter as this method transforms … Continue reading

Filed under Miscelleneaous, Tableau | Tagged , , , , | Leave a comment