DBRW ClientGroups

[dubs]

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

[Wim Gielis]

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

[dubs]

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

[dubs]

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!

[Wim Gielis]

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