Microsoft BI General Question

Posted on 2011-04-28
Last Modified: 2016-02-14
I am not too sure about Microsoft BI and is interested in evaluating if it is a viable option for my company.

Does Microsoft SQL Server 2008 Standard Runtime Edition comes with the BI reporting?

Can Microsoft BI's solution work with lower version of Office such as Excel 2000, 2003 and 2007?

Question by:NicksonKoh
    LVL 2

    Assisted Solution

    Yes, it comes with SSRS. The features for each version can be located here:
    LVL 17

    Author Comment

    Thx for the reply. But what is SSRS?

    Also how about integration with lower versionso of Excel such as 2000, 2003 and 2007?
    LVL 21

    Expert Comment

    by:Alpesh Patel
    SSRS is reporting service, like Crystal Report. and BI toll is used to create Reports.
    LVL 15

    Assisted Solution

    by:Aaron Shilo
    LVL 4

    Accepted Solution

    Yes, Microsoft BI (SSIS,SSAS,SSRS) works with all the versions of Excel 2000,Excel 2003, Excel 2007. All the components of Microsoft BI SSIS,SSAS,SSRS work with Excel. Here reporting can be done with SSAS,SSRS. SSAS is completely 3-D reporting  where as SSRS has both 2-D annd 3-D reporting. Differences between SSAS and SSRS reporting is SSRS has additional presentation features for reporting whereas SSAS has limited UI capabilities. Also SSRS can consume SSAS and create reports on top of SSAS databases or cubes.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now