MS SQL Server :: Creating Offline Cube From Excel 2007

Excel 2007 Issue (KB 929766) For Cube Reports; Doesn't Make Any Sense

Mar 12, 2007

In short, we have started deploying Office 2007 to our users and Excel is currently the only client we use to interact with our AS2005 cubes.

A few users have reported issues (which I've verified), but the explanation in the KB article doesn't make any sense to me. These reports were originally developed in Excel 2003 and when opening them up in Excel 2007, we'll see a message saying that Excel found unreadable content in the .xls file and after clicking 'Yes' to recover contents of the workbook, we then receive a message that a PivotTable report was discarded due to integrity problems. If I opened up this report in Excel 2003, I don't receive these errors or messages.

Per the KB's explanation (http://support.microsoft.com/default.aspx/kb/929766):

This issue occurs if the following conditions are true: ��The workbook contains a PivotTable that uses key performance indicators (KPIs).��The KPIs are created in the Analysis Services Business Intelligence Development Studio.��One or more of the KPIs have an expression in the Current Time Member property.
Now, we are running 2005 Standard Edition with no SP, but will be deploying SP2 in a few days. Our cubes do not have any KPIs defined. Can I even define KPIs if we are only running Standard Edition?

Any thoughts?

View 6 Replies View Related

Automate Generation Of An Offline Olap Cube

Apr 6, 2004

hello,

does anybody know how i could automate an offline olap cube, so that it will be updatet daily?

thanks chri

View 3 Replies View Related

Analysis :: SSAS Model Where Never Need Cube To Be Offline

May 21, 2015

I am thinking of a possible design where the cube will never go offline.

Usually when I do some code changes on my cube the cube goes offline and I need to Full Process it again to get it back .

However , in cases where the cube is extremely critical for the business users , it would be great if I can deliver a solution where the cube never goes down.

View 4 Replies View Related

Analysis :: Cube Is Getting Offline Multiple Times In A Day

Apr 14, 2015

I am recently encountering proble with SSAS cube,In a day cube is going to offline for several time and unable to browse it and after some time automatically cube is getting online.I am unable to figure it out what is happening.

FYIP..For every 15 Min cube will be Proccessed Full.

View 8 Replies View Related

Analysis :: Creating Cube With AMO - Cube Has No Measure Groups?

May 19, 2015

I have problems creating a cube with AMO.

I can add the cube to the database object and fill it with dimensions and a measuregroup (see code below).

If I call cube.Update() it says something like "Error in meta data manager. Cube has no measuregroups." (getting the message in german language)

The error in Microsoft.AnalysisServices.OperationException.Results.Messages is -1055653629

I can't find any documentation about this (or any other) error code in Microsoft documentation.

Here's my Code:

Cube newCube = database.Cubes.Add("MyCube","MyCube");
newCube.Language = 1031;
newCube.Collation = "Latin1_General_CI_AS";
CubeDimension dim = newCube.Dimensions.Add("dim1","dim1","dim1");
CubeAttribute attrib = dim.Attributes.Find("dim1Attr1");

[code]....

View 2 Replies View Related

Excel Add-in Failed To Load After Reinstalling Excel 2007

Mar 15, 2008

Hi,

I have reinstalled Office 2007 (to changre the license key)
after this, the data mining excel add-in failed to load.

the "COM add-ins" displays: "not loaded. a runtime error occurred during the loading"

reinstalling the add-in doesn't solve the problem
installing the 2008 version don't solve the issue too.

There is no other information, what can I do to solve the issue?

thanks.

View 3 Replies View Related

Excel 2003 To Excel 2007 Problem

Jan 2, 2008

hi,

i have one application in Microsoft excel 2003. but when i open this in Microsoft excel 2007 it gives me error saying that

error inintializing menu,
object variable or with block variable not set.

kindly guide me what i can do for this. i m not getting exactly what is happening.

thanks & regards,
Vishruti.

View 3 Replies View Related

Openrowset Excel 2007

Jul 31, 2007

Haven't been able to find much information on using openrowset with excel 2007 xlsx files. I've tried the following with no success so far.

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml;Database=\serverfolderfile.xlsx;HDR=No;IMEX=1',
'SELECT f1 FROM [Raw Keywords$] WHERE f1 IS NOT NULL')

If anyone knows the correct way to do this please tell me.

View 3 Replies View Related

Excel 2007 And SqlServer Sp2

Feb 21, 2007

hellow all,

i installed SqlServer 2005 sp2 on my server.

