Search results for query: *

Hi Everyone. I need to add a calculated measure to my cube file for the number of occurrences of a transaction type based on a key field. If the transaction occurred, there will be a 4 to 5 digit ID, else a 0. The problem is when I do a Distinct Count by adding a new measure, I can't put a...

Hi everyone. I've looked around and haven't seen this, so here goes. I'm creating a Fact table of customer transactions where approximately 5 - 10% of the transactions belong to a "promotion" - type event, and get an alphanumeric Promotion Code for the transaction. I update all the other...

Hello everyone. I believe I'm the dbo on my database that I created under my windows login, which resides on a network server. Under this db, dbo is shown as the only user and I'm using Windows authentication. I've created a number of tables, both via query and DTS import. The last two...

Hi everyone. I'm looking at beginning a DW project for CRM puposes primarily and wonder what those who've gone through the process think about some of the major vendors. I've used MS SQL Server 2000 to good effect, but my new company doesn't want to go that route. I'm in the Casino business...

Hi everyone. I'm using the M$ Office Web Component Pivot Table in an application and I'd really like to have a Custom right click popup menu. I can do this - but the default popup menu ALWAYS shows up as well. There is no Cancel parameter on mouse down,, the Click event arrives too late, and...

Hi everyone. Does anyone know of any good links or books that show how to manipulate the OWC Pivot Table component? I can easily set it up, but I want to know how to access the value of the cell the user clicked, and all the values of the cells selected below if the user picked a field title...

Hi everyone. I got my new computer at home (with Windows XP Home Edition) and have installed SQL Server 2000 Enterprise Edition, and Analysis Servics. It's been a couple years since I had to do this and now I'm having a problem. When I open up Analysis Services I can see the name of my...

Hi everyone. I did a search on "+Excel +Security" and came up empty, so here goes. I have an Excel 2002 front end for a SQL Server 2000 database. I have a lot of code that I don't want anyone to be able to modify or view. I know "password breakers" still worked easily as...

Hi everyone. I've looked around and haven't seen this question, so here goes. I have a small app where I'm collecting an Account Number on a VB form as input by the user. For several reasons, I'd like to pass the result of proccing the account number - 1 page only - as an ASP page in the...

Hi everyone. I have a data warehouse that I've been using for about 6 months, and I update it weekly. It has about 30 tables, including a data staging area, 2 fact tables, numerous dimension tables and some processing tables. It's been working great, and I've been making small incremental...

Hello everyone. I have an Excel based user interface that allows the user to open up a Map with Mappoint 2002 and view the locations of customers that they selected based on account numbers. One of the features of Mappoint is that you can select a group of customers and using the menu...

Hi everyone. I'm having problems updating my cubes automatically, as it seems I must both 'Full Process' (I've chosen this above others for a reason I won't go into here) AND 'Incrementally Update Dimensions' to get the cube to process, both in Analysis Manager via a Right Click and in VB code...

Hello everyone! I have about 15 OLAP cubes on one server and we now have a new server. I'm able to transfer my DTS packages to the new server by doing a File>SaveAs inside the edit window, but the OLAP cubes do not appear to have that option. Is there a way to copy/transfer/saveAs, etc. Cube...

Hello all. I've put the contents of my help files into a rich text field and would like to allow my Excel 2002 users to be able to print the topic, or a selected section of the topic, from the field which is embedded on a form. I've looked, and I can't find a way to do that. Any ideas on how...

Hi everyone. I've done this before with a Cursor, but wonder if there is a straightforward way to do it using SQL set operations (no cursor). I have the following 3 fields withing the same table: ACCT ARRIVE DEPART Account is numeric, arrive and depart are dates. I'd like to create a...

Hello everyone. I'm printing a report with the docmd.OpenReport method for preview mode, but the report is always showing up in 'Portrait', despite the fact that I save the report AFTER having set the PageSetup/Orientation property to 'Landscape'. I found out how to do this a couple of years...

Using Access 2000, I'm having a real problem passing as a criteria condition the selections from a Multiselect List box on an open form. The list box is distinctly named and is on a Tabbed form, but it works when I select ONLY 1 item - just not any more than 1. I've tried selecting directly...

Hi everyone. I'd like to know if there's an EZ way to use a global variable from a Dynamic Properties task to limit the number of records imported from a table by Date. I've used dynamic properties before with tasks, but I don't know how to use a 'gvDate' in the required SQL string from the...

Hi everyone. I'm about to help a friend out with an Access database (not my primary expertise - especially on distributed apps) that will be used to allow about 25 users to login on form #1 and then input their hours, project type, location and a few other pieces of information into form #2 and...

Hi everyone! I'm blaming this problem on Monday fog, but I can't seem to return the record that has a max value in it. It's easy to return: SELECT Account, Max(Points) FROM Table GROUP BY Account but when I want to include other fields from that particular record with the...