OLAP Cubes

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Naeem
    #1

    OLAP Cubes

    I am working in SQL Server OLAP Services 7.0. I have stored the
    monthwise data in separate table for each month. All tables have same
    columns. Is it possible to build a cube on these multiple tables having
    same columns? The cube will have same dimensions and measures accross
    these tables.

    Tags: None
    • Salad
      #2
      Re: OLAP Cubes

      Naeem wrote:
      [color=blue]
      > I am working in SQL Server OLAP Services 7.0. I have stored the
      > monthwise data in separate table for each month. All tables have same
      > columns. Is it possible to build a cube on these multiple tables having
      > same columns? The cube will have same dimensions and measures accross
      > these tables.
      >[/color]
      In order to join data from the tables, since you have a table for each
      month, you would need to first create a union query where you union all
      of the tables for all of the months you wish to process. IOW, if you
      wanted to process data for Jan-Sep, 2005, you would do something like
      Select * From JanTable
      UNION ALL Select * From FebTable
      UNION ALL Select * From MarTable
      ...
      UNION ALL Select * From SepTable

      That would be the first step in setting up your cube.

        Comment

        • corey lawson
          #3
          Re: OLAP Cubes

          Salad wrote:
          [color=blue]
          > Naeem wrote:
          >[color=green]
          >> I am working in SQL Server OLAP Services 7.0. I have stored the
          >> monthwise data in separate table for each month. All tables have same
          >> columns. Is it possible to build a cube on these multiple tables having
          >> same columns? The cube will have same dimensions and measures accross
          >> these tables.
          >>[/color]
          > In order to join data from the tables, since you have a table for each
          > month, you would need to first create a union query where you union all
          > of the tables for all of the months you wish to process. IOW, if you
          > wanted to process data for Jan-Sep, 2005, you would do something like
          > Select * From JanTable
          > UNION ALL Select * From FebTable
          > UNION ALL Select * From MarTable
          > ...
          > UNION ALL Select * From SepTable
          >
          > That would be the first step in setting up your cube.[/color]

          ....do it in a view on SQL Server, and link to that view. Don't do the
          UNION query in Access, although it is entirely possible to do.

          For one, SQL Server will probably consider this a "partitione d query",
          and can throw some different optimizations internally at the data when
          you query the view. Say, you're only looking for data that happens to be
          only in dates that are in the FebTable, SQL Server will probably realize
          that the view only needs to get data from FebTable.



            Comment

            • Naeem
              #4
              Re: OLAP Cubes

              Consider this approach. I will process the cube to load the data from
              Jan table. Then i will process cube using incremental process to load
              the data fromFeb table and so on. In this way my cube will contain the
              data stored in different tables for each month. This means i will have
              to process whole cube each month when new data arrives.
              But what if i want to delete the data for a given month from the cube?
              Is this approach feasible?

                Comment

                Previous template Next
                Working...