Ella Maschiach's BI Blog - All Comments

re: Creating Sum for a Group with Recursion in SSRS

Ella Maschiach — Thu, 02 Feb 2012 10:02:01 GMT

Hi Adam,

I tried to think about it, if you can use perhaps "scope" to define what you want. Unfortunately enough, I don't think you can create a sum just for the workers level. RS can only identify a jump in the level (and then a different sort of sum) when it identifies a parent. This is the only sort of sum available for this scenario. If you don't want to use recursion and just a regular grouping, you need some sort of flag to show the change in the level of the group.

All the best,

Ella

re: SQL Server 2012 Denali Release Date

Ella Maschiach — Fri, 27 Jan 2012 14:52:23 GMT

Hi Amin and Geri,

I'm looking forward to see it too :)

re: SQL Server 2012 Denali Release Date

גרי רשף — Thu, 26 Jan 2012 07:45:28 GMT

זה יוצא בפורים,

וליתר דיוק- במוצאי תענית אסתר..

re: SQL Server 2012 Denali Release Date

Amin — Thu, 26 Jan 2012 07:44:19 GMT

Hi Ella,

That is really interesting,

I am interested to see the changes in the MS BI Toolset

SSIS Balanced and Unbalanced Dimensions « Sladescross's Blog

SSIS Balanced and Unbalanced Dimensions « Sladescross's Blog — Sun, 22 Jan 2012 20:58:19 GMT

Pingback from SSIS Balanced and Unbalanced Dimensions « Sladescross's Blog

re: Creating Sum for a Group with Recursion in SSRS

Adam — Thu, 19 Jan 2012 14:27:08 GMT

Great article, very helpful for an SSRS n00b :)

One question: how can I get a recursive sum that only counts the children but not the parent?

You showed above how to get the sum for a manager AND all of those working under him, but how can I get it for only those working under him? Would I need to do some sort of subtotal?

Thanks!

re: Recursive Sum for a Group in a Matrix in SSRS

Ella Maschiach — Thu, 12 Jan 2012 15:25:28 GMT

Hi Jennette,

The report can drill just as deep as the Parent – Child (or any recursive hierarchy for that matter) can go. But you can only define one parent and one child. If what you have isn’t a recursive hierarchy but rather a basic hierarchy with 5 levels, use the usual report grouping.

All the best,

Ella

re: Recursive Sum for a Group in a Matrix in SSRS

jennette — Wed, 11 Jan 2012 16:40:21 GMT

hi, thanks for the post. it really helped me a lot. just a quick question, i tried the solution below but it seems it's only showing 2 levels? I have a data that drill down upto 5 levels. please help. thanks

re: Microsoft All UP BI Demo version 9.2

Ella Maschiach — Wed, 04 Jan 2012 07:55:50 GMT

Hi Tom,

I saw that there's already a 9.5 version that is more up to date. Try it here:

http://mssalesdemos.com/

Under the Catalog tab.

All the best,

Ella

re: Microsoft All UP BI Demo version 9.2

Tom — Tue, 03 Jan 2012 12:53:15 GMT

Does not work anymore - do you know current URL?

?????? ???????? ???????? SQL Server 2012 ? | BI and More

?????? ???????? ???????? SQL Server 2012 ? | BI and More — Wed, 28 Dec 2011 20:57:11 GMT

Pingback from ?????? ???????? ???????? SQL Server 2012 ? | BI and More

re: SQL Server 2012 Licensing Reviews and Views

Ella Maschiach — Tue, 27 Dec 2011 10:03:07 GMT

Hi Rimon,

Good to hear from you :)
I haven't seen anything more specific than the FAQ:

download.microsoft.com/.../SQLServer2012_EditionsLicensing_FAQ_Nov2011.pdf

Which doesn't really say any numbers.
I'm guessing it'll only be published in the release itself.

All the best,

Ella

re: SQL Server 2012 Licensing Reviews and Views

Rimon Hayat — Tue, 27 Dec 2011 08:21:12 GMT

Ella, Have you hear anything about the pricing SQL 2012 editions?

re: Using a filter on a calculated field in Report Builder

Ella Maschiach — Mon, 26 Dec 2011 09:17:01 GMT

I'm terribly sorry, but I can't say what's the reason. Please try your hand at the SSRS forum:

social.msdn.microsoft.com/.../threads

All the best,

Ella

re: Using a filter on a calculated field in Report Builder

rt — Wed, 21 Dec 2011 03:46:56 GMT

Hi,

I did a simple OLAP cube in SSAS 2008 and attached to reporting services. Created a data source and data model based on that cube. When I launch the report builder 3.0 and create a dataset with a filter, the query times out. Without filter ,it gives back the report in few seconds. Can you shed some light on why this is happening? And the memory used to almost 100% in the machine. I'm totally new to reporting services. Is attaching cubes to report server and let the power users use the report builder 3.0 a feasible design? Your help will be greatly appreciated.