Is it possible to migrate a cube from SSAS 2008 to SSAS 2005?
View Complete Post
We have created an offline cube on a network drive from SSAS 2008 and users are able to successfully access this serially using the Excel 2003 cube add-in or Excel 2007, in concert with version 10 driver, but when a user is already connected, the second
attempt to connect will get the message :
Connection to <filename> server, <dbname> database, <cubename> cube failed. OLAP Server error: The following system error occurred: The process cannot access the file because it is being used by another process. ., File system
error: An error occurred while opening the '<filename>' local cube file.
This is regardless of whether users connect specifying read-only and we have found it impossible to connect to a cube if the file has the read-only attribute set.
Is there any way to solve this without users taking copies onto their workstations?
SQLServer 2008 R2
Excel 2010 x64
I have a fairly complex Excel report where a raw data sheet is updated from 10 or so PivotTables pulling from an Analysis Services Cube, (2008 R2), with a VBA script that refreshes all pivottables, and then does some post-processing, formatting etc.
This was originally developed in Excel 2003, and the updating of all the pivot tables ran in under 10 seconds
I've now recreated in Excel 2010 and *each table* is taking up to a minute to refresh!
I've also observed that I can get the refresh time of a single table back down to 1sec, if I delete all other pivottables from the worksheet/book.
Its deeply frustrating, as I'm touting 2010 as being the way for our business to go...it won't help the cause if I deliver something with a x60 increase in runtime!
I've run traces of both the 2003 and 2010 versions executing against the SQL Server, the only thing I can see is that the 2003 version passes 1 single MDX query, whilst the 2010 version appears to be firing it in sections.
I've posted this in the Excel forum too.
Please can anyone help?
I have an issue when trying to browse the cube (which was processed successfully) in either BIDs or Management Studio (2008 R2 version).
The error details are below. Can someone please help me? Ta
The specified procedure could not be found. (Exception from HRESULT: 0x8007007F) (Microsoft Visual Studio)
at Microsoft.AnalysisServices.Controls.PivotTableHash.GetTotal(String uniqueName)
at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetPivotTableDataObject(NodeObject nodeObject)
at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetDataObject(TreeNode node)
at Microsoft.AnalysisServices.Controls.MetadataTreeView.OnItemDrag(ItemDragEventArgs e)
at System.Windows.Forms.TreeView.TvnBeginDrag(MouseButtons buttons, NMTREEVIEW* nmtv)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
I have a [DateAsAt] table in the DSV. This is linked to 3 fact tables to analyse and slice them from an as at date perspective (lets call them FactA, FactB and FactC). But I want to reuse this dimensions (almost like an alias) and although I have tried
this and it seems to work, I just want to follow some due dilligence to make sure what I am doing is valid.
I have not created a new Named Calculation for a new date dimension that will be used in a Transactional way (not an as at way), and in stead simply copied the [DateAsAt] dimension, and pasted it back into the dimensions section of the cube (the default
name it was given was [DateAsAt 1], but I changed it to [DateTransaction].
Although the relationship between the [DateTransaction] dimenion's source in the DSV (I.e. [DateAsAt]) is linked to FactA, FactB and FactC, I set a new dimension relationship between [DateTransaction] and FactTransactionD in the Dimension Usage area
of the cube.
Is this valid? or MUST I create a seperate source for [DateTransaction] in the DSV and set its relationships there?
I've build a cube in BIDS 2008 on Windows 7 machine connecting to oracle data source. I've 32-bit oracle client on my machine. I'm able to create the data source, data source view, cube successfully. I can also explore the data in data source view. But when
I try to deploy the cube on my SSAS 2008 server, it fails with the following error:
Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running
in 64 bit mode with the 32 bit Oracle client components installed.;An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B).
Hi, I have one dimension and one fact table in SQL 2008 server...
i.e. DimEmployee (Columns : EmployeeID, FirstName, LastName, DateOfBirth, Addrss, PostCode, MobileNumber, Gender)
FactEmployeePay ( Columns : EmployeeID, Amount)
When I create SSAS 2008 cube on those two tables (Relationship is EmployeID colmun) , deploy/process project/cube and then I go to "Cube Browser", but in dimension Employee table I can not see any columns other than EmployeeID. Why in this simple cube
I can not view other dimension columns like FirstName, LastName,....
Any idea for SSAS 2008?
Previously I posted my probelm into T-SQL forum section. Here is link
I have SQL 2005 table like
Room AdmissionDate DischargeDate
R1 2010-01-25 2010-01-28
R1 2010-01-28 2010-01-30
R1 2010-02-15 2010-02-17
R1 2001-02-20 NULL
R2 2010-01-31 2010-01-31