Create Display Sub Folder for Tabular SSAS Measures

• by Jennifer-Salvo

• Salvo(z) SQL

If you have a SSAS tabular cube with a large number of measures in a particular measure group, you may...

2014-05-13

4,148 reads

Create Display Sub Folder for Tabular SSAS Measures

• by Jennifer-Salvo

• Salvo(z) SQL

If you have a SSAS tabular cube with a large number of measures in a particular measure group, you may want to group specific measures into display sub-folders.  Display...

2014-05-13

3 reads

MDX Root Function

• by Jennifer-Salvo

• Salvo(z) SQL

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here....

2014-01-08 (first published: 2014-01-05)

2,031 reads

SharePoint 2010 Excel Services and SSIS

• by Jennifer-Salvo

• Salvo(z) SQL

As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents,...

2014-01-07

1,860 reads

SharePoint 2010 Excel Services and SSIS

• by Jennifer-Salvo

• Salvo(z) SQL

As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents, gaining access to this data is an on-going challenge...

2014-01-07

2 reads

MDX Root Function

• by Jennifer-Salvo

• Salvo(z) SQL

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here. In the past, I have encountered scenarios where I...

2014-01-05

6 reads

MDX Implementing Logical AND On Members of the Same Hierarchy

• by Jennifer-Salvo

• Salvo(z) SQL

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In my prior blog post, I discussed...

2014-01-01 (first published: 2013-12-24)

1,789 reads

MDX Implementing Logical AND On Members of the Same Hierarchy

• by Jennifer-Salvo

• Salvo(z) SQL

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...

2013-12-24

2 reads

MDX Implementing Logical OR On Members of Different Hierarchies

• by Jennifer-Salvo

• Salvo(z) SQL

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook  by Tomislav Piasevoli
In MDX, when two or more members...

2013-12-19 (first published: 2013-12-15)

1,554 reads

MDX Implementing Logical OR On Members of Different Hierarchies

• by Jennifer-Salvo

• Salvo(z) SQL

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook  by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...

2013-12-15

5 reads