BI Blogs

SAS EG 4.2 – I like it!

Source: Blogging about all things SAS [link]

So after playing with EG 4.2 for a few days in anger I have to say I like it. Things I like: The new folder structure that 9.2 Metadata introduced, works a treat in EG to save projects, files etc New layout is good, especially the window with folder view, server v

SAS 9.2 Migration – SAS Enterprise Guide (EG) 4.1 to 4.2 experiences

Source: Blogging about all things SAS [link]

So after converting a few EG project from SAS 9.1/EG 4.1 to SAS 9.2/EG 4.2 I have found a few interesting experiences. I have just posted my experience with the EG Migration Wizard

SAS 9.2 Migration – EG Migration Wizard not so wizzy

Source: Blogging about all things SAS [link]

There is a migration wizard delivered with Enterprise Guide 4,2 (9.2) that enables you to convert your EG projects automatically when you upgrade. It is a an exe file in your EG 4.2 directory. This wizard scans the selected EG projects and allows you to do a global replace of Se

Hotsos 2010 – A Training Day with Tanel Poder

Source: Weblog for the Amis technology corner [link]

My last day already, so I hereby leave you with some impressions from Tanel’s Training Day. Maybe until next year. If you also want to learn from him, then here’s your chance in Holland. M.

¿Cómo enfocar las métricas para Data Governance?

Source: Information Management [link]

March Madness: bias in the seeding process?

Source: The sascom magazine blog [link]

The NCAA Division I men's basketball tournament is big business and

Estudio del uso de Software Libre en España (universidades y centros I+D)

Source: Todo BI: Business Intelligence, Data Warehouse, CRM y mucho mas... [link]

How Lyza stole the show at TDWI Las Vegas

Source: datadoodle [link]

Lyzasoft wasn’t among the 38 exhibitors in TDWI’s Las Vegas exhibit hall. They sponsored no part of the lunch, and they hired no stage magician. But their buzz was the loudest I heard over the event’s five days. Others may have heard different buzz because buzz var

Moton Charts, I so want to build one

Source: Blogging about all things SAS [link]

I love these motion charts that Google delivers: http://www.google.com/publicdata/home Unfortunately Government clients in NZ can;t use them as it is against the rules to store this data externally. I know SAS JMP has this capability and you can export the motion charts a

Hotsos 2010 – Presenters, Presentations, Presenting

Source: Weblog for the Amis technology corner [link]

I never find it very easy to try to capture the atmosphere during a conference, the presenting part, the presentations or the discussions, for example, you could have with the presenters. Hotsos is such a cool and unique event were you have the opportunity, to listen but also to interact. The am

SAS 9.2 – Connecting to Eneterprise Miner 6.1

Source: Blogging about all things SAS [link]

When connecting to SAS Enterprise Miner 5.x on SAS 9.1.x you normally entered a connection string that was the EM servername followed by the port, with the standard port being :5199. With SAS Enterprise Miner 6.1 on SAS 9.2 the standard port changed to :6412 (for a Lev1 environment)

Multiple OBIEE Environments

Source: Rittman Mead Consulting [link]

For any large OBIEE project the normal set-up would involve having a development machine, a test machine, Production machines and some form of disaster recovery. These normally need to be on separate physical machines, mainly for access rights reason and of course the DR machines need to be

TechFuse 2010 – May 6 Bloomington, MN

Source: Dan English's BI Blog [link]

Are you ready for a full day of learning? Well you are in luck, coming up in a couple of months is the TechFuse 2010 event in Bloomington, MN. Plus this year my application to speak at the event was accepted, so even better. I have the only Business Intelligence related topic too, so I am

Google Public Data Explorer

Source: Chris Webb's BI Blog [link]

Google made yet another tentative step into the world of web-based BI with the launch of Public Data Explorer, a tool for analysing at least some of those public data sets that have been appearing thick and fast over the last year or so. Alt

Using DBMS Scheduler with OWB Mappings

Source: Oracle Warehouse Builder (OWB) Weblog [link]

Webinar para comparar MySQL vs Postgre

Source: Todo BI: Business Intelligence, Data Warehouse, CRM y mucho mas... [link]

Google Public Data

Source: Information Management [link]

Thoughts on Change Data Capture

Source: Rittman Mead Consulting [link]

In little over a month I will be in Las Vegas speaking at Collaborate 10. There is a lot of BI / DW talks this year and for the first time with BIWA Training Days branding. Rittma

Top 10 Hyperion Events of the Decade is Over

Source: Look Smarter Than You Are [link]

