Automatically Refreshing OLAP Cubes...

Dec 14, 2000

Can someone tell me how you can automate the refresh of OLAP Cubes? I just inhereted a data warehouse running on SQL7 and the idea of having to go in and manually refresh the cubes everyday is, well... stupid. I can't believe that they've been doing this for a year. Unfortunately, I'm not familar enough with MSOLAP yet and I can't figure this out. Any tips?

View 2 Replies


ADVERTISEMENT

Need To Create Package For Refreshing The Cubes

Apr 4, 2008



We have scenario where we need to create package for refreshing the cubes. Let me explain it breifly.

We are doing ETL process in different ETL tool (not SSIS) and once the process is done, we are inserting in a table where we have a column like date, Completed C as the status. Once we get this information i.e 'Completed C' status and date, we need to refresh the cube like as follows,

1. Previous day cube need to be refreshed daily once
2. Previous week cube need to be refreshed weekly once.
3. Previous month cube need to be refreshed monthly once.
4. Historical cube need to be refreshed daily once.

We have decided all these above operations needs to be done in SSIS. In this case what are the things to be done while creating a package.

1. What are the control flow items to create it in SSIS?
2. Is there any way to have pooling like every 10 minutes to check whether the table has 'Completed C' status and STOP EXECUTE this package?
3. Is there any way to check the date for Previous day cube, Previous week cube, Previous Month cube and Historical cube etc?


Thanks in advance,
Anand Rajagopal

View 7 Replies View Related

Refreshing Data In Hyperion Essbase Cubes

Jul 11, 2006

Hi all,

Normally I would be using SSAS but our finance department make use of Hyperion Essbase. I was wondering whether it was possible to upload data into an Essbase cube using SSIS in the same way that you can use the Analysis Services processing task? I realise there are no specific task for Essbase, but are there any suggestions about what would be the best way of going about this?

regards

 

Colin

View 4 Replies View Related

HELP OLAP Cubes

Mar 3, 2004

When I try to modify a OLAp Cube, suddenly appears a Error message

"Unknow Error. Restart the Application"

And this break my cube down

This is not always, just some time, for example when I proof the cube on Microsoft Excel or After I backed up the databes of analysis

What can I do?
I'll thanks your quick answer

NOTE: My cube use MOLAP aggregations

View 1 Replies View Related

Distributing OLAP Cubes

Aug 18, 2000

I'm looking into adding OLAP Cubes as part of our software to be distributed with our OLTP and eventually OLAP databases.
Is there any books that deal with distributing OLAP Cubes and or security.
Our clients will have SQL Server with our databases.
Thanks

View 1 Replies View Related

Scripting OLAP Cubes

Mar 16, 2000

Is there a way to script your OLAP cubes created in OLAP Manager to e.g. text files with CREATE CUBE and SELECT INTO statements.

View 1 Replies View Related

OLAP Cubes And Programming

Jul 20, 2005

I cannot seem to find a group where this question would fit so I amposting it here. I have what I believe is a unique situation. I amusing SQL Server Analysis Server to build a cube of "snapshot"month-end type of data. This data is from an instance of MicrosoftNavision and I have successfully used SQL-DMO and DTSPackage Libraryobjects to allow the user to rebuild the cube through Navision. Thisis accounting data and as such, the accountants want to be able toarchive this data by month. I know through Analysis Server Managerinterface I can copy the cube and save it to a different name.I would like to know if there is a way to programmatically save a cubeto a different name with some type of automation object?Thanks

View 1 Replies View Related

Mining On Olap Cubes

Dec 26, 2007

While creating a model, i can access to relational tables as data source, but not to olap cubes. Is it possible to browse olap cubes for mining? If yes, how? Thanks...

View 4 Replies View Related

Reports With OLAP Cubes

Apr 19, 2006

Hi



I try to design a report with Chart based on an Analysis Services Data source...

It does'nt work !!!

Has anyone else the same problem??



View 2 Replies View Related

User Rights In OLAP Cubes

Jul 12, 2000

How can we allow users to access a MS SQL Server OLAP cube but restrict the level of data that he might see?
I mean, if there is a cube with data for three different countries. How can one user be restricted to see data pertaining to
only one of the countries and not the other two countries?

View 2 Replies View Related

OLAP 2000 - Cubes - Filters

Sep 14, 2000

Does anyone know the best way to set up filters against the Cube data.
Ex. The Cube was built with data for 1998,1999, 2000.
The totals and the rollups will include the value for all years.
Client A want to access the Cube Data through Excel 2000 but only wants to see the values for 1999 - with the correct totals and rollups...

I know you can uncheck the other years in the filters in excel, but the totals and rollups will still include the values summing for all years.

Is there away to pass in a query on the fly?

Thanks.

View 1 Replies View Related

