TM1 Forum

Posted: **Thu Jul 23, 2009 2:59 pm**

Hi all,

bit of an odd one. I was trying to retrieve a user group in excel using the DBRW function.

I am 99.9% certain i had this working but typically excel crashed lost my work and now when i try and type in the same command i get a key error. Im simply baffled.

Code: Select all

=DBRW("[TM1 SERVER]:{ClientGroups",[USER],[GROUP])

Anyone successfully intergogated the ClientGroups cube via DBRW?

cheers

Posted: **Thu Jul 23, 2009 4:55 pm**

For me, this works as one would expect:

Code: Select all

=DBRW("bv:}ClientGroups";"wim";"admin")

(Separator for arguments in the formula is ; in Dutch)

Note that your { is turned to the wrong side.

I am logged in with a client that has admin rights.

Excel 2003, TM1 9.4 MR1.

Wim

Posted: **Thu Jul 23, 2009 5:03 pm**

oh my goodness!! i think that well may be it!! can't believe I've made such a simple mistake

ill test it when back at work but thank you, thank you, thank you! now excuse me while i go kick myself

Posted: **Fri Jul 24, 2009 6:48 am**

just to confirm it was simply data-blindness on my part- i had the bracket round the wrong way and for some reason simply couldn't see it

cheers!

Posted: **Fri Jul 24, 2009 8:47 am**

No problem, once and again that happens to all of us I think

TM1 Forum

DBRW ClientGroups

DBRW ClientGroups

Re: DBRW ClientGroups

Re: DBRW ClientGroups

Re: DBRW ClientGroups

Re: DBRW ClientGroups