SQL Server: Select Star From Cube
Select * from Cube (SQL? No, its MDX) Everybody knows that to query the data from an OLTP database, we use SQL. Similarly, to query the data from an OLAP …
SQL Server: Select Star From Cube Read MoreAuthor: Amit Karkhanis
Implementing Calculations in SSAS using MDX – Part 3
In this ending part of the tri series posts let’s check out the third option in the calculations tab which is “Script Commands”. Here, I am focusing on the SCOPE statement …
Implementing Calculations in SSAS using MDX – Part 3 Read MoreSQL Server: Adding Custom Reports in SQL Server 2005 Performance Dashboard
This article is an extension to the blog entry “SQL Server 2005 Performance Dashboard Reports” by Rakesh. In his blog, Rakesh introduces to you about an add-in which contains a set …
SQL Server: Adding Custom Reports in SQL Server 2005 Performance Dashboard Read MoreImplementing Calculations in SSAS using MDX – Part 2
In the Part I of this series we have seen how to create a calculated member using MDX expression. In this part, I am going to show the second option in …
Implementing Calculations in SSAS using MDX – Part 2 Read MoreImplementing Calculations in SSAS using MDX – Part1
Calculations in Analysis Services help to extend the cube capabilities to make the BI applications more powerful. A calculation is nothing but an MDX expression or script which is used to …
Implementing Calculations in SSAS using MDX – Part1 Read MoreUsing SQL Server Reporting Services to Manage Data
As everyone knows, SQL Server Reporting Services (SSRS) is a reporting tool like Crystal reports, the use of which is to design and deploy various kinds of reports. If I ask …
Using SQL Server Reporting Services to Manage Data Read MoreHow to handle dynamic column report in SSRS
Problem I want to have a cross-tab report in SSRS whose columns may very depending upon the parameter values. We will check how this can be designed in SSRS. Solution Consider …
How to handle dynamic column report in SSRS Read MoreSSAS Attribute Relationships Tab
SSAS 2008 dimension designer has introduced one more tab called “AttributeRelationships” to simplify the process of setting relationships between the attributes. This tab is used to add, modify or delete attribute …
SSAS Attribute Relationships Tab Read MoreKeyboard Shortcuts in SQL Server Management Studio
Hi Friends, Reading Amit Bansal’s tips on SQL Server Management Studio, I also remembered the old days when we used to do such small tweaking to automate some of the tasks …
Keyboard Shortcuts in SQL Server Management Studio Read MoreSQL Server – History of Business Intelligence (BI)
Since the past few years the word “BI” gained lots of importance. Many products got evolved and started supporting the various features of BI. The term has been defined by many …
SQL Server – History of Business Intelligence (BI) Read More