|
|
-
|
|
Continuing from MS BI Workshop #3 – Create one VS Solution for all MS BI Projects.
Here is my notes #4.
I guess I am pretty obsessed with being productive in all the tools I use, more than average BI developers. It explains why I’ve paid so much attention to any tips I could get to use......
|
|
-
|
|
Continuing from MS BI Workshop #2 – Scrum for DW/BI developer….
Here is my notes #3.
Just as a couple of my blogs that are all about being productive in tool we use everyday SSMS, this notes is about another tool we use everyday, BIDS (Business Intelligence Development Studio).
We al......
|
|
-
|
|
Continuing from MS BI #1 – 3-day workshop at Tempe Arizona by Pragmatic Works.
This is my notes #2.
There are tons of information from the workshop, and each attendant must have taken very different notes, depending on their interest and experience.
Under “why data warehouse and busin......
|
|
-
|
|
A reader has created a Data driven subscription for a RS report with file share option, and got “Done: 1 processed of 1 total; 1 errors.” error.
Here are the three steps I’d suggest to troubleshoot the problem.
Hi,
Data-driven subscription is a powerful RS tool for automating ou......
|
|
-
|
|
Here is the link to a short article Cramming for BI Jobs from Information Management (you might need subscription to read it).
According to the article, of the 125 colleges surveyed, only three had an analytics or BI undergraduate program, and 12 had those BI or analytics programs for graduate degr......
|
|
-
|
|
I recently attended a 3-day workshop at Microsoft’s office in Tempe, Arizona. The focus is MS BI stacks, specifically MS Analysis Services, and Denali and Azure. It is offered by Pragmatic Works.
I am very impressed by everything and will share with you some of the notes I took in the next fe......
|
|
-
|
|
In a previous blog, SQL #47 – Too many in-line comments totally destroy code readability, I made a point that all SQL developers need to have a consistent writing style to achieve high level of code readability.
Being productive in SQL Management Studio will be your first step to achieve this......
|
|
-
|
|
Hi,
I am making a couple assumptions from your question.
Goal
You’d like to have two parameters.
If users select CostCentre from the first parameter, you want to present users with a simple textbox for them to enter a number.
If users select CostCentreName from the first parameter, you ......
|
|
-
|
|
Hi,
This is what I gathered from your question.
Need a MDX query get the data in required format.
Here is the original question from a reader:
ON COLUMNS:
DimValidScenario (Hierarchy Level: Scenario) (Members: Base, Flatterner, Value and so on)
ON ROWS:
DimAccount (Hierarchy Level From......
|
|
-
|
|
Do you still remember the blue squiggly from my previous blog post, SSAS #23 – Implement dimensional hierarchy in SSAS 2008?
On the Hierarchies tab in the Dimension Designer, the blue squiggly says:
“Attribute relationships do not exist between one or more levels in this hierarchy. Thi......
|
|