Search found 109 matches

by ardi
Mon Oct 19, 2020 11:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Replies: 4
Views: 957

Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1

Upgrading Oracle Client to Oracle 12 solves the problem. PA 2.0.9.1 does not seem to support older Oracle client versions. Thank you! We managed to find an ODBC driver that works but that is not a Native Oracle driver and it does not support some SQL statement (does not support Transaction COMMIT /...
by ardi
Fri Oct 16, 2020 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Replies: 4
Views: 957

Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1

Hello, We upgraded from 2.0.7 to 2.0.9.1 in a test environment for one of our clients. But TM1 server keeps crashing immediately when we execute TM1 processes connecting to Oracle DB via ODBC. Not only when executing the process, it crashes even when opening such processes in Architect. It happens ...
by ardi
Wed Jul 17, 2019 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create temp view and open them by returnviewhandle
Replies: 3
Views: 906

Re: Create temp view and open them by returnviewhandle

Unfortunately you cannot open a temporary view with returnviewhandle This is one of first things I tried when IBM introduced the Temp Views and Subsets. There are many other limitations of Temporary Views and subset, the biggest limitation i find is that their scope is only within the process where ...
by ardi
Wed Jan 24, 2018 4:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error viewing transaction log from Ops Console
Replies: 1
Views: 912

Re: Error viewing transaction log from Ops Console

Hi we are currently running TM1 10.2.2 FP4 (64bit). We are trying to test the latest version and having some issues. Installation is succcessfull, in single tier. However, when trying to view the transaction log, an error pop up. http://i.imgur.com/drdFT76l.jpg Click on OK. http://i.imgur.com/dG4qj...
by ardi
Wed Sep 28, 2016 5:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtering on Dimensions
Replies: 4
Views: 1580

Re: Filtering on Dimensions

You need to create cascading attributes on each dimension and then create a 2-dimensional cube, one of them being }Clients dimension and then in the websheet, write DBSS formulas to store the selected let`s say LOBNr to the 2-dimensional cube. Then for the Region Dimension, use an MDX subset that fi...
by ardi
Tue Sep 27, 2016 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.3 - Issues with rules in the }Groups and }Clients dims
Replies: 7
Views: 2382

Re: 10.3 - Issues with rules in the }Groups and }Clients dims

Thanks for sharing, it looks like TM1 Development team is in big trouble. I really miss the older versions of TM1 ( 9.4 and prior ). Every new version IBM has released, has created major impacts for us
by ardi
Tue Sep 27, 2016 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Specifying title location in hyperlinks
Replies: 6
Views: 1984

Re: Specifying title location in hyperlinks

Hi It may have been a fluke but when we tried this it only seemed to modify the first SUBNM that it encountered. We had other issues 10.2 so we have not gone much further with testing, but it appeared to be the SUBNM closest to the top left corner. Regards Paul Simon When I was using this approach,...
by ardi
Tue Sep 27, 2016 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX: Filter Parents but sort their Children
Replies: 3
Views: 2080

Re: MDX: Filter Parents but sort their Children

Does it make a difference because how could I sort the children? The "ORDER" MDX Command just uses the "Filtered" Elements which are the parents, so the Ordering takes no effect on the children... I tought of using a Subset Drilled down all Elements so I get the correct Attribute Order. That works ...
by ardi
Mon Sep 26, 2016 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Specifying title location in hyperlinks
Replies: 6
Views: 1984

Re: Specifying title location in hyperlinks

For example Title_S1-R3-C2=Canada will pass the Value Canada to the Cell in SHeet1, 3rd Row and Second Column Actually... just because TM1 likes to annoy us all the numbers are out by 1 - so the 1st sheet, 3rd row and second column would be: Title_S0-R2-C1 Thank you declanr, actually after I posted...
by ardi
Mon Sep 26, 2016 4:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Specifying title location in hyperlinks
Replies: 6
Views: 1984

Re: Specifying title location in hyperlinks

In this case I think you have to specify the Location of your SUBNM by specifying the Sheet#, Row# and Column#

Title_S#-R#-C#=ElementValue

For example Title_S1-R3-C2=Canada will pass the Value Canada to the Cell in SHeet1, 3rd Row and Second Column
by ardi
Thu Sep 22, 2016 7:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Union + Sort in MDX
Replies: 2
Views: 1995

Re: Union + Sort in MDX

Try this:

Code: Select all

{TM1SORT( UNION(
{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Transaction ID] )}, 0)},
{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Transaction ID] )}, 0)},ALL
) , ASC)}
by ardi
Thu Sep 22, 2016 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy data from one element to another element in a single dimension
Replies: 7
Views: 2378

Re: Copy data from one element to another element in a single dimension

I don't understand why you include your variable pDim and pDim1 in quotes. From what i understand from your code, you have 2 dimensions, one called p_Parameters and the other one p_Parameters_Version and then in your while loop you are trying to get the first 10 elements for each??? when then use th...
by ardi
Wed Sep 21, 2016 5:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 23179

Re: TM1 10.2.2 FP6

Another update regarding this. The Parameter MTQQuery=F, avoids the crash when the datasource view returns no data, but unfortunately now it created another bigger problem. If the data Source View contains consolidated cells, then when the parameter MTQQuery=F, it considers the view as an empty view...
by ardi
Wed Sep 21, 2016 1:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 23179

Re: TM1 10.2.2 FP6

I found a workaround for Turbo Integrator (TI) processes: - use the new function DisableMTQViewConstruct() in the Prolog if you use a view as a datasource: You can also disable the MTQ feature for all TI datasources globally by setting MTQQuery=F in your tm1s.cfg. The option doesn't appear to be do...
by ardi
Wed Sep 21, 2016 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy data from one element to another element in a single dimension
Replies: 7
Views: 2378

Re: Copy data from one element to another element in a single dimension

You Can use the EXPAND function

vDynamicVariableName = EXPAND( '%' | YOUR_EXPRESSION | '%' );
by ardi
Tue Sep 20, 2016 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 23179

Re: TM1 10.2.2 FP6

We made a huge mistake and upgraded to FP6 and now we are dealing with this bug. The server crashed 3 times this afternoon and after troubleshooting i found out it was relating to a TI Process that users an "empty" view as datasource for which the Skip COnsolidation option was disabled. Now we are h...
by ardi
Sun Sep 18, 2016 3:35 pm
Forum: Bugs
Topic: SR#11-82215321 - Excel - TM1 9.0 SP3 Build 182 - SUBNM
Replies: 3
Views: 13751

Re: SR#11-82215321 - Excel - TM1 9.0 SP3 Build 182 - SUBNM

This has been always an issue, even within a TI Process, there was no function to check if an element exists in a given subset, until the last Fix Pack ( 10.2.2 FP6 ), now there a new function to check for that
by ardi
Wed Jul 20, 2016 12:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Filter by string cell value (Updated)
Replies: 4
Views: 2560

Re: MDX Filter by string cell value

How many dimensions do you have in your Cube?
by ardi
Thu Jun 16, 2016 1:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is Advance editor not valid in TM1 10.2.2??
Replies: 4
Views: 1742

Re: Is Advance editor not valid in TM1 10.2.2??

Hi , Can anyone guide me I am stuck with classic editor in TM1 10.2.2. IBM told me that it is no more valid and I have to struggle with basic editor only :-(. Since it does not support 64 bit architect. How one anyone work in basic editor and that too in latest version??? :shock: It can be enabled ...
by ardi
Tue Jun 14, 2016 8:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Validation checks in TM1 same as EP??
Replies: 5
Views: 2065

Re: Data Validation checks in TM1 same as EP??

If you are using websheets you can apply Excel data Validation, which will work on TM1Web also.

For String Measures, you can use PickLists