Search found 168 matches

by AmbPin
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: 3685

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...
by AmbPin
Thu Nov 09, 2017 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionElementDelete deleting alternate elements
Replies: 6
Views: 4733

Re: DimensionElementDelete deleting alternate elements

Either that or only increment your loop index if you do not delete an element.
by AmbPin
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: 8053

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 )}
}
by AmbPin
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: 4224

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?
by AmbPin
Thu Sep 28, 2017 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading data using parameters
Replies: 3
Views: 2827

Re: loading data using parameters

OK
Create two parameters:-
  • psService
  • psDepartment
Then in your code
CellPut?(YourDataValue, psService, psDepartment)

I Assume that you will read the data values from your CSV
by AmbPin
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: 3232

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...
by AmbPin
Thu Sep 28, 2017 7:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading data using parameters
Replies: 3
Views: 2827

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 ...
by AmbPin
Mon Sep 25, 2017 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Message on TM1 Web
Replies: 6
Views: 4968

Re: Message on TM1 Web

Glad you got it working
by AmbPin
Mon Sep 25, 2017 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Message on TM1 Web
Replies: 6
Views: 4968

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.
by AmbPin
Tue Sep 19, 2017 8:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteCommand on SFTP file transfer
Replies: 5
Views: 4383

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.
by AmbPin
Tue Sep 12, 2017 7:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTROW Repeat Problem
Replies: 19
Views: 12873

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...
by AmbPin
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: 8381

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 ...
by AmbPin
Mon Sep 11, 2017 7:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workspace - Selector Widget Slider Timing
Replies: 3
Views: 3590

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.
by AmbPin
Wed Sep 06, 2017 11:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 public subsets gets cleared
Replies: 5
Views: 3763

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.
by AmbPin
Wed Jun 14, 2017 7:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Scan Function
Replies: 10
Views: 7963

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.
by AmbPin
Tue May 09, 2017 10:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process maximum column limit
Replies: 2
Views: 2700

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.
by AmbPin
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: 6053

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...
by AmbPin
Thu Apr 13, 2017 5:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced rules editor
Replies: 8
Views: 7323

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...
by AmbPin
Thu Apr 13, 2017 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced rules editor
Replies: 8
Views: 7323

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...
by AmbPin
Thu Mar 16, 2017 3:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 43420

Re: TM1 10.2.2 FP6

Was the function you are thinking of "DisableMTQViewConstruct"