|
|
-
|
|
Let’s continue from my previous post, SSAS #22 – Dimensional Hierarchy Contained in a Single Dimensional Table (Star Schema).
I need to assume that you have done all the following so far:
Created an Analysis Services Project in BIDS
Created a Data Source to point to your star schema......
|
|
-
|
|
We have been building hierarchical structures in transactional/operational systems for years with technique such as normalization. What about hierarchical structures in an OLAP system? Experienced data mart/warehouse designers will tell you that they are different because the hierarchy for the dime......
|
|
-
|
|
RS Subscription seems to be a constant topic in my recent blog posts. I have summarized many different ways you can use RS Subscription, especially the Data-driven Subscription.
In this post, I’ll pass on a tip about using parameter @timestamp in a non-data-driven subscription to create a dyn......
|
|
-
|
|
I had several blog posts on how to manage your SSRS subscriptions. Here is a summary of the different ways I’ve been using Reporting Services out-of-box subscription features (no programming/expressions involved).
Simple, but mostly “static” way. You can find the New Subscriptio......
|
|
-
|
|
In my previous blog post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube, I blogged the out-of-box features in SSRS to create a report with parameters accessing an Analysis Services database.
5 report parameters were automatically created.
When I preview the report, the Y......
|
|
-
|
|
In the previous blog post, SSRS #50 – Using Parameters in SSRS (1), I listed 7 different ways you can use report parameters. They are also the skills that report developers need to master in order to develop interactive reports.
In this blog, I’ll show you some simple steps to use casca......
|
|
-
|
|
One of the readers asked me this question in Ask Sherry Li
Question
Dependent parameter in SSRS
How do I create a dependent parameter in SSRS? For example, select a Supervisor in the first drop down and then the Employees for that Supervisor appear in the second drop down.
Master Skills of Manip......
|
|
-
|
|
I am no SQL Server architect. Normally I don’t blog about topics like this. I volunteered recently, however, to create an end-to-end solution on the company’s new Microsoft 2008 BI platform.
After I migrated almost everything from the 2005 platform to 2008 platform, and ready to deploy ......
|
|
-
|
|
If you have developed a few SSRS reports in BIDs, you must have noticed that BIDs uses a data cache to speed up your development work. Your design-preview-design-preview cycle is fast enough that you probably have never complained . Not yet.
One of my reporting Services reports is still in developm......
|
|
-
|
|
Fact tables that involve employee productivity (which drives the Incentive program) are mostly transactional. The word transactional is not exactly accurate in our world. The granularity in many of data elements is per day, meaning that certain data elements will only store the last value from each ......
|
|