now, how do i import excel 2007 files in SSIS? i don't have office 2007 installed on my computer, but i've got some .xslx that i would like to try ro import. i tried to create an OLEDB connection, but i don't know which provider to choose.

anyway, can i do it without the sp2 or office 2007 installed on my server?

thanks for tour reply!

View 5 Replies View Related

Importing Excel 2007

May 15, 2008

When importing an .xlsx file the number of columns stops at 255. Does anybody know how to get all columns imported?

Tried saving the file as text and that allows me to import all the columns but it would be much easier to do this directly from Excel.

Thanks

View 4 Replies View Related

Export To Excel 2007

Jul 17, 2007

Hello Everyone,

Is there any way in RS2005 to export to Excel 2007 format ?

The reason I'm asking is that we have a report that can potentially have more than 256 columns but for now, there is no way of directly importing to excel 2003 (.xls).

Is microsoft going to come out with an improvement to RS2005 or is there already a way to export to Excel 2007 to bypass the 256 column limit?

Regards,

Joseph

View 1 Replies View Related

Excel 2007 And SSIS

Feb 28, 2008

Hi Folks,
I have got a quick question, Is it possible to use office 2007 in SSIS, If so what would be the driver?
or Could we use JET 4.0 itself?

Any thoughts and help in this regard would be appreciated.

Zulfi.

View 3 Replies View Related

Export Data To Excel 2007

Jun 12, 2007

Hi Guys,

I am trying to export data from database to excel 2007 file on my machine.
I have downloaded the provider for office 2007 and I have XP with sp2 and SQL server 2005 with SP2.
I havn't installed office 2007 on my machine,but I have a excel file which is created in office 2007.To get acess of read and write i have downloaded office compatibilty pack too,So I can read and write into the file.
Now I am creating one SSIS package to export data into excel file.But I m not able to coause I am getting some errors like

"test connection failed because of an error in intializing provider. Invalid UDl file"

"Test connection is failed because of an error in intializing provider.Not a valid file name".

Please help or suggest how to export data from database to 2007 excel file.

Yogesh V. Desai. | SQLDBA|

View 10 Replies View Related

2007 Excel With SQL 2000 Report

Sep 9, 2007

Hi all

I am wondering if there is a solution for our current issue i.e. we can't export the query report from SQL report services into 2007 Excel.
We have no problem with Excel 2003.

Any help/reply would be much appreciated.

Cheers

View 9 Replies View Related

How Import Data Using DTS From Excel 2007?

Aug 10, 2007

Hi,

I wants to import data using DTS package from Excel 2007. I have tried this by using DSN but i'm not getting Excel 2007 types.

Please suggest me how to Connect to Excel 2007 using DTS package to import data.

Thanks!

View 3 Replies View Related

Excel 2007 AcquireConnection Error

Mar 14, 2007

I'm creating a small test package that copies a value from an Excel 2007 worksheet into a SQL 2005 database (SP2). When I do an Execute Task, I get the following error:

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager \loripMandEScorecardsSQLQueryExample.xlsx failed with error code 0xC0202009.

However, if I do a "Preview" in the Editor for this same Excel Source task that fails, the data comes up as I would expect. What am I missing?

Thanks in advance!

View 2 Replies View Related

Excel 2007 Import Woes

Apr 3, 2008

Has anybody seen this? Is there a configuration setting or something that needs to be changed?
Working with the development version of SQL 2005 that comes with Visual Studio

Problem: I can't seem to get IS to work with Excel 2007 files. I've tried both BIDS and Import/Export Wizard

I've got the connection set to use ACE
The datasource is: c:BranchList - 20080331.xlsx
the extended properties property is: Excel 12.0;HDR=Yes
Test connection succeeds
Preview succeeds
If I save the Excel file as tab-delimited text, BULK INSERT succeeds

But trying to run the package against Excel I get this error, over & over. I have not yet been able to get SQL2005 to import Excel 2007 data

TITLE: SQL Server Import and Export Wizard
------------------------------
Could not connect source component.
Error 0xc0202009: Source - 'Branches $' [1]: An OLE DB error has occurred. Error code: 0x80004005.

Error 0xc02020e8: Source - 'Branches $' [1]: Opening a rowset for "`'Branches $'`" failed. Check that the object exists in the database.

------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

View 5 Replies View Related

ODBC Connection To Excel 2007

Aug 10, 2007

Hello everyone,

