Microsoft SQL Server Analysis Services
57 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by Edwin Ong
Scoop.it!

Faster Extraction & Loading by SSIS

Faster Extraction & Loading by SSIS | Microsoft SQL Server Analysis Services | Scoop.it
Best practices and innovative ideas to make SSIS package faster, simpler and more productive.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

SSIS: List of Transformations

SSIS: List of Transformations | Microsoft SQL Server Analysis Services | Scoop.it
Technical articles, content and resources for IT Professionals working in Microsoft technologies
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Snowflake Schema vs Star Schema - Difference and Comparison

What's the difference between Snowflake Schema and Star Schema? edit See Also calloc vs malloc Datawarehouse vs OLTP Git vs Mercurial edit References http://en.wikipedia.org/wiki/Snowflake_schema http://en.wikipedia.org/wiki/Star_schema...
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Richard Lees on BI: An Alternative to a physical Distinct Count Measure

Richard Lees on BI: An Alternative to a physical Distinct Count Measure | Microsoft SQL Server Analysis Services | Scoop.it
Edwin Ong's insight:

Distinct Count Measure

more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

MDX – Handling Division by zero or null | BI-Bloggers

Edwin Ong's insight:

MDX – Handling Division by zero or null

more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

MDX Properties Function - MDXpert.com

The Properties function returns either a string or a stongly-typed value for a member property.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

SSIS Derived Column Transformation Video SSIS 2012

This Video (and more) http://KatieAndEmil.com/y/592 Transformations http://KatieAndEmil.com/y/577 SSIS http://KatieAndEmil.com/y/77 Tutorials http://KatieAnd...
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

SQL Server Integration Services Data Flow Transformations Tips

Get up to speed on SQL Server Integration Services Data Flow Transformations with these valuable tips, tutorials, how-to's, scripts, and more perfect for SQL Server BI Professionals.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Overcoming OPENQUERY MDX Challenges | Tribal Labs

Overcoming OPENQUERY MDX Challenges | Tribal Labs | Microsoft SQL Server Analysis Services | Scoop.it
Details for a workaround for various problems encountered when using OPENQUERY with MDX.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Sorting of MDX Drillthrough rowsets

Is there any way...
Edwin Ong's insight:

No Sorting for Drillthrough MDX

more...
No comment yet.