Search found 64 matches

by vovanenok
Fri Mar 16, 2018 3:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on cube values for different dimension
Replies: 6
Views: 913

Re: MDX filter on cube values for different dimension

My first approach would be: {FILTER( {TM1SUBSETALL( [dim2] )}, [cube1].( [dim1].[([}ElementAttribute_dim2].([dim2].CurrentMember, [}ElementAttributes_dim2].[attr_dim1_elm_name]))], [cube1_measure].[value] ) > 0 )} untestetd especially with the brackets. Idea is to extract the Elementname as Element...
by vovanenok
Fri Mar 16, 2018 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on cube values for different dimension
Replies: 6
Views: 913

MDX filter on cube values for different dimension

Hi all To make it simple: I have 2 dimensions: dim1 and dim2 I also have a settings cube1 containing just 2 dimensions: - dim1 - cube1_measure dimensions cube1_measure dimension contains just one element: value In dim2 I have attribute attr_dim1_elm_name which contains dim1 element name related to d...
by vovanenok
Wed Nov 29, 2017 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form formatting calculated rules
Replies: 3
Views: 469

Re: Active Form formatting calculated rules

So after chatting with IBM support, the only found solution is to use Excel Conditional formatting. I tested it works as expected
by vovanenok
Tue Nov 28, 2017 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form formatting calculated rules
Replies: 3
Views: 469

Active Form formatting calculated rules

Hi all I have an active form perspectives report with TM1 Report Row in column B. Column A contains my formatting rule keys. I want to calculate a format key based on the values of active form cells. Let's say I get values in columns C and D using DBRW function. Then I calculate column E as the diff...
by vovanenok
Fri Oct 27, 2017 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding a subset to a dbrw
Replies: 7
Views: 986

Re: Adding a subset to a dbrw

Yeah i have done it , but not sure it will cause performance issues . I personally use this approach quite often. Especially if you need to see the total of some dynamically selected elements. For instance. You have "cube A" where you can set "exclusion flag" for elements from Dim1. Now you need to...
by vovanenok
Wed May 03, 2017 1:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Readiness" of IBM Planning Analytics Local
Replies: 0
Views: 510

"Readiness" of IBM Planning Analytics Local

Hi all
It's been a few months since IBM released IBM Planning Analytics Local. Could you please share your experience on trying it, thoughts on when to upgrade (how stable it is).
Thanks!
by vovanenok
Thu Feb 16, 2017 8:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question for Asciioutput
Replies: 13
Views: 1942

Re: Question for Asciioutput

Croder wrote:I have the consolidated Total member that was created being ruled to an N Level Element
What that means?
by vovanenok
Thu Feb 16, 2017 5:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple TM1Web URLs or instances
Replies: 3
Views: 765

Re: Multiple TM1Web URLs or instances

Finally found the easier way. In tm1_64\webapps\tm1web\scripts\tm1web\standalone\ TM1WebApp.js there is a piece of code which generates URL for CAM server: window.location.href=_a576+"?b_action=xts.run&m=portal/bridge.xts&c_env=portal/variables_TM1.xml&c_cmd=../tm1/web/tm1web.html&ps="+_a578+"&pg="+...
by vovanenok
Wed Feb 15, 2017 9:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple TM1Web URLs or instances
Replies: 3
Views: 765

Re: Multiple TM1Web URLs or instances

lotsaram wrote:Have you tried a search for "setting up multiple tomcat instances on a single server"?

It is different to IIS but quite well documented.
Well, I was hoping for some easier solution :)
Will try to follow your suggestion, thanks lotsaram
by vovanenok
Wed Feb 15, 2017 4:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple TM1Web URLs or instances
Replies: 3
Views: 765

Multiple TM1Web URLs or instances

Hi all I have a few TM1 model servers and would like users to access them through TM1Web using different URLs. I don't want to show the server selection dropdown (leaving "TM1ServerName" parameter empty in "tm1web_config.xml") simply because: 1). I don't want an extra step when logging in to TM1Web ...
by vovanenok
Sat Oct 22, 2016 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StringToNumber does not use locale decimal delimiter
Replies: 8
Views: 1468