Since I would like to use an Excel 2007 File (*.xlsx) as Data Source, I created an ODBC Connection. It worked fine so far: the connection is established, I get the data as expected in the "Query Designer tab" and I could insert the fields in my report. However, when I want to see the result on the "Preview tab", I get an error saying that the "Report Definition '/myReport' is not valid...".

I don't know what could be wrong in my Report... Am I missing something in the ODBC configuration?

My Connection String is as follows:
Dsn=pl_excel;dbq=C:PublicPL_DataSource.xlsx;defaultdir=C:Public;driverid=1046;fil=excel 12.0;maxbuffersize=2048;pagetimeout=5

I also tried to create an OLE DB connection but I got the same error...

Thanks for your help, I'm waiting for your suggestions...

View 2 Replies View Related

Report Formatting In Excel 2007

Jul 30, 2007

I am currently developing a report for users who insist on exporting to Excel 2007. When I export to Excel on my PC, the report formatting is fine (I am using Excel 2003), however, font sizing as applied in the report is lost when exported to Excel 2007 (i.e. font size 9 in the report is actually 10 in excel 2007). In Excel 2007, the data which runs onto two lines does not show up correctly - the second line is squashed below the first.

Any ideas on how I could resolve this?

View 1 Replies View Related

Export To Excel 2007 In SSRS

Feb 14, 2008

I am new to reporting services. I need to export more than 64K rows to excel from SSRS Katmai. Please let me know how to do this.

Thanks,
Priya

View 8 Replies View Related

Excel 2007 Cell Data Query

May 1, 2007

Hi,

I have an Excel 2007 file which contains values in specific cells like A23, D30 etc.
I want to populate the values in these cells using SSIS packages into individual rows of an SQL table.
How can this be achieved ?

Cheers
Sam

View 1 Replies View Related

Crashing Pivot Tables In Excel 2007 (SP 1)

May 22, 2008

We are using MS Excel 2007 Pivot tables to access en SSAS 2005 Cube. Farly often when we reopen an excel spreadsheet with one or more pivot tables we get an error like this:

Excel found unreadable Content. Do you wish to repair

When we click yes the following log is shown:
Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition2.xml part (PivotTable cache)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable2.xml part (PivotTable view)
Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
And all the pivot tables are converted to plain text.
I have read about this in KB 929766 but this do not apply since KPIs are not used.
The KB 943088 is more interesting but after upgrading all user with SP 1 the problem is still there, mostly when we open old excel-files that has been created without SP 1 but opened and saved once with SP 1. After that we are not able to open them at all, either with or without SP 1 installed.
Is there some way to ��save�? pivot tables from destruction? I can��t ask the users to rebuild all there spreadsheets that have been created prior SP1. What will happen when there is a new SP for Excel? Rebuild all spreadsheets and pivot tables again?

View 18 Replies View Related

Excel 2007 Data Mining Add-in Disappear

Oct 10, 2007

I install add-in and run fine for a while, then all of sudden I could not see Table Analyze tool and data mining tab at my ribbon. I re-run server configuration and re-connect to DMAddinDB (remote server, but I am the administrator), but data mining add-in and table analyzer still not showing at my ribbon.

Then I uninstall DMAddin, re-install it, go through configuration again, but still the tabs are not showing up.

Any idea you can help me get my add in back?

View 12 Replies View Related

Excel 2007 PIVOT As Data Source

Jan 18, 2008

Hi,

We have a excel 2007 file with a Pivot Table in it. We would like to use the same as data source (But all the source fields as it comes for Pivot). The key issue is that the data to the pivot is from a connection and points to DB - but there is no access to DB. So the Excel is static to us with a PIVOT in it.

Is there a way to get all the data that is avaialble as a source for pivot.

Ex. The select query has co1,co2....co 11 from xxxxx
whereas the PIVot HAS ONLY cO1, CO2 AS ROW, CO3,CO4 AS COL, CO5 AS VALUE AND CO6,CO7 AS FILTER AND OTHERS MISSED OUT IN PIVOT.

THe SSIS as such provide Excel 2007 access to Access OLE DB driver with Excel 12 setting in advanced tab. But not sure whether we can give the range (or) a way around ot get all the data as available in excel regardless of what is used only in the pivot.

Regards,
kart

View 4 Replies View Related

Extract Data From Excel 2007 On Vista

Jul 16, 2007

Hello all,

I am in the process up testing an upgrade from XP to Vista, and the only thing that I am running into is that my linked servers for Excel that I defined no longer work.

The spreadsheet that I am trying to open is in the 97-2003 format (not the 2007 format), yet I keep getting the same error message "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEST1"

