Search found 7 matches

by gmunoz
Tue Oct 08, 2024 11:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetMDXSet and SubsetCreatebyMDX error
Replies: 4
Views: 6687

Re: SubsetMDXSet and SubsetCreatebyMDX error

MarenC wrote: Tue Oct 08, 2024 10:38 am Hi,

try this:

Code: Select all

PayElementMDXQuery = '{[Int_Pay_Element].[Int_Pay_Element].[900]}';
Maren
It works!!! Thank you very much.
by gmunoz
Tue Oct 08, 2024 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetMDXSet and SubsetCreatebyMDX error
Replies: 4
Views: 6687

SubsetMDXSet and SubsetCreatebyMDX error

Hi Everyone. I am modifying an already created an functioning process that modify subsets of 3 dimensions with inputs from the user and with that 3 subsets generates a MDX view that is used in the said process as a datasource. This is all made in prologue. Yesterday i added a new dimension using the...
by gmunoz
Mon Jul 29, 2024 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not open location in the cloud environment as a datasource.
Replies: 12
Views: 7315

Re: Can not open location in the cloud environment as a datasource.

What may be happening here base on what you are trying to do and the last log is that in Epilog, the error log is still open/in use and is named something like TM1ProcessError....log$ In some of my processes where I need to email this to someone, the first part of my powershell script waits 3 secon...
by gmunoz
Mon Jul 29, 2024 11:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not open location in the cloud environment as a datasource.
Replies: 12
Views: 7315

Re: Can not open location in the cloud environment as a datasource.

Hi, So for the example on my post i should write as a location "..\Logs\tm1server" ? Well obviously not as what is tm1server supposed to mean? You need to specify a specifc file I assume? Something like ..\Logs\tm1server.log or as George advises, but with .log included. Maren Yes, I have ...
by gmunoz
Mon Jul 29, 2024 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not open location in the cloud environment as a datasource.
Replies: 12
Views: 7315

Re: Can not open location in the cloud environment as a datasource.

You could also try use the Data source as Location instead of file and then supply S:\prod\LC\Logs\tm1server... as the Location. This is exactly what I am doing, data source is location and the location was specified as "S:\prod\LC\Logs\tm1server" i have tried with "..\LC\Logs\tm1ser...
by gmunoz
Mon Jul 29, 2024 10:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not open location in the cloud environment as a datasource.
Replies: 12
Views: 7315

Re: Can not open location in the cloud environment as a datasource.

MarenC wrote: Mon Jul 29, 2024 10:14 am Hi,

In IBM cloud you need to use the relative file path and not the S:, so something like ..\02 Logs\

Maren
Thank you very much!

So for the example on my post i should write as a location "..\Logs\tm1server" ?
by gmunoz
Mon Jul 29, 2024 9:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can not open location in the cloud environment as a datasource.
Replies: 12
Views: 7315

Can not open location in the cloud environment as a datasource.

Hi everyone. First a little bit of context. I am working for a company developing in Planning Analytics in cloud. We have a load process that transfers data from a data warehouse to a Cube. This process sometimes retrieves errors because the dimensions are not updated. Therefore, I want to send an e...