Prologika Forums
Making sense of data

Browse Site by Tags

Showing related tags and posts across the entire site.
  • Attend One BI Training Class - Get One Consulting Hour Free!

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Sun, Jun 6 2010
    Filed under: Reporting Services, Analysis Services, Business Intelligence, Training
  • In Search of Aggregations

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Sat, May 22 2010
    Filed under: Analysis Services
  • To Partition or Not – This is the Question

    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,...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, May 21 2010
    Filed under: Analysis Services
  • Online Analysis Services 2008 Class on May 17th

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, May 7 2010
    Filed under: Analysis Services, Business Intelligence, Training
  • Scope Assignments and Missing Members

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Wed, Apr 28 2010
    Filed under: Analysis Services
  • Using XPerf to Test Analysis Services

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, Apr 16 2010
    Filed under: Analysis Services
  • Analysis Services I/O Time

    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...
    Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Tue, Apr 13 2010
    Filed under: Analysis Services
  • SSAS 2008R2 vs PowerPivot - business capabilities / value proposition

    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...
    Posted to Applied Microsoft Analysis Services 2005 by harshb on Mon, Mar 22 2010
  • 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 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
Page 1 of 13 (260 items) 1 2 3 4 5 Next > ... Last »