Has anyone successfully created a linked server to an Excel spreadsheet on Vista, and if so, please can you provide some insight into what I am doing wrong.

I tried creating a linked server on an XP box running MS Office 2007, and it worked without any issues.

All comments welcome.

thanks

Steve

View 4 Replies View Related

No Excel 2007 Table Support In SSIS?

Aug 6, 2007

When I connect to an Excel 2007 workbook using the new Microsoft.ACE.Oledb.12.0 provider in SSIS 2005, I notice that any tables that I've created in the worksheet are not recognized in SSIS.

In the OLE DB data source component (using the "Table or View" data access mode) the any table(s) I've created are nowhere to be found in the drop down list. Similarly, when I constuct a simple SQL query on the workbook, such as "SELECT * From MyTable" it returns the error:

Microsoft Office Access Database Engine
Hresult: 0x80004005
Description: "The Microsoft Access database engine could not find the object 'MyTable'. Make sure the object exists and that you spell its name and the path name correctly."

I know I have the name right -- I can use structured references to my named table in the worksheet without any problems.

Does the new ACE provider not support Excel 2007 tables? Am I stuck with using "overlapping" cell references to capture data from tables in my worksheet?

View 5 Replies View Related

Problem With Date Output In Excel 2007

May 7, 2007

When we export data mining output including dates through Reporting Services to an Excel spreadsheet, Excel 2007 subtracts 4 years from the dates. Example, the date 11/16/2006 appears in Excel 2007 as 11/16/2002. How should this be handled? Workaround, bug fix, patch,etc.? Thanks, Sam

View 5 Replies View Related

Excel 2007 Data Source/Destination

Dec 5, 2007

I've SSIS 2005 SP2 and Excel 2007 installed. How come I do not see Excel 2007 on the Excel version list?

Thanks,

Ash

View 7 Replies View Related

Creating Simple Report Using Reporting Services SP2 And SharePoint 2007 Integration

Feb 1, 2007

I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:

When I access http://<server>/ReportServer, I see the server name of my SharePoint site.
When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site
When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).

The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.

How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.

View 5 Replies View Related

Creating A Cube...and Some ?'s

Jan 26, 2004

1.Create a table. The table must contain four columns of your choice and at least ten rows. Create a meaningful example of your own. The last column in the table must be a quantity. Provide output showing your CREATE TABLE and INSERT statements. Also include output showing their successful execution.

2.Create a ROLL-UP query using the table you created in problem #1 Provide output showing your SELECT statements and the resulting output rows. Next use the TRANSCT SQL help function of SQL Server and write definitions of the following SQL statements:
a.IS NULL-
b.GROUPING-
c.AS-

3.Create a CUBE query using the table you created in problem #1 Provide output showing your SELECT statements and the resulting output rows.

4.Create the following CUBE queries using the table you created in problem #1. Provide output showing your SELECT statements and the resulting output rows.
a.A CUBE query with Grouping used to distinguish Null values.
b.A CUBE query showing a multidimensional cube.
c.A CUBE query created using a view. For this problem you must not only create your view but query it and display the results.

5.Create one example of a query using COMPUTE and one example of a query using COMPUTE BY. These queries should use the table you created in problem #1 Provide output showing your SELECT statements and the resulting output rows.

View 3 Replies View Related

SQL 2005 X64 Linked Server To Excel 2003/2007

Aug 27, 2007

Is there a way to create a SQL 2005 x64 Linked server to an Excel (or Access) 2003/2007 file? In SQL 2005 32bit this was possible. Does anyone know of a solution or a work around?

View 3 Replies View Related

Importing Excel 2007 And/ Or DBF Files Into SQl Server 2005

May 12, 2007

Greetings,

I'm having a tough time importing some of my legacy database into sql.
I have a number of dbase (IV) files I need to get into SQL. I have tried building a SSIS package with either an foxpro oledb connection or a jet 4.0 one, none of them work bec. of inconsistencies in the data format in my tables (e.g. date fields, etc).

I have tried to save the .dbfs as excel 2007 files, taking advantage of the larger space that comes with '07. Problem is you can't use the import/export wizard with 2007 for some reason and I haven't been able to create a package with the access 12 oledb as I have read.

I have to get some crucial data out of that old system and into the new one and I can't seem to be able to import them properly.

Any hints on what I should do ? (maybe I'm doing something awfully wrong)

Thank you for taking the time to answer my question,
Val

View 12 Replies View Related