TM1 Forum

I have a user who has permissions to processes Y, but not to a cube named X. to give permission to a group to access a process: Cellputs('READ','}processsecurity',[TIprocessname],[usergroup]); I have a user who has permissions to processes Y, but not to a cube named X. to avoid access to the cube x...

We are looking to automate the production of some excel reports. Here is our plan of attack (Well my plan really :mrgreen: ): 1) Add some VBA script to each report that will: automatically logon, refresh the data (easy I know), publish the file to pdf and finally close the file. Why don't you use OL...

Use Distinct to avoid duplicate tuples from a specified set.

Syntax:
Distinct(Set_Expression)

Oh I c

I don't remember the syntax ( just check the VBA help), but it can.
but the logic is
- as you know the cell address, so you can check the cell value using VBA
and if you find it is not correct, or error take the formula from the other correct cell

Regards
VRG

DBRW function in the worksheet will always be there ************** yes. Because DBRW is a TM1 worksheet function This function retrieves a value from a specified TM1 cube. When all element arguments (e1, e2, etc.) to the function are leaf elements, the DBRW function can also be used to write values ...

http://publib.boulder.ibm.com/infocenter/ctm1/v9r4m1/index.jsp?topic=/com.ibm.swg.im.cognos.tm1_ug.9.4.1.doc/tm1_ug_id5470UsingtheELCOMPFunction_N130AF9.html The ELCOMP function returns a child of a consolidated element. This function accepts three arguments: a dimension name, an element name, and a...

as I remember and understand TM1 API is not to create Turbo Integrater process, but to access TM1 through another system For example if you want to create system using C or VB to access TM1, you have to connect to TM1 using the API then from there you can access TM1 Cube, dimension etc http://publib...

I think what you need is to create new dimensions: 1. Account with elements: Manager A Manager B 2. Product with elements: Product A Product B 3. Category with elements: SKU 1 SKU 2 SKU 3 SKU 4 if you want Manager A can only see his products, you can set in Security login (??), as I remember TM1 has...