Moving OLAP Cubes / Databases

Oct 9, 1999

How can I move OLAP Databases / specific cubes or virtual cubes from our Development Server to the UAT or LIVE servers ?

Thanks,

Lee

View 1 Replies View Related

ADHOC Reports Using OLAP Cubes

Mar 13, 2008

Hi,

i want to know whether it is possible to develop ADHOC reports using SSRS 2005 and OLAP Cubes. the requirement is the user should be able to select the columns he wants to see in the report.

I think this requires Dynamic RDL generation. It is very urgent. i have to give POC to the client on this. Any help in this regad is appreciated.

Thanks,
Srik

View 4 Replies View Related

Question On OLAP Cubes Storage Modes

May 24, 2007

Hi, all experts here,



Thank you very much for your kind attention.



I am having a question on the SSAS2005 OLAP Cubes storage modes. We know SSAS2005 supports 3 different storage modes: ROLAP, MOLAP, HOLAP.



Do all these three storage modes of cubes store data in another physica analysis services databases which are inrelative from their data warehouse (in case they are built on top of the data warehouse)? (so it does not matter at all even we remove the data warehouse?)



Thank you very much in advance for your help and I am looking forward to hearing from you shortly.



With best regards,



Yours sincerely,



View 7 Replies View Related

Windows Forms: Can You Deploy OLAP Cubes Through Winforms?

Nov 16, 2007

Hi all,

Does anyone know if its possible to set up OLAP Cubes in a Winform?

Thanks,

Rob

View 2 Replies View Related

Analysis :: Create OLAP Cubes Using NAV 2009 SP1 Database

Feb 13, 2012

I am attempting to create som OLAP cubes using the NAV 2009 SP1 database. I am using Jet Enterprise with TimeXtender4 to build the cubes.

View 5 Replies View Related

On The Subject Of Data Warehouses, Data Cubes && OLAP&….

Jul 20, 2005

On the subject of Data Warehouses, Data Cubes & OLAP….I would like to speak frankly about Data Warehouses, Data Cubes andOLAP (on-line analytical processing). Has it dawned on anyone elsethat these buzz words were created by some geek who decided to take astab at marketing? Knowing that to the backwoods manager who knowslittle of technology that new innovative names for old concepts wouldhelp to sale their products.I mean seriously, what is the story here? In a nut shell, and pleasestop me if you disagree, but isn’t a data warehouse simply adatabase? Can’t you do everything on a conventional databaselike SQL Server, Oracle or DB2 that you can do on these newproprietary Data Warehouse constructs? I mean who are they trying tofool?Take a look, for instance, at Data Cubes. Who hasn’t noticedthe striking similarity between data cubes and views used in all themore robust databases? Also, what about OLAP? OLAP is nothing morethan a report generator. There’s nothing you can do with thesemillion dollar price tagged Data Warehouse total solution packagesthat I can’t do with SQL Server, Oracle or DB2…for thatmatter Microsoft Access.As an example some sales people for Metadata Corporation has the VicePresident of I.T. in Nashville, for Healthspring, sold on their totalsolution data respository which is such a scam. All they had to dowas throw a couple of buzzwords at him and they have him hypnotized.Personally, I feel that these kinds of marketing practices undermineour industry. It helps to unravel what little standards orconsistency we have. What do you guys think?Stuart

View 7 Replies View Related

Transfer Data(Cubes+virtual Cubes) From Sql2000 To Sql 2005

Jun 6, 2006

Süleyman writes "I want to transfer databases with cubes and virtual cubes from SQL 2000 Analysis Server to SQL 2005 SQL Express.

1.how i can transfer the cubes?

2.how i can transfer the virtual cubes?

3.Why i see the tables(saw)and the cubes in SQL Managment only under Tables together and nothing under cubes?

Please help me
many thanks

Süleyman from Germany/Frankfurt am Main"

View 1 Replies View Related

OLAP Services: Automating Archival/Restore Of OLAP Databases

Sep 19, 2000

Hello All,

Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.

--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220

Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com

"Once in a while you can get shown the light
in the strangest of places if you look at it right"

JG 1942-1995 RIP

View 1 Replies View Related

How To Repair A Corrupted OLAP Database? (was Olap!:)

Jun 12, 2007

How to repair a corrupted OLAP database?

View 2 Replies View Related

Refreshing Test Dbs

Oct 14, 2002

I need to refresh a test db that is running on the same instance as the prod db. Should I just use DTS or is there a better way?

View 3 Replies View Related

Parameter Isn't Refreshing

Jan 25, 2007

Hi.
I have a datasource that depend on parameter A.
Parameter A get his values from query and have a defualt value.
Parameter B get his default value from query that depend on parameter A.

Now, whan I run the report, parameter A get a value and then parameter B get his value and the
datasource run OK.

