Experimenting with Yukon Analysis Services

re: Experimenting with Yukon Analysis Services

girish — Fri, 05 Mar 2004 04:07:00 GMT

I just recently got to use yukon beta and play around with it. the one-click cube feature is fantastic. Since i was born curious, Ive taken it upon myself to determine the algorithm behind such a feature.

Im starting with just trying to figure out how you would determine a fact table first - and then worry about dimensions later - but its difficult. Fun though.. but difficult.

Heres my initial cut.

POTENTIAL FACT TABLES
--------------------------------
1) Locate all Tables in database (one db only)
that have a foreign key constraint on them.
2) Locate all Tables that are alone and not connected to any other tables.

But using this formula and applying it with the northwind database gives me more fact tables than IntelliCube determines.

re: Experimenting with Yukon Analysis Services

Sam Loud — Thu, 11 Aug 2005 16:24:28 GMT

Hi Tim. I think I've hit those speedbumps too.

Can you tell me whether the June CTP of Yukon Analysis Services still has the 'unable to automatically form a time hierarchy from a datetime field' problem?

re: Experimenting with Yukon Analysis Services

Krakow flats — Thu, 09 Mar 2006 14:52:10 GMT

Krakow accommodation
http://hotels.krakow.pl