Analysis Cubes SQL 2005 server

Hi there

I have installed Analysis Cubes SQL 2005 firstly without SP2 and then with 
SP2. The install is successful and I created a job to run daily at 3am.  I 
tested the job by executing it manually and it run without any problems.  It 
runs for 5 companies including TWO. When I analyse the data in the 
GPDynamcisWarehouse tables, all the data for all the companies exist in the 
GLAccountMaster, but in the sales tables it shows only the TWO data.  

Why does this happen
Regards
Robin
-1
Robinv (41)
8/7/2008 9:50:01 AM
greatplains 29623 articles. 2 followers. Follow

0 Replies
377 Views

Similar Articles

[PageSpeed] 32

Reply:

Similar Artilces:

Microsoft SQL Server Express 2005
Does anyone have experience of using this engine rather than Jet with MS Acess 2003. Is there a restriction on the number of clients you can link to the engine. Because it is true client server architecture rather than file server is it worth the additional learning curve in working with SQL. hi, simcon wrote: > Is there a restriction on the number of clients you can link to > the engine. For limitations see http://msdn2.microsoft.com/en-us/library/ms165672.aspx > Does anyone have experience of using this engine rather than Jet with MS > Acess 2003. Yes. Use a .mdb and lin...

Register Analysis or EOD Report
Does anyone have a custom EOD or register analysis report that they would like to share? I cannot understand the register analysis report that was sent with RMS. Does anyone have a custom one that offers more clarity that they would like to share? Thanks, Nick I sent a custom Register Analysis active report to Nick on 3/4/2005. Kevin Pham "nick@realkiteboarding.com" wrote: > Does anyone have a custom EOD or register analysis report that they would > like to share? I cannot understand the register analysis report that was > sent with RMS. Does anyone have a custo...

Server Error in '/' Application #4
I run into this when generating any report in CRM 4.0. Object reference not set to an instance of an object. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] Micorsoft.CRM.Reporting.ReportServer.CreateCrmReportingException (ExceptioninnerException, String methodName, Int32 errorCode ) +102 The following message is one of many Stack Trace lines. Any one run into this Maybe you did not install the Reporting Connector for CRM ? Kay ...

Changing VAT Analysis to GST Analysis
Hey, I am in Australia, and we dont have the VAT....How do you change the Scripting to say GST instead of VAT? Call POSPartners Mr Richad Ranson ( richard@pospartners.com.au ) they have the Australian modifications. Afshin Alikhani = = = "Michael Thomas" <MichaelThomas@discussions.microsoft.com> wrote in message news:78F53E93-C30F-468A-BBC6-1E9EDFA190A9@microsoft.com... > Hey, > > I am in Australia, and we dont have the VAT....How do you change the > Scripting to say GST instead of VAT? Hi Michael, You can call me too. I have a major installation running i...

Outlook cannot download msg from server. Only download the descriptor.
Outlook cannot download msg from server. Only download the descriptor. Somebody pls help on this issue pls Thank in advance. What version of Outlook do you have? What sort of mail account? -- Jeff Stephenson Outlook Development This posting is provided "AS IS" with no warranties, and confers no rights "Muthu Kumaran" <anonymous@discussions.microsoft.com> wrote in message news:08ac01c3baf8$a36aff60$a101280a@phx.gbl... > Outlook cannot download msg from server. Only download > the descriptor. > > Somebody pls help on this issue pls > > Thank i...

"Unable to connect with incoming (POP3) e-mail server"
Time Warner checked it out, the "Incoming Mail Server" information is correct. I can send emails successfully. I can check my incoming email online, and I also receive them on my blackberry. Any ideas as to why I don't receive them on Outlook 2003? Thanks in advance! Without describing the problem, no. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. ALWAYS post your Outlook version. How to ask a question: http://support.microsoft.com/KB/555375 After furious head scratching, Vac asked: | Time Warner chec...

Great Plains 8.0 is compatible with Small Business Server Premium 2003
Hi team Great Plains 8.0 is Compatible with Small Business Server Premium 2003? Compatable?? Hmmm...dont know. But I have a couple of clients running GP 8 successfully on that platform. Does that help? Richard L. Whaley Senior Business Consultant 321-277-1341 btw.....there is some good information that might be helpful to you in some books on Dynamics GP/Great Plains available at www.AccoladePublications.com "Richard Padilla" wrote: > Hi team > > Great Plains 8.0 is Compatible with Small Business Server Premium 2003? > > > Not onl...

