Prologika Forums
Business Intelligence to the Masses

Browse Site by Tags

Showing related tags and posts across the entire site.
  • Beware Hidden Calculated Members

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Mon, Jan 18 2010
    Filed under: Analysis Services
  • Most Requested Features

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Mon, Dec 21 2009
    Filed under: General, Reporting Services, Analysis Services
  • Infragistics Silverlight for Analysis Services

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Wed, Dec 9 2009
    Filed under: Analysis Services
  • Analysis Services Top 10 Wish List

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Mon, Dec 7 2009
    Filed under: Analysis Services
  • Expert Cube Development with Analysis Services 2008

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Wed, Dec 2 2009
    Filed under: Analysis Services, Business Intelligence
  • Not All Calculated Members Are Born Equal

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, Nov 13 2009
    Filed under: Analysis Services
  • Where is the SSAS 2008 Book?

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Tue, Nov 10 2009
    Filed under: Analysis Services
  • Re: drill down with dim_Date and dim_TimeofDate

    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.
    Posted to Applied Microsoft Analysis Services 2005 by light_wt on Tue, Sep 22 2009
  • One Huge Cube or a few smaller cubes tied together with a Linked Cube?

    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...
    Posted to Applied Microsoft Analysis Services 2005 by Chris on Wed, Jun 17 2009
  • Cube Processing - Can we still query?

    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...
    Posted to Applied Microsoft Analysis Services 2005 by Paul on Wed, May 20 2009
  • Format elements as thousands or millions

    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...
    Posted to Applied Microsoft Analysis Services 2005 by Audrey on Wed, Feb 18 2009
  • Re: Actions and Stored procedures

    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...
    Posted to Applied Microsoft Analysis Services 2005 by sanjay on Mon, Aug 4 2008
  • Ordering Hierarchies

    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"...
    Posted to Applied Microsoft Analysis Services 2005 by toddchitt on Thu, Jul 19 2007
  • Multiple Linked Measure Groups

    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...
    Posted to Applied Microsoft Analysis Services 2005 by mick on Tue, Jul 10 2007
Page 1 of 13 (260 items) 1 2 3 4 5 Next > ... Last »