Changing OLAP Pivot Table Connection Source

I have numerous spreadsheets that have pivot tables pointing to an
OLAP Cube via a connection string.  Is there an easy way (either
automated or manual) to change the connection string to point to a new
version of the OLAP Cube?  I can edit the connection properties and
navigate to the new .odc connection file, but get an error saying "The
OLAP provider returned an unexpected number of dimensions."
0
8/18/2009 4:56:29 PM
excel 39879 articles. 2 followers. Follow

0 Replies
400 Views

Similar Articles

[PageSpeed] 40

Reply:

Similar Artilces:

Cannot change line/object color in Publisher 2002
Anyone who can help: I'm using an older version of Publisher (2002). I was working on a floor plan for a project when suddenly, all the lines and borders disappeared. I am now unable to make any selection to change the line color--the selection defaults to a blank option no matter what color I choose, creating essentially invisible objects and lines in my files, even new ones. I uninstalled and reinstalled Publisher twice to no effect--the problem persists. (Interestingly, the same files when opened in Publisher 2002 on another machine display fine.) Is there something else that co...

Pivot table will not returned value's
Goodmorning Everybody, Yesterday i made a macro which gets the value from Cell AM1 and fits it as a criteria in a Pivotfield in another file. The macro as seen at the end, works smooth except for this part: Set pt = Sheets("Table Combi").PivotTables("PivotTable3") Set pf = pt.PivotFields("ARF Code") ActiveSheet.PivotTables("PivotTable3").PivotFields("ARF Code").CurrentPage = "" & k & "" If pf.CurrentPage <> " & k & " Then pf.CurrentPage = "(Blank)" End If Does ...

Change line to bar in Line
Hope someone can help on this one...I have 4 data series that I am trying to plot on a Line-Column chart. I need 3 of these to be columns and one to be a line. It is defaulting to 2 columns and 2 lines. Does anyone know how to override that default, so I can change the one line (basically the 3rd data series) to a column? Thanks :-) Select the series you want to change, then on the Chart menu, choose Chart Type, and choose the new type to assign to that series. Next time, starting from scratch, make a column chart with all four series, then change the one to a line. - Jon ------- Jo...

Tables/Queries
Hello, I've seen some posts regarding a similar problem to what I'm having but cant find the resolutution! I have a database with tableA which contains basic inventory info. I have a field in tableA named location. There is a second table (tableB) which has a list of all the locations our company delivers to. I've been warned to stay away from lookup fields, so I'm using combo boxes on the form to look up the location and then populate the location field in tableA when the value is selected. Here is the issue (and again, I've found some posts similar): Running a...

sql server 2000: most frequented tables -> script wanted
hallo, could someone please provide me a script, which throws the most frequented tables used within a sql server 2000 database? i am aware of one (see below) for sql server 2005, but due to new functionalities within sql server 2005 it can not be backported. SELECT TOP 20 db_name(database_ID), object_name(object_id), leaf_insert_count, leaf_delete_Count, leaf_update_count, range_scan_count, row_lock_count FROM sys.dm_db_index_operational_stats(NULL, NULL, NULL, NULL) WHERE db_name(database_ID)='<Datenbank-Name>' ORDER BY leaf_update_count desc --oder ...

25 changes to 35
When the value of 25 is entered into a cell, the screen returns the value of 35. I have scanned for viruses, tracking software, defalt setup values, uninstalled an reinstalled excell, updated, etc. Still I get a value of 35 when I enter 25. Help. Hi! Check Tools>AutoCorrect Options and see if someone is playing a trick on you! Biff "David Sound Tech" <David Sound Tech@discussions.microsoft.com> wrote in message news:598DF7E4-04EE-4CE4-9248-7D5E445FB182@microsoft.com... > When the value of 25 is entered into a cell, the screen returns the value > of > 35. &...

Query to Access : does'nt see tables
Office 2000 SP3 FR From Excel / MS Query, I want to read data in Access tables. I choose the mdb file and so MS Query displays this error message (translated) : "This data source does'nt have any visible table". Original in French : "Cette source de donn´┐Żes ne contient aucune table visible." I transfert my data to a new mdb file : it work's few times (!), then the error message appears again. How to resolve this problem ? Jacques. Gotcha ! MS Query does'nt accept a file name with 2 dot inside ! Example : MyFile.mdb --> Ok My.File.mdb --> "...

% of running total in pivot table
Does anyone know of a way to include in a pivot table a % of total for a running total. I'm not sure if I'm saying that right, so this is what I'm trying to do 1Day 2Days 3Days 4Days 5Days # completed 100 50 20 20 10 # completed (running total) 100 150 170 190 200 % completed (of running total) 50% 75% 85% 95% 100% The last row is what I'm struggling with. I can easily get ...

Changing Depre Life
I have a number of fixed assets that I need to extend the life. Their in service date was in the prior fiscal year. If I go to the Asset Book screen & change the life, <save> the screen & choose "Year" as the reset option (not Life or Recalculate), shouldn't I get some financial entries reflecting the current year adjustment of depreciation? I tried it in the test company & I'm not getting any GL entries. Any help is appreciated. Merle Merle: You have to run the GL Posting Routine at Tools>Routines>Fixed Assets to generate the GL entry. Fr...

About worksheet change event.
I wrote a code and somewhere, I want to restrict any changes with multiple cell selections, "except" adding a whole row by right-clicking on the row number bar. How can i do this? Maybe you could test like this If Target.Rows.Count = 1 And Target.Count = Rows.Count Then ... -- HTH RP (remove nothere from the email address if mailing direct) "serdar" <s@s.com> wrote in message news:Og4LA$Y%23FHA.3340@TK2MSFTNGP12.phx.gbl... > I wrote a code and somewhere, I want to restrict any changes with multiple > cell selections, "except"...

Pivot report without the drop downs
I created my Excel 2007 Pivot table with the data I need. Now, I want to remove the Report Filter Drop Down showing lot more information than my peers or superiors need to see or even try to view. The same is true for the Rows Labels and Column Labels with the drop down. I figured out how to remove the plus signs by using the "Show/Hide" on the Options on the Ribbon. I tried the copy and paste but for some reason I can only do .txt or object. There is no paste special. Then the format is not the same. Do anyone have an answer for this problem? Thanks a million, Ty ...

Add more than one series to a pivot chart using VB MS Access continued...
I'm trying to programmatically create a stacked bar pivot chart. Using "Programming Microsoft Office Access 2003" by Rick Dobson, I've created the chart. However, it doesn't distinguish between the different values for the series. Does anyone have any suggestions on how to create a chart using one column containing three values for the series? Essentially, this is a continuation of a previous post: http://groups.google.com/group/microsoft.public.access.formscoding/browse_thread/thread/e23f3506a6d561a0/674295d410a71cf9%23674295d410a71cf9" Any help is greatly appre...

Summing a selection of lines in a pivot table
Hi all, Probably a totally newbie question on pivot tables but I can't seem to find out how it works. Here's my problem: I've got an Excel worksheet that (coming in from jet reports) contains something like #Asset 1 Description A1 Total A1 Mapping A1 = X1 #Asset 2 Description A2 Total A2 Mapping A2 = X1 #Asset 3 Description A3 Total A3 Mapping A3 = X2 #Liability 1 Description L1 Total L1 Mapping L1 = X3 #Liability 2 Description L2 Total L2 Mapping L2 = X4 #Liability 3 Description L3 Total L3 Mapping L3 = X4 This last field, mapping, is what's important for my pivot table; it...

VBA to export large tables from Excel to SQL Server
I have spreadsheets that I distribute to users. I want Excel VBA to export large tables (2000+ rows) into a remote SQL Server 2005. I am able to successfully do this with the following generic code, but it is too slow: Dim con As ADODB.Connection Set con = New ADODB.Connection con.Open "Driver={SQL Server};SERVER=<server>;DATABASE=TestSample;UID=<id>;PWD=<pw>;" con.Execute "INSERT INTO ... SELECT * FROM ..." 'Looping this for each row It takes over 10 minutes because it does it one line at a time. I've also tried l...

Change the default Calendar
Hej to all I have outlook 2010 with 2 calendars, calendar and work. By default the default calendar is calendar, but I would like to be work, since calendar have almost my private things, there is a way to change the default calendar to work. Thanks to all. Sofia No, you'll have to copy over the items from one to the other. Personally I don't use 2 calendars for this but use a single calendar and categorize my appointments accordingly. For details see; http://www.msoutlook.info/question/191 -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft...

RWW, VPN, Exchange connection problems
Running SBS2003 on an HP server. 3 PCs used by onsite staff. 4th PC used for remote access via RWW. Having intermittent connectivity issues. I sign in remotely using an XP workstation w/RWW. I have another PC that I use to access Exchange, and occasionally connect with VPN to access files on the server at the office. I keep getting dropped on RWW with the error "VBScript Remote Desktop Disconnected. An internal error has occurred". When that happens, I also notice that my Oulook client on the other PC shows an error that the connection to Microsoft Exchange has ...

Strange connectivity issue
Windows XP SP3, Dell laptop. Cannot ping the default gateway, which is our router. Can ping any other computers on the subnet, either by hostname or IP. Other computers on the subnet can ping this laptop, either by IP or hostname. Cannot ping the laptop from the router. The laptop has built-in wireless. If I enable that, I can ping the router's IP address. I tried resetting TCPIP with this command: Netsh int ip reset Didn't help. Windows firewall is disabled. The computer does not appear to have any viruses. Nothing in Event Viewer. I'm stumped. Any ...

Publisher mailmerge error message, invalid office data source
I am trying to edit a mailmerge database I started in publisher, but I keep getting an error message, "This is not a valid office data source". But it was just fine earlier. Are you creating the list in Publisher? What version Publisher? Look in "My Documents", "My Data Sources", is your data base there? Is there a number associated with your error? -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Obrother" <Obrother@discussions.microsoft.com> wrote in message news:31B77242-6579-4B64-9...

Connectivity Issues
We have recently migrated to a new exachange server, still running 5.5 though. We reconfigured all of the outlooks clients to point to the new server. For some reason, some of the clients continue to function slowly, with a message coming up saying something to the effect of "Please wait while outlook accesses data from FS1 (the old exchange server)". So the clients are looking for something from the old server, which is no longer. We have totally wiped all email settings multiple times, but the problem continues. Any ideas? What about Public Folders? Did you replicate them ov...

Pivot Tables #9
Ello I have a list like below Ref Client Name Team TeamMat 1 John 1 Ia 2 Steve 1 Ima 3 Andres 2 Jiv 4 Micel 1 Ima 5 Miquel 2 Jiv I wante to create pivot table to count the unique number of people in team, above team 1 has 2, team 2 has 1 Cant seem to do it with pivot table, is there way or create different type of table useing formulae Thanks for hel Tibow Hi Tibow b...

Change the name of an auto save
I am trying to write a macro that will save the file to a specific cell reference. The reference is a specific name that is automatically generated by another macro function. Any suggestions on how I could do this? Cheers IS thsi what you want? Sub SaveMe() sFilename = Format(Worksheets("Sheet1").Range("A1").Value) ans = MsgBox("Save file as " & sFilename) If ans = vbOK Then ActiveWorkbook.SaveAs Filename:=sFilename End If End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Y...

Auto date changing in Excel is maddening
I'm using MS Office Excel 2003 (11.6113.5703) to post data that spans over several days. sample plot http://peswiki.com/index.php/Directory:Bedini_SG:Replications:PES:Sterling_Allan:Data:Exp10.4_Different_Standing_Discharge_Rates or try http://tinyurl.com/6f8zn We had to jump through all kinds of work-arounds in order to accomplish this. It was not a straight-forward process, though it should have been. When I enter the date format, for example, as Format > Time > 3/14/01 13:30 And then enter 11/17/04 0:30:30, it enters okay, but when I double click on the cell to edit it, Ex...

changing the scale from hours to days in the Resource Usage view
My current Resource Usage view shows my resources and the hours allocated for each resource in hours. How can I change this view so that it tells me the allocated effort for each resource in days, as opposed to hours? thanks in advance. Tools > Options > Schedule > Work is Entered In.... - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > My current Resource Usage view shows my resources and the hours > allocated for each resource in hours. How can I change this view so > that it tells me the allocated effort for each resource in days, as > ...

How do I change the color of tabs in word 2008 notebook layout?
I've been trying to figure out how to change the color of the section tabs with no success. Does anyone know how to do this? In article <ee88f72.-1@webcrossing.caR9absDaxw>, somnium@officeformac.com wrote: > I've been trying to figure out how to change the color of the section tabs > with no success. Does anyone know how to do this? Right- or ctrl-click the tab and choose a color from the Section Color popup. I'm looking for the same thing; in addition - how to delete extra tabs. Ctrl-/right-click a tab, and you can change its colour as well as delete the tab (a...

change cells contents from vertical to horizontal
I need to copy from one workseet the values in cells that are arranged vertically into another worksheet and the values need to be arranged horizontally. Can this be done? If so, how? Select the data to be copied>Copy>Select target cell>Right click>PasteSpecial>select 'Transpose>OK If this post helps click Yes --------------- Jacob Skaria "GailH" wrote: > I need to copy from one workseet the values in cells that are arranged > vertically into another worksheet and the values need to be arranged > horizontally. Can this be done? ...