Threads Replies Last Post 3 Pages: 1  2  3   18 http://tjxzs.com.cn =?UTF-8?B?5aSp5rSl6Z+z5ZON?= =?UTF-8?B?5LiT5Y2WIDc2?= Ìì½òÖÇÄܼҾÓ,Ìì½òÖÇÄܼÒÍ¥¹ã²¥,Ìì½ò¼ÒÍ¥ÖÇÄܱ³¾°ÒôÀÖ,Ìì½ò¼ÒÍ¥±³¾°ÒôÀÖ,Ó°ÒôÆ÷²Ä,ͶӰÆ÷²Ä,Ìì½òÃÔÄãÒôÏì,Ìì½ò¸ßµµÒôÏì,Ìì½ò¸ßµµ¼ÒÍ¥Ó°Ôº,»ÝÍþ,»ÝÍþרҵÒôÏì,HIVI,HIVIרҵÒôÏìJVC,JBLרҵÒôÏì,Ìì½òÒôÏìרÂô.com , 86-022-81501975, Ìì½òÒôÏìÍø, 86-13802174064, Ìì½òöÎÖ®Éù, 86-022-26623951,tjxzs@hotmail.com, Ìì½òÊкӱ±ÇøÌì̩·Ð´ó±¾ÓªµçÆ÷³Ç218ºÅ, http://tjxzs.com.cn ,Ìì½òÒôÏì×Ü´úÀí, Ìì½òöÎÖ®ÉùµçÆ÷ÏúÊÛÖÐÐÄ, tjxzs.com... 1 12/30/2008 8:09:32 AM Analysis extensions Installation in AX2009SP1 Hi , When I tried to Install AX2009 SP1 Analysis extensions on Analysis service 2008 from AX2009 setup Wizard; it said “Analysis extension has Successfully Installed”. But when I checked Analysis service Database I found that no Database was created for AX2009 . I checked the installation Log file it gives following Information . === Starting e... 1 12/24/2008 9:10:00 AM Installing Analysis Extensions on a SSAS Cluster Has anybody managed to install AX2009 Analysis Extensions on a SSAS Cluster and how?... 1 12/22/2008 8:51:14 AM Ax 4.0 -> AX 2009 Upgradation - Collation issue Dear friends, You all must be knowing that there is a collation issue when you point out your existing Ax 4.0 DB while installing Ax 2009. It will throw us an error saying that incorrect collation( CI-AI -> CI-AS). Changing of collation in the MS SQL server is definitely tricky and straight forward methods like - using ALTER COLLATE command all fails as it shows lot of dependency... 2 12/17/2008 6:40:13 PM EP & Role Centers - Issue with KPI's not loading Hello All, I have setup my AX 2009 Enviroment with the EP, Reporting Services and Analysis services. I processed the cubes both individual and as a whole in the Analysis Services database. However, even though certain role centers work fine, others, such as the CEO Role Center has KPI modules which hang and keep saying "Loading information". No error is created that I am aware of but ... 3 12/15/2008 5:33:01 PM SSRS Report Deployment in AX 2009 When I run the Report Deployment utility everything seems to run for a while then I get a message that the job can't access the rsconfig.... file. Has anyone else seen this error. Sorry I am not in teh home office (at a client site) so I don't have the exact error message at my disposal. I was pointed in the direction of having problems if the Reporting Services and Sharepoint default pa... 5 12/15/2008 4:47:01 PM Copy of AX_Db I'm currently in the process of testing in our test environment, the process of automatically creating a planned transfer journal from a forecast. Because of the nature of this testing, I have the SQL Admininstrator copy the Production environment (AX_Prod) to the TEST environment (AX_Test) every morning. I need currect postings for my forecast. The issue I have is because I'm the Axap... 1 12/12/2008 4:13:24 PM AX 2009 Demo Data doesn't seem to be working? Hello All, I had installed the demo data for Ax 2009. When I tested the CEO Role Center the KPI's and graphs would display; however, the data was all zeroed as if there was no data. I am not sure if there is an issue with my setup or if there is a lack on the demo data's end for the CEO Role Center. Any information will be appreciated. Thank you... 4 12/11/2008 1:56:01 PM SQL Server Stored Prcedure to show AOS connections. This may be useful to you SQL DBAs (or aspiring ones) administering Dynamics AX databases. Enjoy. /* Vince Collogan vcollogan[ReplaceThisWithAnAtSign]tsys.com TSYS (Total System Services, Inc.) Original: May 2008 Modifications through Dec 2008 Query in this proc shows current connections from Dynamics AX AOS (Application Object Servers). Requires SQL Server 2005 (or above? - untes... 1 12/10/2008 9:25:12 PM QuickLaunch Hi, I have modified the menus for 3 levels of fly outs. The first level flout is displaying correctly, but the 3rd level is not inheriting the styles. I have tried modifying the ms-navsubmenu2 but with no luck in making any changes. Any help would be greatly appreciated. best! ... 1 12/9/2008 10:22:01 PM Report Deployment fails in AX 2009 When I try to deploy reports to SSRS it fails with the errormessage: Unable to connect to http://xxxx:yy/reportserver/ReportService2005.asmx as specified in the config file for the report server at c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config. If this url is not correct please update the config file, otherwise make sure the report ser... 1 12/9/2008 3:20:17 PM DB Log and Shared Tables Hi I am sharing some tables and want to also be able to audit any changes, but I cannot find these tables listed for selection in the database log. Do I need to do something different to set up the db log for shared tables, or are they called something different by the log. For example, I'm looking for LedgerJournalName, or LedgerPeriod Thanks... 2 12/8/2008 4:58:36 PM LIKE operator with pattern Hi, Is there any way to translate the following statement to X++ code? select distinct id from dataarea where id like '[0-9][0-9][0-9][0-9]' Thanks. ... 2 12/4/2008 10:45:01 PM find serial number in RMS database I have a problem and i want someone help me. A saler who use the POS operator create a new serial number (bad serial number which is not in the availabled serial number list) to sell a particular item. I look for a good table in the database to change the bad serial number with the good one. I thing find it in the table named serial. The surprise i have, the view of the product inventory... 1 12/3/2008 3:43:02 PM How to find from the AX user to the database session? We use: AX4.0, SP2 Oracle 10g I have frequently the problem that I find a SQL Statement in the Oracle Enterprise Manager which I would like to optimize, but I cannot find from the Oracle Session to the AX user. In the Online User Form there is a column "SPIDs" which would make it easy, but it is not very frequently filled - for the oracle session I want to connect to the AX user I hav... 4 12/2/2008 4:25:00 PM AXADOMD Hi guys Please help I have been deploying Reports for AX 2009 and SQL Reporting Services , I encounter the following error can anyone help me figure out why "An attempt has been made to use a data extension 'AXADOMD' that is not registered for this report server" This error is for only few reports that use this connection, rest of the reports get deployed succesfully PLease hel... 7 12/1/2008 9:46:10 AM Setting up AX 2009 components across multiple servers Hello All, I was wondering if anyone has experience in setting up AX 2009 components across multiple servers. For example, I want the AOS on one server, Reporting services and Analysis services on a seperate server, Sharepoint for the EP on another server as well. If so, are there any extra pitfalls and setup procedures that I need to be aware of? Please let me know. Thank you in adv... 4 11/24/2008 6:46:05 AM Ax Installation Error when i try to install Ax 4.0, i faced some errors, especially when i install AOS server the below errors occurred. if any one familiar with this errors, pls send reply. **********************DynamicsSetupLog.Txt*********************************************** === Setting up Object server === Adding account OCIMUMBIO\OBS-DYNAMICS-AP$ as a login in SQL Server SQL Version: 9.00.1399.06 T... 2 11/21/2008 4:47:01 PM Delete actions Hi, I have the following scenario: 1) Table InventTable is having 2 fields salesresponsible & approved by (both of the fields shows the employees drop down) 2)I have set two relations in 'Relation' node on Table InventTable: a)InventTable.salesresonsible == EmplTable.emplid b)InventTable.approvedby == EmplTable.emplid 3)I have added delet... 4 11/20/2008 1:32:56 PM OLAP in 3 tier not working I have a question regarding the creation of cube instances. We have a setup as specified below: - MBS Axapta 3.0 SP3 - SQL Server 2005 - SQL Analysis Services 2000 SP4 When running a 2 tier client I have no problem defining cubes, creating instances and processing them. However when in 3 tier I get the following error when I try to create a cube instance: "Cannot connect to the An... 2 11/20/2008 11:25:34 AM How to import label files? I have a label file which is in say,Russian. How to import that into Ax 4.0? I am using Ax 4 service pack2. Can somebody give me a detailed procedure or a good link? Which file is to be imported? The .Ald files or .Aod files?... 6 11/19/2008 7:16:17 PM Blob / Docuhandling / Export to file Hi can anyone tell me an easy way how to export the docu-value (blob) from docufield back to a file.. best would be via (T)SQL THX Pirmin... 6 11/19/2008 2:54:01 PM Can SSRS and AS be shared amongst multiple AX 2009 instances? Hello, When dealing with multiple AOS's in AX 2009. I know that the same report server can be shared amongst multiple instances, simply because a folder holds the reports. However, is the same true for the cubes in Analysis services? To me, this does not seem so because one would need to link the datasource in AS to the MSSQL server for the AOS. What is the best way to go about this p... 3 11/19/2008 8:45:00 AM Master Planning Report I am trying to do a Master Planning report and want to show the reqpo line to reqtrans. I am not able to find a join that would show the relationship between the Planned Orders and Derived Requirements. Thanks in Advance Jim ... 1 11/11/2008 12:10:09 AM [Microsoft][ODBC SQL Server Driver]Invalid cursor position Hi, We're experiencing the error [Microsoft][ODBC SQL Server Driver]Invalid cursor position when running (certain?) batchprograms. Has anybody experienced this error? Our main problem is that we don't known what SQL-statement(s) trigger the error - and we can only reproduce the error in our production environment. AX3.0 SP3 with MS-SQL Server 2000. TIA. Kind regards, Morten ... 8 11/5/2008 11:19:02 AM 3 Pages: 1  2  3