You would think this is simple but I'm trying to write (thru Excel) a string value to to the }ClientGroups control cube with no success (keep getting *KEY_ERR). I have checked the syntax, spelling, etc. a hundred times. What obvious thing am I missing?? Is there a prohibition on writing directly to control cubes perhaps?
=DBSS("ValidGroupName", "}ClientGroups", "ValidClientName", "ValidGroupName")
Write to security cube with DBSS?
-
Alan Kirk
- Site Admin
- Posts: 6664
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Write to security cube with DBSS?
Where's the ValidServerName: in front of the cube name?mitch23 wrote:You would think this is simple but I'm trying to write (thru Excel) a string value to to the }ClientGroups control cube with no success (keep getting *KEY_ERR). I have checked the syntax, spelling, etc. a hundred times. What obvious thing am I missing?? Is there a prohibition on writing directly to control cubes perhaps?
=DBSS("ValidGroupName", "}ClientGroups", "ValidClientName", "ValidGroupName")
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
mitch23
- Posts: 21
- Joined: Thu Jan 29, 2009 11:32 am
- OLAP Product: Planning Analytics
- Version: 10.1
- Excel Version: Office 365
Re: Write to security cube with DBSS?
Doh! Boy do I feel stoopid. Thanks!Alan Kirk wrote:Where's the ValidServerName: in front of the cube name?mitch23 wrote:You would think this is simple but I'm trying to write (thru Excel) a string value to to the }ClientGroups control cube with no success (keep getting *KEY_ERR). I have checked the syntax, spelling, etc. a hundred times. What obvious thing am I missing?? Is there a prohibition on writing directly to control cubes perhaps?
=DBSS("ValidGroupName", "}ClientGroups", "ValidClientName", "ValidGroupName")