2003 server, network monitor and port display
On windows 2003 server, when using netmonitor to look at traffic between two servers, is it possible to display the port number used in either direction? e.g ftp port 21 etc port number is contained in the tcp:control bits section at the bottom of each transaction. "Rossb2" wrote: > On windows 2003 server, when using netmonitor to look at traffic between two > servers, is it possible to display the port number used in either direction? > e.g ftp port 21 etc ...

Seeking a fundamental resource for using Visual C++ 2005 Express
I am new to Visual C++, and have some limited skills with Objective C. I have designed a user interface in Visual C++ as a Form and now want to define methods and outlets for several of the widgets in the form. I have not been able to find any meaningful (to me) resources for how to do this easily within Visual C++. The tasks include, for example, specifying the action for a button that will take input from several user-entered textboxes, performing calculations and returning the results to other textboxes for display. It is essentially a more complex version of a temperature or money ...

New Server
Installed new servers - Small Business - Upgraded Ver 8 with Service Patch SP4a - then went to SQL 2005. Now Dynamics is running incredibly slow - have to wait for it to catch up all the time - even will flicker to another window open on a desktop while processing something. Anyone else have this occur? I need to speed it up Help Please Thanks Do you have any scheduled backups running? I know of a company that had hourly transaction logs using Veritas Backup Exec. When they installed sp4 for SQL Server, the whole machine bogged down. -- Charles Allen, MVP "Gloria" wrot...

Money 2005 vs 2006
I purchased 2005 last year, installed it and then uninstalled it because I had problems with it and so did others. My question is whether 2006 is worth getting. I am currently using 2004 but it's getting slower even though I archive. Does 2006 have better performance and file size handling than 2004? ...

DPM crashed when expanding SQL 2008 SP1 agent
Hi, i've a problem protecting a W2k*R2 box with SQL 2008 SP1. when i try to expand the agent, to select the items to protect, DPM crashed and the gui closes. No error events logged in the eventlog. DPM 2010 is installed on w2k8r2. the SQL Servers (agent) is installed in Hyper-V cluster on a CSV. -- Siebrand Feenstra Do you have SQL clustered by any chance on the production server, can you please send me the logs present under DPM_INSTALL_DIR\temp\*curr*.log after the crash has happened to praveend [at] microsoft [dot] com? Thanks, Praveen D [MSFT] T...

Terminal Server and GP 10
I know what the recommendations say but with the processing power of new servers on the market is anyone using Terminal Server and GP 10 on the same box with 30 or more users accessing GP (not at users are transactional users)? We have a client with 25 concurrent users running SQL, GP10 and terminal services. Consider full client installs for users doing a lot of posting and limit use of home pages, and you should be fine. They are now moving to a 64 bit server and want to run GP as a 32 bit virtual server to overcome memory limitations. "tpamike" wrote: > I know what ...

Sql Command for HQ
Can someone help me woth an SQL command to remove Items that wer imported on accident? I need to remove the items with the following information: Inactive=yes Price=$0.00 Date created=8/24/2009 Any help would be appreciated Thank-you Adam You can do so select * from item where inactive=0 and price=0 and convert(char(12),DateCreated,101)='08/24/2009' once satisfy with above query, then run this delete item where inactive=0 and price=0 and convert(char(12),DateCreated,101)='08/24/2009' "akpetshop" wrote: > Can someone help me woth an SQL command to remove It...

Can Visual Studio 2005 Standard do 64 bit development?
Can Visual Studio 2005 Standard do 64 bit development? "Peter Olcott" <NoSpam@SeeScreen.com> ha scritto nel messaggio news:NdWdnedCw9pkR7HWnZ2dnUVZ_qmdnZ2d@giganews.com... > Can Visual Studio 2005 Standard do 64 bit development? I would think so: http://msdn.microsoft.com/en-us/library/zcbsd3cz(VS.80).aspx Giovanni ...

OLAP cube in 2003
Hi all, I was always very glad with the OLAP cube in Excel 2002. Now, to my dismay when in Excel 2003 i try to create an OLAP cube I get the message that the OLAP Cube wizzard is missing. When installing the Office 2003 suite I checked run all from this computer. Is there anybody out here who knows what to do to activate the OLAP wizard in Excel 2003. Any help is greatly appreciated. greets, Sybolt ...

