-
I am back from vacation in Florida and I am all rested despite the intensive sun exposure and the appearance of some tar from the oil spill. I have scheduled the next two runs of my online training classes: Applied Reporting Services 2008 Online Training Class Date: June 28 - June 30, 2010 Time: Noon...
-
The other day I decided to spend some time and educate myself better on the subject of aggregations. Much to my surprise, no matter how hard I tried hitting different aggregations in the Internet Sales measure group of the Adventure Works cube, when I got the Get Data From Aggregation event in the SQL...
-
As Analysis Services users undoubtedly know, partitioning and aggregations are the two core tenants of a good Analysis Services data design. Or, at least they have been since its first release. The thing though is that a lot of things have changed since then. Disks and memory got faster and cheaper,...
-
There is still time to register for the online Applied Analysis Services 2008 class run on May 17th . No travel, no hotel expenses, just 100% content delivered right to your desktop! This intensive 3-day online class (14 training hours) teaches you the knowledge and skills to master Analysis Services...
-
The Analysis Services server parses the cube script on deploy and complains in case of missing dimension members. You can use the IsError() function to handle missing members, such as Iif(IsError([Account].[Accrual Basis].&[30/360]), null, ([Account].[Accrual Basis].&[30/360]). However, sometimes...
-
I have to admit that I am a performance buff. In a previous blog , I mentioned that the Xperf utility can help you gain additional understanding about the Analysis Services performance. Akshai Mirchandani from the SSAS team was kind enough to share his performance testing experience and recommended this...
-
A couple of years ago I was working on a KPI dashboard project where we had to display a bunch of KPIs produced by counting (distinct count) number of customers, accounts, etc. Even with SSAS 2008 we couldn't much to optimize the queries to render the page in a few seconds because we found that 50...
-
I have a question regarding your blog post on SSAS wish list. http://prologika.com/CS/blogs/blog/archive/2009/12/07/analysis-services-top-10-wish-list.aspx You mention here that "the business problems that I solve with UDM exceed by far Gemini's capabilities." Would it possible for you...
-
thank you so much for your reply. i really running into the wall. :) I am check your drill-down action solution on SOS in the SSAS book. Thank you so much for the great book. The more I read it, the more often I smile; knowing it fixes so many of my problems.
-
Hi Teo I met you at Tech-Ed after your great Reporting Services Class. We are weighing the pros and cons of building one huge "Operations" cube as opposed to building a handful of cubes and then creating a linked cube to bring them all together. For example, our existing Forecast cube uses...
-
Hi Chaps I have a burning query, I ask this question because I keep getting conflicting answers. It's a rather simple question. If we have a SSAS server cube which we are querying against, using for example (Proclarity, Excel or SSRS). Can we run a query against the SSAS server cube while it is being...
-
We have the need for some of our elements to be formatted automatically in thousands (3.5K) or millions (4.23M). We don't see this as a format option in the cube or in the report in Excel cube report. We can't convert it to a string because we still need it to calculate/sum. Is there a setting...
-
Hi Teo, Thank you very much for the quik reply. Your comments are true. On week end i also find that drillthrough has a requirement that no more than one member can be specified for each axis. (as in MDX Soultions by Wiley, page 414). Thanks once again for the code posted by you to capture current context...
-
Hello, I am going through the book, developing my cubes and dimensions using the methods described for the sample. I created several hierarchies for a Dimension and specifically order them so that the most common one is at the top/left of the others. From page 125/126: "Ordering Hierarchies"...