Re: StringToNumber does not use locale decimal delimiter

Today I opened a PMR and had even a WebEx session with IBM. They agreed it seems like a bug with locales. Regarding DatasourceASCIIDecimalSeparator they offered to create a request for enhancement to support this variable in AsciiOutput (like it works with DatasourceASCIIDelimiter).
by vovanenok
Fri Oct 21, 2016 5:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 25699

Re: SSL breaks on Nov 24

did you upgrade certificates on the client machine?
by vovanenok
Fri Oct 21, 2016 5:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StringToNumber does not use locale decimal delimiter
Replies: 8
Views: 1468

Re: StringToNumber does not use locale decimal delimiter

So DatasourceASCIIDecimalSeparator does not use decimal separator from user's locale, but NumberToString does TI processes do not interact with the user for anything other than status updates so they cannot use anything from the user's locale (as was stated earlier by Declan). They use the locale o...
by vovanenok
Fri Oct 21, 2016 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StringToNumber does not use locale decimal delimiter
Replies: 8
Views: 1468

Re: StringToNumber does not use locale decimal delimiter

babytiger wrote:I tend to use NUMBR function for converting strings to numbers.
The string you want to convert to a number. All characters other than '0' through '9', '+', '-', '.', and 'E' are ignored.
NUMBR fails converting this string: "-"
by vovanenok
Fri Oct 21, 2016 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StringToNumber does not use locale decimal delimiter
Replies: 8
Views: 1468

Re: StringToNumber does not use locale decimal delimiter

Is the transfer into text file necessary? For example, cross TM1 instance? Is cube to cube an option? As I explained before, in this particular case I can load data directly to my target cube. But in some cases I need to use file export. The issue is that with TM1 web the process is not able tonpic...
by vovanenok
Thu Oct 20, 2016 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StringToNumber does not use locale decimal delimiter
Replies: 8
Views: 1468

StringToNumber does not use locale decimal delimiter

Hi all I have an issue when some user with French Windows Regional Settings runs a process (actually clicks a button in TM1Web to run that process). The process exports data to a tab delimited file, then another process imports it back to TM1 cube. Initially I used NumberToString function to export ...
by vovanenok
Thu Oct 20, 2016 1:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL breaks on Nov 24 (TM1 SSL Certificates Expire on 24 November)
Replies: 164
Views: 25699

Re: SSL breaks on Nov 24

Thanks for your reply As I have mentioned before we have updated the SSL certificates in the TM1 application server ,Now It shows up expiry date 17 June 2016 to 15th Jun,2024 by following steps given by below link. Link: http://www-01.ibm.com/support/docview.w ... wg21991546 Same steps we are follo...
by vovanenok
Tue May 03, 2016 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTROW driving dimension
Replies: 3
Views: 1051

Re: TM1RPTROW driving dimension

Thanks lotsaram By dimension 1 and dimension 2 I meant dimensions in two TM1RPTROW formulas and as those are both row dimensions that's impossible to reference CurrentMember because those two TM1RPTROW functions cannot interact with each other. Does TM1RptRow have to use a dimension from the cube re...
by vovanenok
Tue May 03, 2016 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTROW driving dimension
Replies: 3
Views: 1051

TM1RPTROW driving dimension

Hi all I need to build an active form looping two dimensions. The initial idea was to use 2 TM1RPTROW functions, but the problem is I need to filter dimension2 element based on the current element of dimension1 and AFAIK that's impossible. Another solution would be to build a flag cube, but I'm wond...
by vovanenok
Fri Apr 22, 2016 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder issue
Replies: 7
Views: 1005

Re: Feeder issue

Feeders are substitute DATA. Therefore it is critical to realize feeders only exist for leaf cells. Putting C element on the left hand side of a feeder is shorthand for all ultimate N element descendants of the C element. On the right hand side the element name evaluated by !dimension are the leave...