Recent content by ganjass

Hi, SSAS 2005 I know that the Attribute relationship type (rigid, Flexible) is an important config setting for performance, with Rigid the preference, but a quick question to confirm something, I take it this is only a useful setting for Update processing, and not a full process?! Thanks

SSAS 2005 I've ran BIDS helper on the dsv of my cube, and have found a number of unused fields. Is there any performance gain in SSAS to be had by removing them? I've had a look on the web, but not found anything concrete either way. Any links to any white papers if poss would be much...

Hi All, SQL 2005 I've got 180 child packages that are all pretty much the same. I need an efficient way of firing these packages in a certain order (that could be changed) in parallel from a parent package. Can anyone suggest the most efficient \ simple way do this? Thanks

Hi All, SSIS \ SQL server 2005 I've been tasked with looking at a master control package that waits for a flag to start and then reads a workflow control table that contains a list of packages, the folder location and the groupID of the pacages, as they want certain packages to run in a loose...

SSAS 2005 Hi all, I'm having a can't see the wood for the trees momment, and was wondering if someone could shine a light.. I've got a fact table that contains Purchase orders of 3 different types that i have created 3 seperate flags for so that i can show a count of the Purchase order types...

CE10 Progress 9.1D Hi All, I'm scheduling a few reports through Enterprise and every now and again i get blank reports delivered. When i run the same reports off the same data source i get a data sets returned, any ideas? Thanks in advance

are they more stable? Or have betterfunctionlality?

CE 10 CR10 Progress 9.1D Hi all, I'm looking to create business views to allow less technical users to build reports. Are there any limitations \ bugs that i should now about before i create business views and the users start connecting a lot of reports to business views. Thanks in advance

CE10 Hi All, In CE if you have a formula, or object that say a hundred reports use, if you update the object in the repository, will it then cascade through all the reports that use the object and then schedule with this new chnage or do the schedules have to be re-done? Thanks in advance

Hi All, CE10 SQL server 2000 I have a number of scheduled reports that have to be switched to a new server during a migration. Can i change the reports to point to a new DSN using schedule manager, without having to reschedule the reports? Simple Q i know, but i haven't had a chance to test...

CR10 Progress 9.1D Hello All, I've got reports that report 12months back that have to report from the start of each month so that comparisons are constant i'm using the following to do this dateadd("yyyy",-1,(dateadd("m",+1,minimum(MonthToDate)))) But it is not pushed down as SQL which is...

CE10 SQL Server 2000 Win2003 Hi All, I'm trying to automate the FTP of reports to a FTP folder. I have the job servers services running under the same account that i have set up with permissions to the FTP folders i need. The issue is i keep getting : destination directory error...

CE10 SMTP_E_TCPSOCKET_OPEN(2) error again Hi All, I'm getting this error message sporadically with a number of reports being scheduled through job servers to SMTP. It's was not an issue for a while, but then it rears its ugly head. We use a netware server for the SMTP, and according to our...

Hi Bob, Yes i know that but how many distributed job servers can you have on other servers controlled by a central server? Cheers

CE10 Hi all, I've currently got a setup of 4 jobservers running on 2 dual processor servers with the main mass of services running on the main enterprise server. Is there a maximum number of job servers \ reports running at anyone time through enterprise. Thanks in advance