Useful+Links

Links utiles

Microsoft: [|Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP] [|DTS to SSIS Migration] [|How To Use the Analysis Services Processing Task in SSIS 2005] [|Download details: SQL Server 2005 Best Practices Analyzer] [|SQL Server Management Studio Keyboard Shortcuts] [|Microsoft SQL Server 2008: Fast Track Data Warehouse] [|RunningValue Function (Reporting Services)] [|Expressions (MDX)] [|Measures and Measure Groups in Microsoft Analysis Services: Part 2 | Packt Publishing Technical & IT Book and eBook Store] Concatenating Row Values in T-SQL Microsoft Garage Mouse without Borders [|A User Interface for VsDbCmd] [|Utility to export SQL code from your cube's DSV] [|Building dynamic OLAP data marts on-the-fly] [|Building a Dynamic OLAP Environment at #SQLbits8] [|Microsoft Access: an elegant solution to Data Warehouse metadata] [|Sparks from the Anvil] [|BI Tools - Continuous Integration] SSIS RowNumber Transformation SSIS File Watcher Task

Oracle [|Oracle Warehouse Builder (OWB) Weblog] [|List of Calculation Functions] [|Oracle – Returning a recordset from a stored procedure « Systems Engineering and RDBMS] [|Interaction Between PL/SQL and Oracle] [|How to use the oracle REF CURSOR] [|Oracle Financials: Key Tables: Financials] [|Intelligence out of GL Balances] [|Pivot and unpivot in Oracle 11g]

ODI [|Essbase data load] [|Automating Data load] [|More to life than this...: ODI Series – tips for improving essbase load times.] [|More to life than this...: ODI Series - Loading Essbase Metadata] [|More to life than this...: ODI Series - Essbase Outline Extractor] [|More to life than this...: ODI Series Part 1] [|Setting up and Installing an ODI Agent as a Background] [|Export – Import DWR to DWR having same Master Repository | ODI Experts] [|More to life than this...: ODI Series - Deleting planning members] [|ODI Series – Deleting essbase members part 1]

Hyperion [|Hyperion EPMS docs] [|Hyperion Planning security querys] [|Customize Hyperion Workspace logo]

MySQL [|MySQL :: MySQL 5.1 Reference Manual :: 11.5 String Functions]

Testing [|Introduction to UML 2 Deployment Diagrams] [|Downloads Test Center] [|Requirements Traceability Matrix Structure] [|Testing the Data Warehouse-Data Warehousing Tutorial] [|Software Test Planning]

Others [|Colors in hexadecimal] [|DNE Support - Deterministic Networks] [|15.2.Kimball vs Inmon. Ampliación de conceptos del Modelado Dimensional. « El Rincon del BI] [|MVA - Carreras] Instant SQL Formatter [|Input Director]: Control two or more PC with one mouse/keyboard [|Julian Date converter] [|The Kimball Approach]