Frankly, I find it hard to believe I started this series 2-and-a-half months... and then managed to stick with it. Part of it is that I've been watching the readership of this bl

Unique business models, but common problems

Source: The sascom magazine blog [link]

Twenty-four sessions, twenty-four speakers, twenty-four different topics over just two days, and I didn’t just sit through the convention as a participant, no, I moderated the entire two day event as its Chairman.

Open Data Everywhere: Share Your Stories

Source: Oracle Warehouse Builder (OWB) Weblog [link]

Lean Manufacturing for BI Projects

Source: James Dixon's Blog [link]

Tendencias Business Intelligence del 2010 segun HP

Source: Todo BI: Business Intelligence, Data Warehouse, CRM y mucho mas... [link]

Take part in Howard Dresner’s ‘Wisdom of Crowds’ survey

Source: James Dixon's Blog [link]

One-shot Search in OBIEE

Source: Miky Schreiber's Blog - BI [link]

Our users had a weird requirement: They wanted to search all the columns in one action. We thought how to do it. In this post I'll describe the solution. Note that this solution is not good in terms of performance, but this is the best we've got. In every report (/answer/reque

Build up multi-role development environment in OWB

Source: Oracle Warehouse Builder (OWB) Weblog [link]

#1. Oracle Acquires Hyperion

Source: Look Smarter Than You Are [link]

Was there any doubt about number one? By far the most significant event of the last ten years if not the entire history of Hyperion was announced in March of 2007: Oracle was

Oracle BI EE 10.1.3.4.1 – Solutions – Puzzle 4

Source: Rittman Mead Consulting [link]

The 4th puzzle in this series was a reasonably simple one which basically demonstrates a capability that allows end users to bypass the security applied in the BI Server layer. There are 3 possible solutions for this Solution 1: Using Evaluate EVALUATE was intro

Buscando feedback de PAT 0.6

Source: Todo BI: Business Intelligence, Data Warehouse, CRM y mucho mas... [link]

Hotsos 2010 – About swag, the Oscars and other stuff

Source: Weblog for the Amis technology corner [link]

Its Sunday and its raining outside. The nice weather on Saturday (approx. sunny / 20 degrees Celsius) has gone. After a decent flight on Friday where I actually made it to switch in Houston from the international Continental flight, going through customs and pick the next one, a domestic Contine

PASSMN March 16, 2010 Monthly Meeting

Source: Dan English's BI Blog [link]

The next Minnesota SQL Server User Group meeting is coming up in a couple of weeks on Tuesday, March 16 from 3 to 5:30 at the local Microsoft office in Bloomington. This month we will be looking at common table expressions (CTEs) and database design and both sessions will be done by SQL Ser

YouTube - NoSQL

Source: OLAP/BI/IM stuff [link]

North Central District Microsoft BI User Group Q1 2010 Follow-up

Source: Dan English's BI Blog [link]

This past week was the first Microsoft BI User Group meeting in Minneapolis for the 2010 year, North Central District Microsoft BI User Group 2010 Q1 Meeting –

SAS Access – Who plays nicely with who(m)

Source: Blogging about all things SAS [link]

Just saw this post on Chris H’s blog here and I am replicating it so I can find it when I need it. (cause half my posts are there so I can find them when I need them) If y

SAS 9.2 Sample Install Plans

Source: Blogging about all things SAS [link]

When installing SAS 9.1.x from a software depot, you needed to have an Install Plan and the only people who could generate these were SAS employees. For SAS 9.2 there are now sample install plans available on the SAS site here:

xcelsius, twitter y el BI Social

Source: Todo BI: Business Intelligence, Data Warehouse, CRM y mucho mas... [link]

SAS Management Console 9.1.3 – Invalid Templates

Source: Blogging about all things SAS [link]

Its been a full on week what with the SAS 9.2 migration and a whole lot of other work happening on another project. Also this week I seem to have been shown a lot of tips and tricks I didn’t know you could do. One of them was found by Rob and passed on to me (thanks Rob).

RANK v DENSE_RANK v ROW_NUMBER

Source: oramoss oracle [link]

I was asked a question by one of my users about the difference between the RANK and ROW

Thoughts on how PowerPivot and SSAS could work together

Source: Chris Webb's BI Blog [link]

After yesterday’s stream of consciousness on how PowerPivot could be used in SSRS, here’s a follow-up post on how PowerPivot and ‘traditional’ SSAS could be integrated. Hold on, you say, surely that’s

Swissport swaps Hyperion for Pentaho

Source: James Dixon's Blog [link]