Search found 126 matches
- Wed Apr 01, 2020 6:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1py not connecting
- Replies: 4
- Views: 4130
Re: tm1py not connecting
Hi, I cannot connect to TM1 with tm1py either. When executing check.py in PowerShell there is no prompt for login and no error message. tm1py is installed successfully, REST API enabled --> https://localhost:8881/api/v1/$metadata gives back data. OS is Windows 10, TM1 version is 10.2.2 FP7, HTTPPort...
- Wed Feb 25, 2015 5:41 pm
- Forum: MS Analysis Services
- Topic: Data Mining Cubes?
- Replies: 4
- Views: 87944
Re: Data Mining Cubes?
In this example they are using the decision tree method which can be done with "flat" data records in tables or files. The classic market basket example uses flat tables as well. You don't need a cube here since you don't want to aggregate data or create multidimensional views. Since almos...
- Wed Feb 25, 2015 2:21 pm
- Forum: MS Analysis Services
- Topic: Data Mining Cubes?
- Replies: 4
- Views: 87944
Re: Data Mining Cubes?
Hello, data mining is a wide field and not limited to OLAP cubes. They are probably using views on relational tables in a DWH or mining even directly in operational raw data. Difficult to say without knowing the tutorials. There are many approaches to data analysis depending on the requirement and a...
- Tue Feb 03, 2015 2:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2 URL API websheet title elements
- Replies: 4
- Views: 5401
Re: TM1 10.2 URL API websheet title elements
Thank you all for your advice. We were finally waiting for 10.2.2. An example for the above mentioned syntax on the planning sample model would be: http://<your server>/tm1web/UrlApi.jsp#Action=Open&Type=Websheet&Workbook=Anwendungen/Planning%20Sample/Administrator/Planning%20Sample%20MDX.xl...
- Sat Dec 13, 2014 2:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: [TM1 10.2.2] Consolidate with MAX criteria w/ RULE [SOLVED]
- Replies: 5
- Views: 5450
Re: [TM1 10.2.2] Consolidate with MAX criteria using RULE
Leonardo, you only specified two dimensions in the rule but your cube contains at least six. You have to specify all of them in the rigth order.
- Thu Dec 11, 2014 10:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Reporting TM1 data from SAP BO
- Replies: 12
- Views: 14093
Re: Reporting TM1 data from SAP BO
For getting TM1 data into Excel you may also use the approach from J. Wakefield http://www.bihints.com/tm1_sdk . I find it very useful, especially for placing views from different TM1 instances (e.g. DEV/PROD) in the same worksheet.The MDX for queriying TM1 cubes is standard MDX. You just have to sp...
- Wed Oct 01, 2014 11:21 am
- Forum: MS Analysis Services
- Topic: Lists from dimensions where there is no logical count
- Replies: 1
- Views: 48217
Re: Lists from dimensions where there is no logical count
Hi Steven, I have no direct trick and I've seen your post a bit late but I suppose you might be better off querying the datasource with SQL directly. If you are using Report Builder you can connect to the relational source as well and present the report to the users. You don't need to query this mas...
- Sun Aug 24, 2014 8:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transposing an ASCIIOutput within TI
- Replies: 10
- Views: 8363
Re: Transposing an ASCIIOutput within TI
You could use the parent of your 12 month elements in your source view. Then don't skip calcs. Then in your data tab write 12 CellGetN statements for your months on the same slice as the year value. Thus you're "generating" 12 values out of one source value. Below put your ASCIIOUTPUT stat...
- Fri Aug 22, 2014 8:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2 URL API websheet title elements
- Replies: 4
- Views: 5401
TM1 10.2 URL API websheet title elements
Hello all, with version 10.2 did somenone succed in passing an element to a SUBNM cell in a websheet using the title_S#-R#-C#=element approach from the 10.1 documentation? Are there other possibilities? Would it be reliable to combine a 10.2.2 TM1Web with 10.2 Server for a transition period to make ...
- Wed May 21, 2014 3:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Regarding Cube Properties
- Replies: 3
- Views: 4364
Re: Regarding Cube Properties
I don't know and can't imagine a parameter for this. Just plug in your values in the System cube directly. You wouldn't change your selections often anyway during a cube's lifetime, would you?
- Wed May 21, 2014 7:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Consolidation value to be overwritten
- Replies: 8
- Views: 8255
Re: Consolidation value to be overwritten
You would probably change the type of your 'member ID' element into String and adjust your process accordingly. There would be no summation then.
- Fri May 16, 2014 6:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Regarding Cube Properties
- Replies: 3
- Views: 4364
Re: Regarding Cube Properties
It seems to be a bug. But your selection is available in the cube which is called }CubeProperties.
- Tue Nov 27, 2012 6:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 object dependency checker - VB help needed
- Replies: 5
- Views: 6313
Re: TM1 object dependency checker - VB help needed
Hi Gareth, I apologize, the order is right, I probably didn't delete the result set before executing the code a second time. But in fact the result set is different when executing it several times (see example in attachment with two consecutive runs, server not running). For the purpose you mentione...
- Fri Nov 23, 2012 9:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 object dependency checker - VB help needed
- Replies: 5
- Views: 6313
Re: TM1 object dependency checker - VB help needed
Welcome Gareth, I can't answer your question, but can give you some feedback. The Sub Dim_to_Cube () works very reliable as long as the search in *.pro and *.rux files is commented out. I suppose your problem is the *.pro an *.rux part and filling of the array and overriding existing content. With t...
- Thu Nov 01, 2012 3:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Search Function for VUE Files
- Replies: 10
- Views: 10071
Re: Search Function for VUE Files
Yes, Steve pointed to a good direction. Using hard-coded view and subset names instead of variable ones is more stable in this case. If this is not the case, you can read out subset names from the *.vue file. The rows with subset names start always with a 6, (e.g. 6, Default). I wrote a process that...
- Tue Sep 25, 2012 8:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel file in Applications folder
- Replies: 9
- Views: 6894
Re: Excel file in Applications folder
an approach through the backdoor would be the following: you already determined/created - the xls file in }Externals folder - the blob with parameter entry ENTRYNAME/ENTRYTYPE/ENTRYREFERENCE - the path to it in the }Applications folder you could insert a new element (folder\blob name) in the }Applic...
- Tue Sep 11, 2012 12:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CubeAction=1511
- Replies: 2
- Views: 2823
Re: CubeAction=1511
CubeAction=1511 means "No Action", DataAction 1503 means "Store Values", Enable cube logging turned off. The values correspond to settings in the "Cube" tab of the TI wizard, in this case it is the default setting. Since you didn't specify a cube there you can ignore it...
- Sat Sep 01, 2012 1:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Process not running in VB
- Replies: 1
- Views: 2135
Re: Process not running in VB
Hi, your code is working for me. I didn't test with Integrated login but I need to assume that the hServer handle which is passed from a different routine already did the connect. You should check your hProcess handle against TM1ValTypeError() (see example). Thus you check hServer indirectly. Hope t...
- Fri Aug 31, 2012 5:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA in excel not rebuilding
- Replies: 2
- Views: 3058
Re: VBA in excel not rebuilding
your code works fine for me in Excel 2007 with automatic calculation turned on, e.g. for retrieving values from another workbook on opening.
- Sat Mar 31, 2012 10:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Show Cube in Excel interface
- Replies: 2
- Views: 2641
Re: Show Cube in Excel interface
Well, Excel looks like Excel.
Did you try In Spreadsheet Browser as an Alternative?
Did you try In Spreadsheet Browser as an Alternative?