Search found 168 matches
- Wed Nov 15, 2017 9:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to filter on string value with stacked dimensions
- Replies: 2
- Views: 3916
Re: MDX to filter on string value with stacked dimensions
Hello You could look at the "Generate" syntax as you will need to evaluate the measure for each Index and each employee:- { Generate( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Employee] )}, 0)} , Filter( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Index] )}, 0)} , [EmployeeMeasures].( [Index].CurrentMembe...
- Thu Nov 09, 2017 8:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DimensionElementDelete deleting alternate elements
- Replies: 6
- Views: 4913
Re: DimensionElementDelete deleting alternate elements
Either that or only increment your loop index if you do not delete an element.
- Tue Oct 31, 2017 8:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8123
Re: Child Elements are not visible under consolidations
This MDX may return the elements you require:-
{
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 5 week]}, ALL, RECURSIVE )}
, {TM1DRILLDOWNMEMBER( {[YourDimName].[last 10 week]}, ALL, RECURSIVE )}
, {TM1DRILLDOWNMEMBER( {[YourDimName].[last 13 week]}, ALL, RECURSIVE )}
}
{
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 5 week]}, ALL, RECURSIVE )}
, {TM1DRILLDOWNMEMBER( {[YourDimName].[last 10 week]}, ALL, RECURSIVE )}
, {TM1DRILLDOWNMEMBER( {[YourDimName].[last 13 week]}, ALL, RECURSIVE )}
}
- Wed Oct 11, 2017 9:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: User does not have permission to browse the selected server
- Replies: 5
- Views: 4309
Re: User does not have permission to browse the selected server
Grasping at straws but do you have another TM1 service on this host with the same port number?
- Thu Sep 28, 2017 8:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: loading data using parameters
- Replies: 3
- Views: 2846
Re: loading data using parameters
OK
Create two parameters:-
CellPut?(YourDataValue, psService, psDepartment)
I Assume that you will read the data values from your CSV
Create two parameters:-
- psService
- psDepartment
CellPut?(YourDataValue, psService, psDepartment)
I Assume that you will read the data values from your CSV
- Thu Sep 28, 2017 7:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Old data pops up in a cube even after performing a deletion in a cubeview.
- Replies: 4
- Views: 3301
Re: Old data pops up in a cube even after performing a deletion in a cubeview.
Hello, First thoughts are that your ZeroOut view is missing the data that you want to clear or that there are rules applicable to the cells that you are attempting to clear. Not sure why you would see no data values when you inspect after the ZeroOut though. Not sure if you know or if this is applic...
- Thu Sep 28, 2017 7:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: loading data using parameters
- Replies: 3
- Views: 2846
Re: loading data using parameters
Hello, If I understand your post correctly, you want to load data from a CSV file with two columns which are "Service" & "Department". To do this you need to set the CSV file as your data source, then look at the variables tab to configure your CSV columns not paramaters. In ...
- Mon Sep 25, 2017 12:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Message on TM1 Web
- Replies: 6
- Views: 5036
Re: Message on TM1 Web
Glad you got it working
- Mon Sep 25, 2017 11:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Message on TM1 Web
- Replies: 6
- Views: 5036
Re: Message on TM1 Web
If you make a TI that returns an error when it finds that the active user does not have access, then you can set you message in the error section of the button. Assuming they do have access, then the TI will not error and they continue as befoe to the form.
Hope that makes sense.
Hope that makes sense.
- Tue Sep 19, 2017 8:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteCommand on SFTP file transfer
- Replies: 5
- Views: 4514
Re: ExecuteCommand on SFTP file transfer
Does the account that the TM1 service is running as have all necessary permissions?
Yo could test this by right-click and run-as on your BAT file using the TM1 service account credentials.
Yo could test this by right-click and run-as on your BAT file using the TM1 service account credentials.
- Tue Sep 12, 2017 7:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1RPTROW Repeat Problem
- Replies: 19
- Views: 13405
Re: TM1RPTROW Repeat Problem
So difficult to know what to suggest without seeing your system. I doubt this will help but you could try:- { HIERARCHIZE( {DRILLDOWNLEVEL( {[GRL.D.Contas_Contabeis].[TOTAL CONTAS ORÇAMENTÁRIAS]})} ) } If you replace the MDX with {[GRL.D.Contas_Contabeis].[41006 PLR]} what happens when you expand th...
- Mon Sep 11, 2017 2:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use Active Form but found duplicate Hierachy
- Replies: 9
- Views: 8818
Re: Use Active Form but found duplicate Hierachy
I have seen this happen quite a few times and it is almost alway cured by deleting all of the workbook rows below the TM1Report row. Can you rebuild your report from scratch to see if the problem happens in a second attempt. I do wonder sometimes if some corruption gets included into the Excel file ...
- Mon Sep 11, 2017 7:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Workspace - Selector Widget Slider Timing
- Replies: 3
- Views: 3696
Re: Workspace - Selector Widget Slider Timing
Hello,
Assuming you are working with VBA in Excel, could you use the Application.Wait method in a loop to set the widget value with a start stop button to control the loop.
Assuming you are working with VBA in Excel, could you use the Application.Wait method in a loop to set the widget value with a start stop button to control the loop.
- Wed Sep 06, 2017 11:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 public subsets gets cleared
- Replies: 5
- Views: 3876
Re: Tm1 public subsets gets cleared
I would inestigate the previous sugestion as there are risks with deleting and re-inserting elements. However you could perhaps make your subsets dynamic with MDX instead of static members, or recreate the subsets when you rebuild the dimension in TI.
- Wed Jun 14, 2017 7:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Scan Function
- Replies: 10
- Views: 8018
Re: TM1 Scan Function
You haven't said where this string data comes from.
If it were to come as a text data source you might be able to set the delimiter to the pipe char which would split it automatically for you.
If it were to come as a text data source you might be able to set the delimiter to the pipe char which would split it automatically for you.
- Tue May 09, 2017 10:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process maximum column limit
- Replies: 2
- Views: 2720
Re: TI process maximum column limit
I don't think it is the number of columns as such is a problem but more the total number of characters per line. If I recall correctly the cut off is somewhere just above 4000 chars.
- Wed Apr 26, 2017 2:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Get the Admin Host of TM1 server
- Replies: 7
- Views: 6324
Re: Get the Admin Host of TM1 server
I find it quite useful to have start-up process/chore copy the contents of the config file into a simple cube. That way the values are available for use in websheets, rules, Ti's...
- Thu Apr 13, 2017 5:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advanced rules editor
- Replies: 8
- Views: 7362
Re: Advanced rules editor
Supported and available are two entirely different things. IBM has a history of stopping support for a feature, yet leaving it in the product for a while. Dropping support just means you shouldn't count on it being available in the future. Couldn't agree more, to put it politely I don't think the b...
- Thu Apr 13, 2017 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advanced rules editor
- Replies: 8
- Views: 7362
Advanced rules editor
I have seen docs suggesting that the advanced rules editor is no longer supported:- http://www-01.ibm.com/support/docview.wss?uid=swg21661245 However this would suggest that it is since the editor choice parameter is still listed:- https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm...
- Thu Mar 16, 2017 3:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2.2 FP6
- Replies: 57
- Views: 43833
Re: TM1 10.2.2 FP6
Was the function you are thinking of "DisableMTQViewConstruct"