-
Here is another one of those "by design" issues (see the Not All Calculated Members Are Born Equal blog for another recent gotcha) that are not documented but can sure waste you precious time figuring out. The issue was first submitted on connect.microsoft.com by Greg Galloway almost a year...
-
You can use the Microsoft Connect website to find most requested features. Unfortunately, the search doesn't let you specify a product so the search results may be related to other products. For example, searching on reporting services may bring in results from Analysis Services and reporting . Nevertheless...
-
Don Demsak pointed out another Silverlight-based control from Infragistics, which is currently in a CTP phase. There are actually two controls: XamWebDataChart and XamWebPivotGrid. I played a bit with it and it looks great. I liked the Excel-like paradigm with the metadata pane on the right and the PivotChart...
-
Analysis Services leads the OLAP server market and it should be your platform of choice for historical and trend reporting. In the spirit of the season, here is my Top 10 Wish List for Analysis Services. All items are related to regular cubes and none to PowerPivot which I am yet to try. Improved client...
-
Now that I've got my copy and read it, I can say a few things about the book Expert Cube Development with Microsoft SQL Server 2008 Analysis Services by Chris Webb, Alberto Ferrari, and Marco Russo. As mentioned in another post , the authors (all MVPs and prominent SSAS experts) don't disappoint...
-
An interesting issue popped up yesterday regarding the calculated member syntax. I had to multiply negative amounts in a financial cube for certain account categories that had negative amounts. The cube also had a Many:Many relationship between financial accounts and account groups which may be related...
-
Readers have been asking about a revised edition of my Applied Microsoft Analysis Services book for version 2008. First of all, I'd like to thank all my readers who bought and liked the book. This book has been a great success and it really exceeded my expectations in any way! It has great reviews...
-
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"...
-
We're looking at breaking "mother cubes" up into smaller component domain cubes. That gives us the ability to run targetteddomain area cubes in specific areas in the businss, but also for smaller projects to inherit the bits and pieces they need from each domain cube, with dimension security...