Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 1,838 total)

  • RE: Unable to retrieve the list of columns

    Hi Ryan,

    When importing the spreadsheet, did you change the column names at all? If not, you could check for resrved words/characters in the col names. Also, saw something...

  • RE: Analysis Services - Service Process

    Hi Michael,

    yes, there is mem management happening is the background.

    Off the top of my head, I can't remember the setting that determines when the VLDM comes into play...

  • RE: Analysis Services - Service Process

    e... Halt, cease and desist.....

    The msmdsrv process is the Analysis Services Process, it is what is serving up the cibes. This isn't quite like Cognos, where the cube can...

  • RE: Dimension Design (Hiding Level / Apexing)

    Hi Jen,

    Doing well (Aus weather is kind, today is a balmy 30c/92f). Hope you're keeping well also.

    We do split the data by cubes, actually by catalog is more precise....

  • RE: We Studied, We Passed, Was It Worth It?

    Just my opinion, but we moved to .Net for our product development around 10 months ago, and I think that it has resulted only in good things, well nearly only...

  • RE: Run-time error 75

    Yeah, and they're all based on your machine locale settings ..... 🙁

    Steve.

  • RE: Run-time error 75

    Apologies Gary,

    The error lies in the renaming line.

    I tested this prior to adding the path and name string variable, it basically doesn't like the path in there as well when...

  • RE: Run-time error 75

    Phil, I like the concat of the double zero, cool. Would get around the crappy VBscript non-typing that loves to switch vars to/from ints and strings 🙂 .

    I...

  • RE: Run-time error 75

    Argghhh, all my work doing tabs, and they got blatted when posting!?!?!

    Steve.

  • RE: Run-time error 75

    OK, its a lot longer, and has no error handling, but should do the trick til you get some more time on VBSCript.

    I would have liked to have used the...

  • RE: Run-time error 75

    You'll find that VBScript is very similar to VB6 , but without the strong data typing.

    If you send thru your code, I can help modify it if you like and...

  • RE: Run-time error 75

    Possibly security/permissions? Keep in mind that when you run things from within DTS, they will pick up the user context of the account that DTS is set to run...

  • RE: Sum & Count Functions for Measures in Cubes

    Hi Jennifer,

    Is it *really* a business requirement to have all 500 measures in the one cube? If you can, I would try to make individual cubes, with logical groupings...

  • RE: Sum & Count Functions for Measures in Cubes

    :-S

    Not sure I'm following the theory here, do you have one, or many, sum measures? But you are aiming to have only 1 sum member? Or you have...

  • RE: DTS - How to check in destination table & filter

    Hi Kodali,

    Yet another approach for you. You could make your access DB a linked server (look under security folder in your Ent Mgr), and then you can write your...

Viewing 15 posts - 1,816 through 1,830 (of 1,838 total)