OLAP, install and access the sample db food mart

Posted on 2005-04-29
Last Modified: 2009-12-16
Hi, I am a novice to olap, but I quickly need to get upto speed. For that I need hands on exposure to OLAP and MDX. Can u help me with what to install and a quick step by step?

Question by:LDeepa
    1 Comment
    LVL 34

    Accepted Solution

    "For that I need hands on exposure to OLAP and MDX. Can u help me with what to install and a quick step by step?

    Not sure exactly what you're getting at, but you need to install Analysis Services off of the SQL Server installation CD.  You also need to make sure you have a version of sql server that supports it (


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now