|
|
You're in the
sql server data warehouse
group:How to auto-refresh cubes
sql server data warehouse:
is updated in SQL server 2005? I tried configuring the cach options under Paritions, but that's not doing it. Thanks, Gilgamesh
There are some ways to do it, depending on the requirements. If you need to
have real time data you might want to check ROLAP, but dont go there if you dont have to. SSIS package can process the cube (check the tasks) and one of the other options would be proactive caching. I could be more specific when (if) you provide some background and requirements (latency?). MC [quoted text, click to view] "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message news:%23yyaQgTeHHA.3552@TK2MSFTNGP05.phx.gbl... > Is there anyway to auto-refresh the Analysis Services 2005 cubes when data > is updated in SQL server 2005? I tried configuring the cach options under > Paritions, but that's not doing it. > > Thanks, > Gilgamesh >
We don't have to do real time, 15 minutes delay would be fine. Also, we
don't use SSIS at this time. We use SSRS which is using SSAS as the back end data. I saw proactive cahing option under partitions tab on the cube. Is this option available in standard version of SQL server 2005? -G [quoted text, click to view] "MC" <marko.NOSPAMculo@gmail.com> wrote in message news:uiJx3qTeHHA.588@TK2MSFTNGP06.phx.gbl... > There are some ways to do it, depending on the requirements. If you need > to have real time data you might want to check ROLAP, but dont go there if > you dont have to. > SSIS package can process the cube (check the tasks) and one of the other > options would be proactive caching. I could be more specific when (if) you > provide some background and requirements (latency?). > > > MC > > > "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message > news:%23yyaQgTeHHA.3552@TK2MSFTNGP05.phx.gbl... >> Is there anyway to auto-refresh the Analysis Services 2005 cubes when >> data is updated in SQL server 2005? I tried configuring the cach options >> under Paritions, but that's not doing it. >> >> Thanks, >> Gilgamesh >> > >
SSAS is getting data directly from the main database. Isn't SSAS itself a
warehouse? Also, would it make sense to have SSRS pull data from SSIS, instead of SSAS? -G [quoted text, click to view] "MC" <marko.NOSPAMculo@gmail.com> wrote in message news:uQfchzseHHA.2332@TK2MSFTNGP04.phx.gbl... > No, its an Enterprise feature. How do you get the data to the SSAS? Do you > have a data warehouse set up or? Also, why not use SSIS to refresh > (process) the cubes? Its fairly simple to set up a package that processes > the cubes and the schedule it... > > MC > > "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message > news:uV$g9RseHHA.4916@TK2MSFTNGP06.phx.gbl... >> We don't have to do real time, 15 minutes delay would be fine. Also, we >> don't use SSIS at this time. We use SSRS which is using SSAS as the back >> end data. I saw proactive cahing option under partitions tab on the cube. >> Is this option available in standard version of SQL server 2005? >> -G >> >> "MC" <marko.NOSPAMculo@gmail.com> wrote in message >> news:uiJx3qTeHHA.588@TK2MSFTNGP06.phx.gbl... >>> There are some ways to do it, depending on the requirements. If you need >>> to have real time data you might want to check ROLAP, but dont go there >>> if you dont have to. >>> SSIS package can process the cube (check the tasks) and one of the other >>> options would be proactive caching. I could be more specific when (if) >>> you provide some background and requirements (latency?). >>> >>> >>> MC >>> >>> >>> "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message >>> news:%23yyaQgTeHHA.3552@TK2MSFTNGP05.phx.gbl... >>>> Is there anyway to auto-refresh the Analysis Services 2005 cubes when >>>> data is updated in SQL server 2005? I tried configuring the cach >>>> options under Paritions, but that's not doing it. >>>> >>>> Thanks, >>>> Gilgamesh >>>> >>> >>> >> >> > >
No, its an Enterprise feature. How do you get the data to the SSAS? Do you
have a data warehouse set up or? Also, why not use SSIS to refresh (process) the cubes? Its fairly simple to set up a package that processes the cubes and the schedule it... MC [quoted text, click to view] "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message news:uV$g9RseHHA.4916@TK2MSFTNGP06.phx.gbl... > We don't have to do real time, 15 minutes delay would be fine. Also, we > don't use SSIS at this time. We use SSRS which is using SSAS as the back > end data. I saw proactive cahing option under partitions tab on the cube. > Is this option available in standard version of SQL server 2005? > -G > > "MC" <marko.NOSPAMculo@gmail.com> wrote in message > news:uiJx3qTeHHA.588@TK2MSFTNGP06.phx.gbl... >> There are some ways to do it, depending on the requirements. If you need >> to have real time data you might want to check ROLAP, but dont go there >> if you dont have to. >> SSIS package can process the cube (check the tasks) and one of the other >> options would be proactive caching. I could be more specific when (if) >> you provide some background and requirements (latency?). >> >> >> MC >> >> >> "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message >> news:%23yyaQgTeHHA.3552@TK2MSFTNGP05.phx.gbl... >>> Is there anyway to auto-refresh the Analysis Services 2005 cubes when >>> data is updated in SQL server 2005? I tried configuring the cach options >>> under Paritions, but that's not doing it. >>> >>> Thanks, >>> Gilgamesh >>> >> >> > >
Well, depends on the definition of the data warehouse. You should read a bit
about DW and SSAS. In most cases you have 3 types of data storage: OLTP relational database (production database) DW relational database (use as a storage only, denormilazed and contains history) SSAS analytical database (use for multidimensional analitical queries) SSIS is usually used for moving, transforming and cleaning data between OLTP and DW. You can also use it for maintenace task or in general for automating tasks MC [quoted text, click to view] "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message news:u2rAdWveHHA.1240@TK2MSFTNGP04.phx.gbl... > SSAS is getting data directly from the main database. Isn't SSAS itself a > warehouse? > Also, would it make sense to have SSRS pull data from SSIS, instead of > SSAS? > -G > > "MC" <marko.NOSPAMculo@gmail.com> wrote in message > news:uQfchzseHHA.2332@TK2MSFTNGP04.phx.gbl... >> No, its an Enterprise feature. How do you get the data to the SSAS? Do >> you have a data warehouse set up or? Also, why not use SSIS to refresh >> (process) the cubes? Its fairly simple to set up a package that processes >> the cubes and the schedule it... >> >> MC >> >> "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message >> news:uV$g9RseHHA.4916@TK2MSFTNGP06.phx.gbl... >>> We don't have to do real time, 15 minutes delay would be fine. Also, we >>> don't use SSIS at this time. We use SSRS which is using SSAS as the back >>> end data. I saw proactive cahing option under partitions tab on the >>> cube. Is this option available in standard version of SQL server 2005? >>> -G >>> >>> "MC" <marko.NOSPAMculo@gmail.com> wrote in message >>> news:uiJx3qTeHHA.588@TK2MSFTNGP06.phx.gbl... >>>> There are some ways to do it, depending on the requirements. If you >>>> need to have real time data you might want to check ROLAP, but dont go >>>> there if you dont have to. >>>> SSIS package can process the cube (check the tasks) and one of the >>>> other options would be proactive caching. I could be more specific when >>>> (if) you provide some background and requirements (latency?). >>>> >>>> >>>> MC >>>> >>>> >>>> "Gilgamesh" <gilgamesh4ever@aol.com> wrote in message >>>> news:%23yyaQgTeHHA.3552@TK2MSFTNGP05.phx.gbl... >>>>> Is there anyway to auto-refresh the Analysis Services 2005 cubes when >>>>> data is updated in SQL server 2005? I tried configuring the cach >>>>> options under Paritions, but that's not doing it. >>>>> >>>>> Thanks, >>>>> Gilgamesh >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |