Microsoft SQL Analysis Services

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

On Excel 2007 you have the option of connecting to SQL Analysis Services, something I cannot find on Excel:Mac 2008. Is this a planned feature of Excel:Mac 2011 or is this a reserved feature for Windows versions? <br><br>Thank you in advance, <br><br>Valerio
0
Valerio
3/11/2010 10:07:18 AM
mac.office.excel 1146 articles. 0 followers. Follow

3 Replies
3483 Views

Similar Articles

[PageSpeed] 22

On 3/11/10 5:07 AM, Valerio@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel On Excel 2007 you have the option of connecting to SQL Analysis
> Services, something I cannot find on Excel:Mac 2008. Is this a planned
> feature of Excel:Mac 2011 or is this a reserved feature for Windows
> versions?
>
> Thank you in advance,
>
> Valerio
For planned features of the next version of Office, you will have to 
keep watching Mactopia. Many items are announced in the blog.

-- 

Bobgreenblattatmsndotcom
0
Bob
3/11/2010 1:01:55 PM
Thank you for your reply. I did take a quick at the blog but I was not able to find any relevant information. I think I will take another look at it however... <br><br>If anyone knows anything about this or if there is a way of making it work with Office:Mac 2008 please let me know... <br><br>> On 3/11/10 5:07 AM, Valerio@officeformac.com wrote: <br>
> > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: <br>
> > Intel On Excel 2007 you have the option of connecting to SQL Analysis <br>
> > Services, something I cannot find on Excel:Mac 2008. Is this a planned <br>
> > feature of Excel:Mac 2011 or is this a reserved feature for Windows <br>
> > versions? <br>
> > <br>
> > Thank you in advance, <br>
> > <br>
> > Valerio <br>
> For planned features of the next version of Office, you will have to  <br>
> keep watching Mactopia. Many items are announced in the blog. <br>
>  <br>
> --  <br>
>  <br>
> Bobgreenblattatmsndotcom <br>
>
0
Valerio
3/11/2010 1:44:02 PM
Bob Greenblatt wrote:
> On 3/11/10 5:07 AM, Valerio@officeformac.com wrote:
>> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
>> Intel On Excel 2007 you have the option of connecting to SQL Analysis
>> Services, something I cannot find on Excel:Mac 2008. Is this a planned
>> feature of Excel:Mac 2011 or is this a reserved feature for Windows
>> versions?
>>
>> Thank you in advance,
>>
>> Valerio
> For planned features of the next version of Office, you will have to
> keep watching Mactopia. Many items are announced in the blog.
>

For those wondering what SQL Analysis Services is all about, see this:
http://msdn.microsoft.com/en-us/library/ms175609(SQL.90).aspx

-Jim

-- 
Jim Gordon
Mac MVP
Co-author of Office 2008 for Mac All-in-One For Dummies
http://tinyurl.com/Office-2008-for-Dummies
0
Jim
3/11/2010 11:41:56 PM
Reply:

Similar Artilces:

Microsoft Exchange 2007 command shell
I am trying to create the Mailbox user through command shell. When I write "New-Mailbox -password $password" its not asking for password. Its giving following error : New-Mailbox : Cannot bind argument to parameter 'Password' because it is null. And also one more thing I want to specify password directly in command so it should not prompt for password?How can we do this? Thnaks Ashwin Sancheti Have you looked at the help for this? Get-help new-mailbox will display the help. From there, here is the example. EXAMPLES $password = Read-Host "Enter password"...

Service Pack 1 for server 2003, broke my Exchange
I have an exchange server here and I believe my problem to be more on the networking side. After updating to Service Pack 1 for server 2003 I notice that I am loosing connectivity on one of the subnets that the server has. Now I know it's the correct thing to do, but the server was configured with two IP Addresses from two different subnets; 10.0.0.0/24 and 192.168.1.0/24. This was done so that the office on the 10.0.0.0/24 network could talk to exchange and do their tasks. The 192.168.1.0/24 Address was added to allow email to be sent from the outside world to the exchange serve...

Does the latest Office Service Pack allow the use of the PDF Maker toolbar in Excel?
> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3194459926_4136162 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit As I recall, it was the presence of the PDF Maker file that caused the harmless �Autoexec compile� error. Has that been resolved? --B_3194459926_4136162 Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable <HTML> <HEAD> <TITLE>Does the latest Office Service Pack allow the use...

Performance Issues and SQL
We recently customized CRM and deployed it to the sales agents here, and many people were complaining about performance, rightfully so we were running on 3.2 GB of our PF when we only had 3GB of RAM installed. We had exchange and SQL on the same box, so we bought another server and put SQL on that box as well as some files to share the load. Now the hardware is running properely however we are getting a different kind of performance issue. Now contacts and lead detail windows that open when you double click on an entry in the list take an unacceptable amount of time to load, arou...

Cannot open Microsoft Outlook
When I click on the outlook icon, or choose from the start menu I get an error stating, "cannot open microsoft outlook" I tried to repair from the install wizard and I uninstalled and re-installed. The computer is running win 2000 pro. Please help! ...

