Search found 8 matches
- Thu Mar 21, 2024 2:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CubeSecurity and ProcessSecurity
- Replies: 4
- Views: 1957
Re: CubeSecurity and ProcessSecurity
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...
- Tue Jun 29, 2010 5:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Automation of Excel TM1 Based Reports
- Replies: 15
- Views: 11918
Re: Automation of Excel TM1 Based Reports
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...
- Sat Jun 26, 2010 4:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX query for topX customer per many products optimization
- Replies: 1
- Views: 1738
Re: MDX query for topX customer per many products optimizati
Use Distinct to avoid duplicate tuples from a specified set.
Syntax:
Distinct(Set_Expression)
Syntax:
Distinct(Set_Expression)
- Sat May 22, 2010 1:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Locking the DBRW in excel
- Replies: 8
- Views: 7426
Re: Locking the DBRW in excel
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
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
- Fri May 21, 2010 4:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Locking the DBRW in excel
- Replies: 8
- Views: 7426
Re: Locking the DBRW in excel
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 ...
- Fri May 21, 2010 2:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can't assign variable
- Replies: 2
- Views: 2365
Re: Can't assign variable
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...
- Fri May 07, 2010 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to create TI Process using TM1API?
- Replies: 12
- Views: 8415
Re: How to create TI Process using TM1API?
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...
- Tue Jan 12, 2010 4:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to design a model in TM1 9.5?
- Replies: 5
- Views: 4398
Re: How to design a model in TM1 9.5?
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...