Post reply

Analysis Services Multidimensional

  • February 1, 2014 at 12:46 pm

    #303973

    Comments posted to this topic are about the item Analysis Services Multidimensional

  • February 1, 2014 at 12:55 pm

    #1685303

    I guess the more questions there are on topics I know zilch about the sooner I will get around to learning something about SSAS. So I definitely welcome questions like this one, although it took me a lot of burrowing through MSDN and trying to understand new things to discover the answer. So a really good question.

    One thing I noticed was that MSDN is a terrible source for information on this - I couldn't find anything that directly answerd the question. I was quite hard to stitch the varions clues together and come up with teh correct result. I hate it when software has documentation which doesn't provide a decent conceptual model which woul include things like this. So thanks for the reference in the explanation to the Kejser and Lee document - that will help fill the gap for me (and probably ensure that I continue to have more to do than I have time for, as I suspect it will be a long read).

    Tom

  • February 2, 2014 at 6:21 am

    #1685341

    Interesting question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 2, 2014 at 12:00 pm

    #1685355

    Easy one!

    Thanks!

    🙂

  • February 2, 2014 at 12:03 pm

    #1685356

    I also found this doc from MSDN that explains the answer

    SSAS2005PerfGuide.doc

  • February 3, 2014 at 2:13 am

    #1685411

    Not an easy one. But good QotD.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • February 3, 2014 at 7:00 am

    #1685469

    good QOTD.

    Thanks Steven.

  • February 3, 2014 at 7:08 am

    #1685475

    Nice diagram here:

  • February 3, 2014 at 7:19 am

    This was removed by the editor as SPAM

  • February 3, 2014 at 8:28 am

    #1685524

    No problem, folks. For me, learning SSAS was like learning organic chemistry--a lot of repetition, hands-on practice, and reading the right material that "spoke to me in just the right way". More SSAS questions are on their way this week. 🙂

  • February 3, 2014 at 9:44 am

    #1685555

    Two out of three from a pdf file I downloaded from Microsoft. Good question. But a little rough for a Monday after I drank 4 sodas (high fructose corn syrup!) at a Super Bowl party. :hehe:

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • February 3, 2014 at 12:11 pm

    #1685606

    This one took me almost half an hour: yes, MSDN does not have good documentation on this.

    Thanks for the QotD, Steven!

  • February 3, 2014 at 1:33 pm

    #1685627

    Carlo Romagnano (2/2/2014)

    I also found this doc from MSDN that explains the answer

    SSAS2005PerfGuide.doc

    +1

    That's the resource I found

  • February 3, 2014 at 1:52 pm

    #1685634

    m mcdonald (2/3/2014)

    Carlo Romagnano (2/2/2014)

    I also found this doc from MSDN that explains the answer

    SSAS2005PerfGuide.doc

    +1

    That's the resource I found[/quote

    There is also SSASPerfGuide2008R2 which is more up to date.

  • February 3, 2014 at 2:13 pm

    #1685646

    Stewart "Arturius" Campbell (2/3/2014)

    Interesting question, thanks, Steven

    I knew about the dimension data and frequently used calculated cells, but, never having used subcubes before, this was new to me.

    learned something new today. :Wow:

    I learned something new today as well - if only for a fleeting moment.;-)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply