TM1 Forum

I hit the same error!
After I deleted the KB960715 yesterday , It solved.
But I update KB973525 today , this error come again .And now i can't rollback to make the workflow work . Even if i uninstalled KB973525
Can anyone can help !

solved
just right click the proccess tick security access

I have a dimension level Security Cube }ElementSecurity_Customer I granted the corresponding right to the client Sales1 . So that Sales1 can view and edit the Cube. [Attached screen shot] I can manually update the cube with READ , WRITE ,ADMIN ,LOCK...etc However , if i create a proccess to cellPuts...

I am using version 9.4.
I can do it using TI .However It seem not yet fixed in VBA macro
Anyway ,Problem solved by using subset ..Thanks you !

Dimension : Customer have apply security issue .User can only see their own customer . But when i coding in VBA , the code below will return a full set of customer (including those with no permission) is there any function to check the element security to filter those customer with no permission? cu...

As i tested , the cube and element security setting are base on the user group .
Anyone can tell me can tm1 sercutity base on the client or not ?
let's say , i have two user in the same group < --their role is sales
but the Security setting are different . They can only see their customer .

It's a great idea! Thank !
For curious . It that a way to do that kind of action?

How can i call the TI proccess while closing excel?
can i do it at marco?

Thanks!

The get function can work now .Thanks !
The next step for me is to set the data back
is there any function can set the data back to the cube?

When i run the follow code >Public Sub Test() > >MsgBox Application.Run("DBR", "ExchangeRate", "2008", "June", "HKD", "rate") > >End Sub > it return *KEY_ERROR May be i messed up something . TM1CubeCellValueGet is just my frist step. More d...

Thanks ! because i need to do some calculation on the value manually. i found that function TM1CubeCellValueGet is useful . However when i call TM1CubeCellValueGet ,it return a error code ! (code refer to http://forums.olapforums.com/viewtopic.php?f=3&t=1068 ) Can i have some example of TM1CubeC...

I want to grab data from my cube .But when i use function TM1CubeCellValueGet , it return a error code . What's wrong with my code? Cube: Exchange Rate Dimension : Year Dimension : Month Dimension : Currency Dimension : Rate_m Private Sub Form_Load() Dim sServerName As String Dim sUsername As String...

I have a template It have several month data. Instead of use relative proportional spread manually for each month. Can i add a button to my template to make it more automate? After press the button , it call the relative proportional spread function automatically to get the data from perviod verson ...

How about slice ?Can it work to place two cube data horizontally?
If not ? Is there any method to place two cube data into a template horizontally as follow?

I am trying to format the active form based on the level of consolidation element. (i.e. a color for each level ) ( e.g. level 0 :red, level 2 green & level 3 blue) I found that TM1RptElLev function could be helpful , but it's lack of example in the developer guide. Is there any example for refe...

Thanks you brother !
That exactly what i'm trying to do .

"Every element in a TM1 dimension must have a unique name" . is that the attribute also have to be unique ?

MY hierarchy like

A -B - B
| -C - D
(see attached)

When building the dimension using TI ,a circlar refernece expection occur .
what can i do if i need to create that kind of hierarchy ?