|
|
-
|
|
A reader asked me how to add grand totals a matrix (A Sample of Matrix in SSRS).
It’s actually pretty easy to accomplish that in both SSRS 2005 and 2008. I am going to show a few screen shots here.
Challenge
Suppose you have a very simple table with sales data for products sold from each st......
|
|
-
|
|
In my previous blog, SSRS & SSAS #63 – Stop SSRS 2008 MDX Query Designer from Overwriting Parameter Queries, I mentioned that you can manually remove the parameter default values in BIDS before you deploy your reports to your report server.
But what if you already “infected” y......
|
|
-
|
|
In a previous blog, SSRS & SSAS #61 – SSRS and SSAS Integration: how bad it is and
our hope with two types of data providers, I complained about how bad the integration
between Reporting Services and Analysis Services is.
Complain itself will not solve any issue. But......
|
|
-
|
|
The team I recently moved into had never had a data source created on their report server for an Analysis Services source.
A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data Source Type.
For credentials for connection, we correctly flagged &ldqu......
|
|
-
|
|
I am a SQL purist, meaning that I have vowed never to use cursors in T-SQL to loop
through rows record by record.
In SSIS package design, however, I have used the Foreach Loop Container very
often. I would not say that I have broken my vows though for the following reasons:
......
|
|
-
|
|
The Row Count transformation is a pretty straightforward transformation. It does
the following two things:
1. It counts rows as data passes through a data flow, and
2. it stores the final count in a variable. (Note that the variable is only populated
when the data flow ......
|
|
-
|
|
A few months ago, I had a post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube. If you have worked on creating SSRS reports accessing cubes for a little while, you already knew that my post really doesn’t help you much in terms of solving real problems in your work.
......
|
|
-
|
|
When I wrote the blog SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package, it was purely “inspired” by an ETL design I was working on during the day, and also an SSIS training piece I was reading from Pragmatic Works.
However, I was pleasantly surprised by some com......
|
|
-
|
|
I hope so far you are convinced that you need to learn at least one ETL tool in
order to stay competitive in the SQL/BI profession. I also hope that Microsoft SSIS
is your choice.
I’ve worked with two types of people with very different views on ETL tools.
One is ......
|
|
-
|
|
My blog has many practical tips and best pratices for SQL/BI developers,but I haven’t focused on interview questions for SQL/BI developers so far. This might change in the future. It’s been a challenge for many people to break into or stay competitive in the SQL/BI profession.
I am very......
|
|