Separate data and analysis
Hi Group, hope you can help me with this question. I have an excel file which has 35 sheets, 1-31 sheets represent days of a month , 32-35 sheets are analysis and charts Ideally, I like to have 2 excel files, one with data only (for user to input data) and another one contains only chart and analysis (for manager) How can I do it? TIA Peter Select sheets 32-35. Right click and select move or copy, then select new book, click ok. GB "L.Peter" <no@spam.local> wrote in message news:O#T1nMarDHA.2244@TK2MSFTNGP12.phx.gbl... > Hi Group, > hope you can help me with this q...

Help with SQL Table/Field
I am trying to run a purchasing report that includes item #, qty ordered, qty shipped and qty canceled as well as promised date and PO#. I have all the data I need except for the qty shipped on each line. I've found all the data I need in tables POP10100 and POP10110. Can anyone help? Thanks. The QTYSHPPD values are in the POP10500 table... -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 "Grieves" wrote: > I am trying to run a purchasing report that includes item #, qty ordered, qty &g...

moving CRM installation and DB to new server
I have CRM 3.0 installed and running on a Win2k server, but I want to buy another Win2003 server and move CRM to this. How do i move the database and everything over without having users loose all data? how can i do this transition? If you are moving to another server within the same AD you can simply move the database .mdf and .log files over from your database to your new one and export the customization file from your original CRM server and import it into your new one. If you are moving to a server in a different AD you can use the redeployment tool. "justin" wrote: &g...

how do I report data of court cases ,results,analysis,.....
please provide guidance ,advise to report court decisions,case summury ,analysis and lessons learned for 150 cases .Including numbers, dates,parties involved,brief description,main issue and relavant legal opinion after the fact.I 'd like to use excel 2002 or earlier. I appreciate it and thank you in advance. Please feel free to send to Zeyad@sympatico.ca Are you sure you don't want us to FedEx it overnight to you? Frankly your post doesn't make any sense, what's your question? You post a question, someone here tries to answer it, don't expect us to research court c...

Money 2005 #40
We sold several mutual funds this year. However, in the tax estimator, capital gains on the sales are listed for only one of the mutual funds. Anyone else have this problem? Thanks Patricia -- ***This message has been scanned for viruses by Norton Utilities *** ...

SMTP in Exchange server 5.5
Hi, i need to change the default connection response that everyone receive after they connect to the SMTP port in Exchange 5.5. At this moment my exchange server give this response: 220 computer&domainname Microsoft ESMTP mail Service, Version: Version number ready at Date and time. I'd like that exchange server'll resposne with another message. How can I do? Pls someone help me. Thank you in advance, and sorry for my bad English. Sonia The servername can be changed, I assume youre running NT4, just change the hostname in TCP/IP settings Lasse Pettersson Humandata, Sweden ...

How to convert to SQL Server?
How do I take the data and relations stored in my MDB file and store it in SQL Server? Thanks, Siegfried One approach would be to start from the SQL Server end, using the data transformation services. -- Good luck Jeff Boyce <Access MVP> "Siegfried Heintze" <siegfried@heintze.com> wrote in message news:ufHaqS%233EHA.3000@TK2MSFTNGP15.phx.gbl... > How do I take the data and relations stored in my MDB file and store it in > SQL Server? > Thanks, > Siegfried > > ...

using a different smtp server
is there any possibility to allow users using exchange 2003 server to send there emails using ISP smtp server instead of exchange 2003 smtp? thank you in advance for your help. Adam > is there any possibility to allow users using exchange 2003 server to > send there emails using ISP smtp server instead of exchange 2003 smtp? > > thank you in advance for your help. > Adam Yes, but that's an Outlook thing, not an Exchange thing. What's your goal, and what's your setup? There may be a better way to accomplish what you wish. ...

Excel Solution for Data Analysis
Hello, I hope someone can give me some tips as to how I can best develop an analysis for 5 different worksheets. Basically, each worksheet is for a different store location, under each worksheet are a number of items that are ordered like flour, sugar and salt. Under each material ordered are details on the price, i.e. price purchased at vendor, price from vendor to warehouse, price from warehouse to us, and a total. Now, I need to analyze all this data in one worksheet using drop down lists. For example, I wanted to find out how much I've spent on flour at Location 1 last year, this ...