But the problem is that when I'm changing the A value (from the value list) - The datasource run fine but Parameter B stay with the old value with out any change.

Does any one know how to solve it.
I'll be happy to give more explanation if it isn't clear enough.

Thanks.

View 5 Replies View Related

Automatic Refreshing

May 9, 2007

I am wondering if it is possible to have a report generated by RS refresh periodically automatically. This could be realized by inserting a few lines of JavaScript to the report including the reload() function, but I do not know if there is anyway to do such thing.



Thanks in advance for any tip!

View 5 Replies View Related

Refreshing Data In GridView

Sep 18, 2006

Hi,I’m new to SQL Express, but I have created a table and a stored proc to populate it.I have dragged the table into a form so I can view the data in a GridView.I have added a button to add new rows to the table. All the above works fine, except when I hit add, the data gets added, but the GridView doesn’t update and show the new data.  Is there some code I can add to the add button that also refreshed the GridView? ThanksMike

View 2 Replies View Related

Report Continually Refreshing

Jul 19, 2007

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.



I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.



Has anyone seen this problem of a continually refreshing report?



It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.



Thanks in Advance



Peter

View 3 Replies View Related

Refreshing Database Before Restart

Jun 8, 2007



i am running a game from a dedi box .. ms sql..

and every time i restart and put it back up ,,,,it rewinds the database

the only way i can prevent this is if i restart the server

wait a phew hours then put it back up ,,"which makes it the same way it was when i logged off"

i was told that sql database servers refresh every hour.

is there a way i can make it refresh before i restart it so then i can put the server straight back up





if i restart the server back up straight away it does a rewind for some reason.





tech ::

the server does a rewind because it wouldn't have saved the game so to speak - as in updated everyone's characters. So yes waiting is the only way as far as I know to save the game.

View 3 Replies View Related

Refreshing Data In The Cursor.

Nov 17, 2006



Hello everybody,

I wrote a stored procedure for SqlServer 2000 and i am using it for paging purpose.
The procedure is as follows :

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[OLAP_PagedRows]
(
@SelectFields nVarchar(2000) =NULL,

@GroupByFields nvarchar(1000) =NULL,

@BaseTable varchar(100),

@KeyColumn nvarchar(200)=NULL ,

@JoinTables varchar(500) =NULL,

@ConditionalClause varchar(1000) =NULL,

@Pagesize int = 10,

@PageNumber int =1,

@SortExpression nvarchar(200)=NULL,

@SearchText nvarchar(200)=NULL

)

AS

BEGIN



DECLARE @SQLSTMT NVarchar(4000)

DECLARE @SQLSTMT1 NVarchar(4000)



SET @SQLSTMT1 = ''

--check whether page size is given null or not, if so set to default value

IF @Pagesize IS NULL OR @Pagesize = ''

BEGIN

SET @Pagesize =10

END

--check whether page number is given null or not, if so set to default value

IF @PageNumber IS NULL OR @PageNumber = ''

BEGIN

SET @PageNumber =1

END



--Start constructing the query --

SET @SQLSTMT = 'SELECT '

SET @SQLSTMT1 = 'DECLARE @CountValue INT SELECT @CountValue = count(*) From '+@BaseTable

SET @SQLSTMT = @SQLSTMT + @SelectFields + ' FROM '+@BaseTable

If @JoinTables Is Not Null

BEGIN

SET @SQLSTMT = @SQLSTMT + ' ' +@JoinTables

SET @SQLSTMT1 = @SQLSTMT1 + ' ' +@JoinTables

END

DECLARE @StmtWhereClause nvarchar(500)

SET @StmtWhereClause =''

--------------------- Get where conditional clause

If (@SearchText Is Not Null AND RTRIM(LTRIM(@SearchText))<>'')

BEGIN

SET @StmtWhereClause = @StmtWhereClause + ' WHERE ' + @SearchText

END





If @ConditionalClause Is Not Null AND RTRIM(LTRIM(@ConditionalClause))<>''

BEGIN

IF (@StmtWhereClause <> '')

BEGIN

SET @StmtWhereClause= @StmtWhereClause + 'AND ' +@ConditionalClause

END

ELSE

BEGIN

SET @StmtWhereClause = @StmtWhereClause + ' WHERE ' + @ConditionalClause

END

END



SET @SQLSTMT = @SQLSTMT + @StmtWhereClause

SET @SQLSTMT1 = @SQLSTMT1 + @StmtWhereClause

If @GroupByFields Is Not Null And RTRIM(LTRIM(@GroupByFields))<>''

BEGIN

SET @SQLSTMT = @SQLSTMT + ' Group By ' +@GroupByFields

SET @SQLSTMT1 = @SQLSTMT1 + ' Group By ' +@GroupByFields