Count records in an SQL string
I have code-generated SQL string, which is to be the RecordSource of a form. How do I do a record count before I open the form (I want to avoid opening if there are no records)? Cancel the Open event of the form if there are no records. Something like this: Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then Cancel = True MsgBox "No records" End If End Sub -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather tha...

Microsoft Office 2000 Professional
My computer currently uses Microsoft Windows 98 as an operating system. On this Computer , I succesfully manage a website for a Snooker League using Publisher from Microsoft Office 2000 proffessional. As well as using many other aspects of the Microsoft Office 2000 proffessional , programme. As my computer is now nearly ready for replacement, my question is : - If I purchase a new Computer with either XP or Vista as the operating system , will Microsoft Office 2000 proffessional work on the new computer and will I be able to continue managing the website. Regards, sarnia I have no exp...

Training Course available: Extending Microsoft CRM 3.0
The Extending Microsoft CRM 3.0 courseware is now available for order. Details about this course for developers is available at: http://www.microsoft.com/learning/syllabi/en-us/8531afinal.mspx Certified Partners for Learning solutions (CPLS) can start to deliver this training. Normally, you should be able to locate available training from the "Find training in a City near you" portion of the Course description on URL referenced above. But currently, it appears that the Class Schedules have not yet been uploaded for this course. I'm not trying to play favorites, but I am ...

Reporting Services Lists & CRM
Has anybody tried aligning column headings located outside and above of a Reporting Services' list to their respective fields within the list? Everything lines up fine in Visual Studio's preview of the report. But, when published to CRM, the fields within the list are slightly shifted to the right or left of their intended position below the headings. The accumulative shift can be substantial. I've tried just about everything, including the use of fixed-width fonts. Nothing works, except placing the column headings within the same list... which has the obvious and undesirable ef...

CreateSalesOrder Web Service returning exception
When attempting to create a new Sales Order via the CreateSalesOrder web service in GP 9, I receive the following error: -------------- Begin Error ------------------------ A validation exception has occurred. Validation Errors: - The U of M for the item is not specified in the item price list as the default selling U of M. - U of M does not exist for the Unit of Measure Schedule being used. - PriceListKey is blank. It must be passed in or a default must exist for the transaction. -------------- End Error ------------------------ If I specify a Unit of Measure for each SalesOrderLine,...

GM Card and Direct Services (2-Way)
I'm trying to setup online services for a GM credit card in M03. Has anyone done this successfully, for Direct Services (2-Way)? GM/(Household Bank)'s helpful tech support say they support Direct Services (2-Way), they even verified this a second time. Unfortunately, Money doesn�t have them in their list of financial institutions. After pointing tech support to the list on Money's website, they acknowledged that 'Household Bank ... does not seem to be currently listed'. They suggested I contact Money Support directly to address this. Strangely, though, in M03, I ...

Service Call Module #2
Does anyone know if there is an automated solution to create Equipment records via eConnect or Integration Manager Wennsoft ServiceManagement does that as part of the core product. It is also a far better product. "jav" wrote: > Does anyone know if there is an automated solution to create Equipment > records via eConnect or Integration Manager ...

Transport Service 12018 Exchange 2007
Hi, I have a message in my event viewer ( transport service 12018 ) telling my certificate wille expire soon , it is about the certificate create during installation. What can I do to solve it and how ? Thanks in advance Regards On Wed, 19 May 2010 18:35:10 +0200, "Dirk" <dirkc@netbel.be> wrote: >Hi, > >I have a message in my event viewer ( transport service 12018 ) telling my >certificate wille expire soon , it is about the certificate create during >installation. > >What can I do to solve it and how ? https://exchangeped...

Networking Microsoft outlook.
Im trying to network our computers here at the office. What I want to do is offer MS Outlook on all three of the computers, which MS Outlook is installed on all three. So what I want to have accomplished is having it so that, when an email comes in to any given email box, that it distributes that email to all three computers MS outlooks, and also does the same for as sent items. So is there any way to do this? You need a mail server as Outlook is only a PIM/Mail client. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN vir...

Microsoft Security Essentials 01-31-10
What is the best news group to subscribe to for Microsoft Security Essentials? I want to hear user comments and learn suggestions. Thanks This is a multi-part message in MIME format. ------=_NextPart_000_01BD_01CAA24C.D562DA00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable since it is still in BETA there are no public forums at this time. mikeyhsd@hotmail.com "mpdd" <mpddberry@yahoo.com> wrote in message = news:%23o3FZ7moKHA.5260@TK2MSFTNGP02.phx.gbl... What is the best news group to sub...

how can i open a .mdb file made in 2000 with office microsoft 97
my mom made a .mdb disc and i seem unable to open it. she has office 97 on her computer and not sure what is on mine. how can i open this file for it has important info to which i need. i can't ask her for she died recently. please can someone help me? First of all you need to see if you have Access installed on your computer. Go to Start, Programs, and look for something like Microsoft Office. See if Access is listed. If not you probably don't have Access and can't open the file. You also check by opening up another Office product, say Word, and then going to Help, Abo...

