Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PerlIsGood
  • Content: Threads
  • Order by date
  1. PerlIsGood

    MDX Dynamic Set not showing up in cube

    I'm drawing a blank here. The cube processes w/o error and I have several other dynamic sets in the cube, but this one set won't show up and I can't figure out why. I confirmed the MDX does return a set in SSMS.... Any ideas? CREATE DYNAMIC SET CURRENTCUBE.[Last 7 Days] AS...
  2. PerlIsGood

    MDX ParallelPeriod issue (SSAS Cube)

    The ParellelPeriod code below has worked in other queries, but plugging it into this one is not giving expected results and I can't figure out why. I've also included a simplified view of the output. Simply put I just want the rate increase/decrease between 2/2009 and 2/2010... Any help would...
  3. PerlIsGood

    PeriodsToDate help

    I have a query that works when I feed it a specific date, but can't seem to get it to work using variable select (LastChild, etc). Trying to create two subsets one for Current YTD and one for Last YTD (ie 1-2008 to 8-2008, and 1-2007 to 8-2007, based on the last date currently in dataset) Any...
  4. PerlIsGood

    RegEx help and file concatenate

    Been a while since I worked with Perl. Can someone help me out with this. I'm reading a directory of comma delimited files. I need to read in all files, add a few variables based on each file's name, and write out another file containing all files' info. Here's what I have so far, but can't...
  5. PerlIsGood

    SCAN + list of variables in a macro

    Having some problems building a macro using a list of variables that is later used in a scan loop. Here is the following bits of code: ---in macro shell %let globlistkeep= tot_bal1-tot_bal25 tot_credit1-tot_credit25; ---in separate included sas program in a data step %let f = 1; do...
  6. PerlIsGood

    Proc Tabulate problem

    I'm trying to summarize data that look like this: Example Data CLS PCT_LVL VARS1-VARSx 1 A x 1 B x 1 C x 2 A x 2 B x 3 C x I've been trying to summarize this data, summarizing all financial fields...
  7. PerlIsGood

    absolute div stacking problem

    I have a site with a couple stacking absolute divs. In FF it's working fine, but IE isn't liking it too much. You can view the example here: www.wgiunderground.com/_prelaunch/ and the css file www.wgiunderground.com/_prelaunch/main.css Any ideas why IE isn't displaying the divs? Main.css is...
  8. PerlIsGood

    DIV gap at top of page

    This is my first trip into "no-tables" design. I have a gap at the top of my page and I can't seem to get rid of it. I'm pretty sure the culprit is the relative-position menu bar I'm adding (div#menu). (example here). So what am I doing wrong? HTML: <!DOCTYPE html PUBLIC "-//W3C//DTD...
  9. PerlIsGood

    Pushing values into an Array

    Ok, I'm just starting to pick up SAS for my employer and I have my first project I'm trying to sort out. I'm pulling data from a database where the field is a 10-bit code (i.e., 0010000000). Each bit set stands for a different error code (i.e., previous example stands for a P1 error). Writing...
  10. PerlIsGood

    Access Query. Connection remaining open after macro exits...?

    I have a macro I'm working on in OfficeXP {in Word, querying Access database} and it has been working fine. But, on occasion, the database 'locks up' and the Word macro spits out an error: Could not use ''; file already in use. The database has multiple users accessing it at any given time and...
  11. PerlIsGood

    Visually identical strings not matching against 'ne' ...?

    Here's an excerpt of the script: use strict; use CGI; my $q = new CGI; my %query = $q->Vars(); my $userdir = &quot;./ns_forum/profiles&quot;; if ( -e &quot;$userdir/$query{'user'}.dat&quot; ) { open USR, &quot;$userdir/$query{'user'}.dat&quot; || &err_sub('Error', &quot;Failed to open...
  12. PerlIsGood

    References needed for Split

    Alright, I'm losing my friggin mind here. I've used Split in VBScript projects before with no problems, but in my VBA project with Word/Access I'm getting a 'Sub or Function not defined' error. I'm assuming I need to add a reference to the project, but I can't for the life of me figure out...
  13. PerlIsGood

    Word -&gt; Access SQL statement problems

    Can anyone point out the problem/error in the following SQL query? rst.Open _ &quot;SELECT * FROM tblClients WHERE [Billing Code] = &quot; & UCase(sClientCode), _ &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; & _ &quot;Data Source=&quot; & FileLoc & &quot;;&quot; For Each fld In...
  14. PerlIsGood

    Upload File to server creating 0-size file...

    I've read through and used most of the code from goBoating's faq219-406. I've also read through CGI.pm on file uploading - still can't get this bloody thing to work. It will create the file on the server, but with 0 size - seems to me read isn't doing what it's supposed to. Anyway, if anyone...
  15. PerlIsGood

    Better, more compact way to MAPI in Outlook...?

    So I went and figured out how to programatically navigate Outlook's folder listings last night. My only problem (or minor concern) is that the code I wrote seems overly complex. What I need to do is go from the {USER}'s mailbox, find the {RECRUITING} mailbox (a separate Exchange account which...
  16. PerlIsGood

    Getting a 'Type Mismatch' error...

    ..on this block of code: ElseIf Config(0) = &quot;Hotel&quot; Then For i = 1 To UBound(Config) Step 1 aryHotel(i-1) = Config(i) Next End If Perhaps I'm not allowed to evaluation an expression in the array index...? I don't know. The exact error is: &quot;Type...
  17. PerlIsGood

    M$ Photo Editor problems...

    I'm having a peculiar problem with this program: It's either in full 'maximized' state, or fully 'minimized'. If I try to 'restore down' to a windowed mode, it drops down into the task bar until I right click and select restore - and it then goes back to 'maximized'. I was going to...
  18. PerlIsGood

    Disabling &quot;File and Printer Sharing&quot;...

    So I'm running a solo win2k box (no network), and I decided to disable this function that is obviously not necessary. Sounds simple enough, but every time I reboot the bloody thing re-enables itself! Where do I look to destroy/modify the file that's causing this at startup...? Notorious P.I.G.
  19. PerlIsGood

    open GEN, $list question...

    using this code: $list = &quot;./blah.dat&quot;; open GEN, $list or die &quot;$!&quot;; Is it possible that this file would be overwritten? I know that the default (above) is to open 'for reading', but I've just had a file accessed from a script using the above syntax get wiped, as if I'd...
  20. PerlIsGood

    I broke it - Shutdown issues &lt;ACPI Disabled&gt;

    I was having excessive IRQ sharing issues, so I reconfigured my system and disabled ACPI and set it to Standard PC under Device Manager. Everything seemed just dandy as I reinstalled drivers and went through a couple of restarts, but now my system won't shut down. It will 'restart' just fine...

Part and Inventory Search

Back
Top