|
|
-
|
|
Concatenating row values (within groups) into column in SSRS and TSQL Concatenating row values into column is a never ending topic for report developers. It should be a simple task. That is, if the rows are not within groups. If the rows you are about ...
|
|
-
|
|
For the purpose of this blog, my answer is 4. I’ve always wanted to do a benchmark comparison so I can proudly say that my “normal” way is the best in terms of run time. STAGE-TSQL: Use the data flow to bring the raw data into staging, and us...
|
|
-
|
|
In SSRS, we often have another challenge. That is to control the column name. Continuing from MDX #16 – Attribute [Month Name] Is Invisible. With this MDX query, we got two columns back from the Query Designer in SSRS. The column [Month Name] represen...
|
|
-
|
|
In SSRS user-defined hierarchy Calendar returns the entire hierarchy Continuing from my previous post, MDX #15 – Why do I get Year, Semester, Quarter when I only need Month?. The above query gave me the months and each month’s sales amount in SSMS, ...
|
|
-
|
|
User-defined hierarchies define one-to-many relationships between attributes in a dimension, and these relationships tell the MDX engine how to roll up measure values. User-defined hierarchies in Microsoft SQL Server Analysis Services define the attrib...
|
|
-
|
|
Descendants() function gives me the exact level in the Date hierarchy in SSMS In MDX #14, I used this query to get the internet sales amount for each month. The results above are from SSMS, and they are what I was expecting. In SSRS, the same MDX q...
|
|
-
|
|
In a previous post, MDX #11 – How to get number of cars each customer owned using Properties() function?, I used the Properties() function to get the number of cars each customer owned. There must be another way Is that the only way? We (programmers/d...
|
|
-
|
|
Continue from my previous blog, MDX #11 – How to get number of cars each customer owned using Properties() function?. Without the TYPED flag, Employee ID is no longer a number, but a text field in Excel A couple of months ago, I completed a small proj...
|
|
-
|
|
In the Adventure Works cube, this is a simple query to get just 10 customers and their Internet Sales Amount. Dimensions can have many attributes (or attribute hierarchies) and user hierarchies The Customer dimension has many attributes (or attribu...
|
|
-
|
|
I worked on a SSIS package a few months back to retrieve data from a SSAS cube with MDX queries. A co-worker recently is developing a SSIS package to perform a similar task, but couldn’t get the SSIS package to work. The data flow was lost somewhere and...
|
|