Time field conversion to SQL 2000
I have an Access 2000 db that I want to upsize to SQL server 2000. Some fields are of date/time data type and show only time in hours and minutes, These fields will not convert. What should I do??? (Fields of date/time type that show short date will convert.) Thanks a M for your help. Magnus Add a phony date to them. Usually the system minimum is used. (Sometimes the max.) Depends on what you need. Once the data is stored in SQL Server you can still display just the hours and minutes. Actually, Access *does* store the date/time field with a date. So you may not be displaying it but i...

Multi-user FRx using SQL Server
We recently moved our GP database from a single install to our SQL server. However, FRx is still pointing to the original local database. How can I configure FRx to connect to the new DSN? Thanks. On the client PC that has FRX installed, identify the ODBC system DSN that FRX uses. Click on configure and change the server name to read newserver. "CDMan" wrote: > We recently moved our GP database from a single install to our SQL server. > However, FRx is still pointing to the original local database. How can I > configure FRx to connect to the new DSN? > >...

SQL Database Backup critical problem transaction log
I am having a serious problem with a particular database. DPM says that the database is inconsistent and no attempts to do a consistency check seems to clear it. Even worse, the transaction log of this database has grown to such a size that any action on the database gives an error saying that the transaction log is full. Even attempts to expand or add to the transaction logs gives this error. The sys.databases table for the database says that the reason why the transaction log cannot be reused is 2 - backup. On Nov 25, 5:31=A0pm, Innovations <Innovati...@discussions.m...

the microsoft wav file
I have lost my copy of the microsoft sound wav file. If any one could help me to obtain another copy it would be most appreciated Did you ring Microsoft? They own it! It's not ours to give you, we only have a licence to use it, not a licence to give it away :-) On 3/12/06 5:36 AM, in article 9F8D74B2-AFB6-42D3-A049-88884D98E476@microsoft.com, "leo1052" <leo1052@discussions.microsoft.com> wrote: > I have lost my copy of the microsoft sound wav file. If any one could help me > to obtain another copy it would be most appreciated -- Please reply to the newsgroup ...

Problem with Analysis Cubes for GP 10 FP1
I got it installed but when I try to run the SSIS packages I get an error. Error: Error 0xC0014049 while preparing to load the package. Cannot find folder "\DynamicsGPWarehouse\DynamicsGP_DynamicsWarehouse_CompanyMaster". What did I setup wrong or how do I fix? -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com Is the folder, in fact, there? I recently installed it using as much of the default settings as possible and had no problems. -- Charles Allen, MVP "Japheth Nolt" wrote: > I got it installed but when I try to run t...

SQL Server 2005 Compatibility Level 80 to 90
Hello, I would just like to know whether there are implications on changing the compatibility of the SQL Server (2005) from level 80 to 90? We are on version 10 of Dynamics GP. And in terms of changing the level to we need to do it across the system databases as well (master, model, etc)? TIA timber Changing the compatibiltiy level will only impact your ODBC connection, since you will have to switch from your current SQL Server ODBC driver to SQL Server Native Client, which is only supported by SQL Server 2005. Microsoft Dynamics GP 10 has been optimized for SQL Server 2005 so you ...

MDA Creating Analysis Defaults
Does anyone have a suggestion on a faster or automated approach to creating Analysis defaults? I have over 2000 GL accounts that I need to assigned one or more Groups IDs to. Amanda, Here goes an idea: 1) Record a GP macro for the first analysis default. 2) Create a Microsoft Excel spreadsheet with the accounts you need to assign -- hint, you can export the accounts with SmartList to Excel 3) Use Microsoft Word to create a mail merge on the macro. Use the Excel spreadsheet as the source for your mail merge. 4) Edit the merged macro to extract special characters and what's not plac...

Cdrehekqamrp service !
Anybody knows of that service ? I have for the first time discovered it now No connections, no other information, no file onhard disks having that name, no info ! Have recently installed Sony's Handycam softwares ( no very easy !!!) TIA for informations: web search gives not even a single hit ! Pivert I've not heard or even seen that as yet. to test it try disabling it and see if you can start your new software after. -- JAM_EZZ On 13 Jun 2010, "MoiMeme" <antispam@no.spam> wrote in microsoft.public.windowsxp.general: > Anybody k...

SMTP Service Stops
This has happened twice: 1. After server restart all mail flow stops (internal and external) 2. Messages Pending Submission queue has items in it which do not move - queue is flagged "active" 3. All exchange services are running, but SMTP Virtual Server is stopped in Exchange Manager 4. A restart of IS causes more items to appear in the queue 5. Restarting other Exchange services has no effect 6. Mail stops at the time of the reboot (first item in the queue is from the time of the reboot) 7. Event logs look clear of Exchange-related errors but these errors appear as the server i...