Recent content by ejsmith

My apologies - I have access to several servers and I just checked the version... the one I was trying to run this on is still on 2000. Thanks anyway!

All of the documentation on Common Table Expressions specifically mentions that you can create and reference a CTE within a CREATE VIEW statment. Trouble is that I can't find an example of this and I've run out of things to try. Has anyone used a CTE in a view? Any suggestions on the correct...

I have a virtual cube that I would like to save as a local cube for portability reasons(my end users cannot have access to the analysis server). Can this be done? If not, can anyone think of a work-around? I can't think of a way to get what I want without using a virtual cube... Thanks in advance!

Flybridge & johnherman, yes - so the denominator changes depending upon what the dimension is. I think I've solved it - I'm using the ValidMeasure() function on the calculated field - and so far it seems to be working great. Now all I have to do is figure out a way to turn virtual cube into a...

I am trying to use a calculated measure which has a different formula depending upon whether or not certain dimensions have been used to limit the results. I am trying to get a Per Member Per Month (PMPM) figure in a healthcare environment... normally not the hardest thing to do - except in our...

Thanks PHV - that was what I needed. I knew there had to be a better way and scripting did the trick. I'm not the best programmer - but here is what I did and it seems to work Thanks again for your help! ---------------------------------------------------- Function...

Benaround -I'm sure no expert in this area -but are you using ADO to connect to the databases? I assume they are Sql Server databases - if so can you use connection pooling and just open one connection to the server? I don't really do ADO (I use DAO) - but from what I've read connection pooling...

I have a situation where I am recieving very large data files in csv or text format which (due to our less than good network) I have to break into smaller files in order to load them into SQL Server. I need files of no more than 500,000 records - so it needs to be split by record count as...

Thanks busche! My area doesn't have the best relations with our networking people - so they will tell me 'it can't be done' no matter what I ask them. So I need to understand things before I even approach them. Your answer will help me to get a handle on things. I'm going to look into the...

Forgive me if this isn't the appropriate forum for this question. I know very little about networking - I was hoping to get this groups opinion on something I'd like to do. I am new to a company which is currently using a 10 mbps network. We have somewhere between 30-40 servers. Several hundred...

Thanks guys! I also found ActiveCell.PivotTable.Name which throws an error if you aren't in a pivot and returns the name if you are! Thanks for your help!

I'm trying to determine the name of the pivot table where the activecell is located - or if the active cell is not loacated in/on a pivot table. The reason being that I have certain code that alters pivot tables and I'd like the code to work only on the active pivot table (we usually have...

Thanks Rob!

Well, what I'm writing may be distributed to many people - I want to be able to just email them the code without having to deal with getting them the forms too... I thought the only way I could do that would be to crete the form and comboboxes dynamically.

I am trying to create a form which contains several listboxes in excel using VBA. I want the form and listboxes created via code so that the code can be transfered easily to many users. I know how to create a form and I know how to create a listbox - problem is I don't know how to create a...