END

IF @SortExpression Is Not Null AND RTRIM(LTRIM(@SortExpression))<>''

BEGIN

SET @SortExpression = LTRIM(RTRIM(' Order By '+ @SortExpression))

SET @SQLSTMT = @SQLSTMT +' '+ @SortExpression

SET @SQLSTMT1 = @SQLSTMT1 +' '+ @SortExpression

END

SET @SQLSTMT1= @SQLSTMT1+' SELECT @CountValue As MyRows '

--SELECT @SQLSTMT1

--SELECT @SQLSTMT

DECLARE @StartRow INT

SET @SQLSTMT = ' DECLARE temp_Cursor CURSOR SCROLL FOR '+@SQLSTMT

EXECUTE SP_EXECUTESQL @SQLSTMT

Open temp_Cursor

DECLARE @RowCount INT

SET @RowCount = 1

SET @startRow = (@PageSize * (@PageNumber-1))+@RowCount

--SELECT @startRow as 'Current Row'

WHILE @RowCount <= @PageSize

BEGIN

--Select @StartRow 'as @StartRow'

FETCH ABSOLUTE @startRow From temp_Cursor

SET @RowCount= @RowCount+1

SET @StartRow = @startRow + 1

END

deallocate temp_Cursor

EXECUTE SP_EXECUTESQL @SQLSTMT1



END

It is working fine but I have problem with this kind of paging. I need to load the whole data into the cursor and i have to fetch records. The problem is that my table's contains more than Half a million records in it. If I have to load each time this cursor it will be a very big problem on the server side.

Probably it may not be a best solution, but sqlserver 2000 cannot provide more help than this. If I use sub-query for this like using Top <Number> it adversly effecting the nature of the data retrieval.

One solution that I am thinking is Load cursor once and whenever some updations performed on those tables from which cursor is getting data should be automatically reflect the changes.

Is this possible? Please help me.

Regards

Andy Rogers









View 3 Replies View Related

Refreshing A Dataset In RS 2005

Feb 20, 2008



I have a report in RS that uses a cube as a data source. I made some changes to a cube in AS 2005 and I am not sure how I can refresh my existing datasets without deleting everything?


Any feedback is greatly appreciated.
Thanks!

View 4 Replies View Related

Problem With Reportviewer While Refreshing

May 8, 2007



Hai,



Im having a report.When i click on one item in Report it navigate to second Report.Here Second report acts as a Child report.Whne i click on refresh button it goes back parent report.Some times i get error



"
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request. "

Plz help its very imp.

With regards,
Mahender

View 3 Replies View Related

SQLDatasource && Schema Refreshing (with Parameters)

Apr 9, 2006

Hi,
I'm having serious issues trying to refresh a schema in a SQLDatasource.  It is hooked to a stored procedure that takes two varchar(39) parameters.   The default parameters in this case are '%'. Note I am working in the designer.
If I set it up as a stored proc, I can't even get the 'test query' to run in the builder.
If I set it up as a select statement, ala 'exec <procname> @p1, @p2', the 'test query' will run.
In neither case will hitting refresh schema work.  It returns 'Invalid length parameter passed to the substring function'
The stored proc is nothing special, simply returning a select based upon the parameters.
Thanks,
Nick H

View 2 Replies View Related

Loosing Connection Upon Refreshing Page

May 31, 2005

Hi,

I'm getting a connection and then loosing my connection upon refreshing the browser with this script connecting to MSSQL using php, when trying the following:


PHP Code:




 $connection = mssql_connect("127.0.0.1","test","") or 
die("Could not connect mssql db on " .$config['dbhost']);
        
mssql_select_db("dbName") or
die("Could not select database " ."dbName"); 






Are their other ways to see more error handling in connecting to MSSQL

View 1 Replies View Related

SQL 2012 :: SSRS Report Is Not Refreshing?

May 12, 2015

I have created an SSRS report, but the data does not refresh. I am using the SSRS Report Buidler to create reports and when I run the query in the dataset, the results return as expected. However, when I run the report itself, the dataset appears old.

View 6 Replies View Related

Refreshing SQL Connection From Access ADP File

May 21, 2008



Hi,
I have many buttons in Access ADP that trigger feeding a table with different data.
Let's call the table tempTable1. I have 600 buttons that feed the make table with all kinds of data:



Code SnippetSELECT * INTO tempTable1 From AnyDataSourceSPViewTable

. There is another menu bar button that only opens


tempTable1. The result for tempTable1 is always correct when you use Query Analyzer. However Access ADP recognizes the change in the table structure when the connection is refreshed. Is there is any way that we can automate the connection refresh procedure or an easier way to get the desired results?

Am using Access 2003 connected to SQL 2005 and trigering the events via VBA.

thank you,

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved