Home Forums Data Warehousing Analysis Services Require help on starting for OLAP RE: Require help on starting for OLAP

  • September 7, 2015 at 8:56 am

    #1824997

    sqlinterset (8/31/2015)

    Currently i am using sql queries to show data in excel pivot tables. however, data is very large around in millions and take so much time in refreshing the reports.

    I am planning to build star schema and OLAP to fetch data in excel pivot tables. Will it be good start? my excel contains many pivot tables and pivot charts. Is there any good article to start it?

    i am using sql server 2012.

    You're not fixing the problem and you're possibly bringing other problems into play such as maintaining and refreshing your "star schema".

    My recommendation is that you've correctly identified the problem of the queries taking a long time. Fix them. 😉 Once that's done, they might be useful in maintaining your "star schema".

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)