Search found 126 matches

by Marcus Scherer
Wed Apr 01, 2020 6:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1py not connecting
Replies: 4
Views: 4028

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...
by Marcus Scherer
Wed Feb 25, 2015 5:41 pm
Forum: MS Analysis Services
Topic: Data Mining Cubes?
Replies: 4
Views: 84024

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...
by Marcus Scherer
Wed Feb 25, 2015 2:21 pm
Forum: MS Analysis Services
Topic: Data Mining Cubes?
Replies: 4
Views: 84024

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...
by Marcus Scherer
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: 5345

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...
by Marcus Scherer
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: 5385

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.
by Marcus Scherer
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: 13963

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...
by Marcus Scherer
Wed Oct 01, 2014 11:21 am
Forum: MS Analysis Services
Topic: Lists from dimensions where there is no logical count
Replies: 1
Views: 46112

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...
by Marcus Scherer
Sun Aug 24, 2014 8:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transposing an ASCIIOutput within TI
Replies: 10
Views: 8263

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...
by Marcus Scherer
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: 5345

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 ...
by Marcus Scherer
Wed May 21, 2014 3:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Regarding Cube Properties
Replies: 3
Views: 4328

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?
by Marcus Scherer
Wed May 21, 2014 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation value to be overwritten
Replies: 8
Views: 8124

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.
by Marcus Scherer
Fri May 16, 2014 6:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Regarding Cube Properties
Replies: 3
Views: 4328

Re: Regarding Cube Properties

It seems to be a bug. But your selection is available in the cube which is called }CubeProperties.
by Marcus Scherer
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: 6253

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...
by Marcus Scherer
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: 6253

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...
by Marcus Scherer
Thu Nov 01, 2012 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Search Function for VUE Files
Replies: 10
Views: 9962

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...
by Marcus Scherer
Tue Sep 25, 2012 8:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel file in Applications folder
Replies: 9
Views: 6828

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...
by Marcus Scherer
Tue Sep 11, 2012 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CubeAction=1511
Replies: 2
Views: 2785

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...
by Marcus Scherer
Sat Sep 01, 2012 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process not running in VB
Replies: 1
Views: 2100

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...
by Marcus Scherer
Fri Aug 31, 2012 5:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA in excel not rebuilding
Replies: 2
Views: 3023

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.
by Marcus Scherer
Sat Mar 31, 2012 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Show Cube in Excel interface
Replies: 2
Views: 2598

Re: Show Cube in Excel interface

Well, Excel looks like Excel.
Did you try In Spreadsheet Browser as an Alternative?